X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fcc03%2Fcc6-03.sql;fp=sql%2Fcc03%2Fcc6-03.sql;h=54265f1b311c936afa1d7867e5701cccd362b12b;hb=4d850240c7ff389bf6ad596287abb7d542af72bb;hp=0000000000000000000000000000000000000000;hpb=69e91c419df45838d7c85633b10d0998f0f92f7a;p=ccbs diff --git a/sql/cc03/cc6-03.sql b/sql/cc03/cc6-03.sql new file mode 100644 index 0000000..54265f1 --- /dev/null +++ b/sql/cc03/cc6-03.sql @@ -0,0 +1,2300 @@ +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 6', + (SELECT country FROM countries WHERE countryname='Norway'), + 'Oslo Bowling', + '2003-11-02', + (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 6' 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 6' 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 6' 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, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, + (SELECT player FROM players WHERE nick='OJK'), + 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 6' 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, '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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, + (SELECT player FROM players WHERE nick='RiChY'), + 60); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 7, + (SELECT player FROM players WHERE nick='Havok'), + 55); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 8, + (SELECT player FROM players WHERE nick='Draconia'), + 51); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 9, + (SELECT player FROM players WHERE nick='T|na'), + 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 6' 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, '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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 11, + (SELECT player FROM players WHERE nick='Mulefisk'), + 45); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 12, + (SELECT player FROM players WHERE nick='Smiph'), + 44); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 13, + (SELECT player FROM players WHERE nick='Matsi'), + 43); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 14, + (SELECT player FROM players WHERE nick='Spinnvill'), + 42); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 15, + (SELECT player FROM players WHERE nick='Electus'), + 41); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 16, + (SELECT player FROM players WHERE nick='Purity'), + 40); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 17, + (SELECT player FROM players WHERE nick='kjmcw'), + 39); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 18, + (SELECT player FROM players WHERE nick='Advena'), + 38); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 19, + (SELECT player FROM players WHERE nick='DiJam'), + 37); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 20, + (SELECT player FROM players WHERE nick='Tha Dragon'), + 36); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Suspect' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Suspect' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 21, + (SELECT player FROM players WHERE nick='Suspect'), + 35); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nevrosert' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nevrosert' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 22, + (SELECT player FROM players WHERE nick='Nevrosert'), + 34); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 23, + (SELECT player FROM players WHERE nick='Private Ryan'), + 33); +INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 24, + (SELECT player FROM players WHERE nick='Haz'), + 32); +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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 25, + (SELECT player FROM players WHERE nick='Pfxp'), + 31); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Nevrosert'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Nevrosert'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Nevrosert'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 4579); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Nevrosert'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6735); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Tha Dragon'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Tha Dragon'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 3063); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Tha Dragon'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 3907); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Tha Dragon'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')), + 't', + 6015); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Matsi'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Matsi'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')), + 'f', + 4471); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Matsi'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')), + 'f', + 5120); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Matsi'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), + 't', + 6472); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 1, + (SELECT player FROM players WHERE nick='Smiph'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('The Reflex')), + 'f', + 3374); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Ending Story')), + 'f', + 4974); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Crash!')), + 't', + 6833); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('The Reflex')), + 'f', + 5105); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Never Ending Story')), + 'f', + 6425); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Healing Vision (Angelic Mix)')), + 't', + 7918); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='DiJam'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='DiJam'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 4795); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='DiJam'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 5745); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='DiJam'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6438); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Pfxp'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Pfxp'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5122); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Pfxp'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 5613); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Pfxp'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 6071); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Mulefisk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')), + 'f', + 5092); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Mulefisk'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')), + 'f', + 5619); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='Mulefisk'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), + 't', + 7482); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 2, + (SELECT player FROM players WHERE nick='RiChY'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Let Them Move')), + 'f', + 5549); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Silent Hill')), + 'f', + 5579); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Healing Vision (Angelic Mix)')), + 't', + 7492); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Let Them Move')), + 'f', + 6292); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Silent Hill')), + 'f', + 6455); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('era (nostalmix)')), + 't', + 7512); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='T|na'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 6101); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 7638); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='T|na'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8212); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Private Ryan'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Private Ryan'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 4884); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Private Ryan'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 6640); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Private Ryan'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 5627); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Purity'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Purity'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 5224); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Purity'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8142); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Purity'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7182); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Telc'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Telc'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 6315); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Telc'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 6768); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='Telc'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7803); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Memories')), + 'f', + 6462); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 'f', + 8197); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 3, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), + 't', + 7749); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Haz'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Haz'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 4206); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Haz'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 5117); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Haz'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 6097); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Advena'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 4552); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Advena'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 6761); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Advena'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 7122); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Spinnvill'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 5297); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Spinnvill'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 6698); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Spinnvill'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7428); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 5886); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 7052); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Havok'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7403); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), + 'f', + 6276); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 'f', + 7016); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 4, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 't', + 7674); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Suspect'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Suspect'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), + 'f', + 4749); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Suspect'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 5535); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Suspect'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7480); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), + 'f', + 5216); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 7478); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='OJK'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7440); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Electus'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Electus'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), + 'f', + 4956); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Electus'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 6523); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (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', + 8158); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')), + 'f', + 4696); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('B4U')), + 'f', + 6963); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='kjmcw'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 7478); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 1, 5, + (SELECT player FROM players WHERE nick='Draconia'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('That was then, This is now')), + 'f', + 5121); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('B4U')), + 'f', + 6597); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')), + 't', + 7531); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (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 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mulefisk'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mulefisk'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 6104); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mulefisk'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 5800); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Mulefisk'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7497); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Draconia'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Afronova Primeval')), + 'f', + 6640); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Don\'t Try to Stop It')), + 'f', + 5838); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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', + 7693); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Electus'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Electus'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 0); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Electus'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 5518); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='Electus'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 6586); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 7084); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6231); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='T|na'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), + 't', + 7003); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='DufF'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')), + 'f', + 8044); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='DufF'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), + 'f', + 6939); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 1, + (SELECT player FROM players WHERE nick='DufF'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), + 't', + 8044); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Spinnvill'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Spinnvill'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 5348); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Spinnvill'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 6667); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Spinnvill'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 't', + 7092); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Telc'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7067); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Telc'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 7499); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Telc'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')), + 't', + 7200); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 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 6' 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('Spin the disc')), + 'f', + 7316); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Paranoia KCET (Clean Mix)')), + 'f', + 7914); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('PARANOiA Rebirth')), + 't', + 7968); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='OJK'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7171); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8143); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='OJK'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 8035); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), + 'f', + 7546); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 'f', + 8540); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 2, + (SELECT player FROM players WHERE nick='Tom'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), + 't', + 7579); +INSERT INTO groups (tournament, round, parallel) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7067); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 4574); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Smiph'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 6972); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Matsi'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')), + 'f', + 6614); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')), + 'f', + 4664); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7239); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Havok'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 7493); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Havok'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 5199); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Havok'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 6946); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')), + 'f', + 8643); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')), + 'f', + 5987); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Hypnotic Crisis')), + 't', + 8007); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Oliyzia'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Oliyzia'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), + 'f', + 8235); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Oliyzia'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 5712); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 2, 3, + (SELECT player FROM players WHERE nick='Oliyzia'), + 2, + (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), + 't', + 8043); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5247); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7963); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='Draconia'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')), + 'f', + 4997); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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', + 7806); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 5585); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8046); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='T|na'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='T|na'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 4722); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='T|na'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7414); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Higher')), + 'f', + 6101); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8151); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Higher')), + 'f', + 6374); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Tsugaru')), + 't', + 8150); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')), + 'f', + 6012); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')), + 't', + 8134); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 3, 0, + (SELECT player FROM players WHERE nick='Tom'), + 8 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Higher')), + 'f', + 6193); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')), + 't', + 8323); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Higher')), + 'f', + 6014); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Trip Machine Climax')), + 't', + 8113); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 4624); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='Havok'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), + 't', + 7303); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 5038); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='RiChY'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 8737); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Secret Rendez-vous')), + 'f', + 6178); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')), + 't', + 8278); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Secret Rendez-vous')), + 'f', + 5631); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Afronova')), + 't', + 8194); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 5 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), + 'f', + 5441); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), + 't', + 8342); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Secret Rendez-vous')), + 'f', + 5932); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Crash!')), + 't', + 8353); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 7 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Secret Rendez-vous')), + 'f', + 6227); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Dead End')), + 't', + 7896); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 5, 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('D2R')), + 'f', + 5833); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), + 't', + 8295); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')), + 'f', + 5640); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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', + 8142); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 5, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('D2R')), + 'f', + 5816); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Paranoia KCET (Clean Mix)')), + 't', + 8256); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('D2R')), + 'f', + 6030); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 8613); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('D2R')), + 'f', + 6287); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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', + 8418); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 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 6' 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('So Deep (Perfect Sphere Mix)')), + 'f', + 7185); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Crash!')), + 't', + 7885); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 2 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 0, + (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), + 'f', + 6497); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + 1, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), + 't', + 7496); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 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 6' 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('So Deep (Perfect Sphere Mix)')), + 'f', + 8261); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Jam Jam Reggae (AM Swing Mix)')), + 't', + 7507); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + 4 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('So Deep (Perfect Sphere Mix)')), + 'f', + 8308); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('PARANOiA Rebirth')), + 't', + 8328); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 7, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')) +); +UPDATE rounds SET randomsongs=1 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' 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 6' 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('Cotton-Eye Joe')), + 'f', + 6422); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Can\'t Stop Fallin\' in Love (SPEED MIX)')), + 't', + 7716); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 7, 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 6' 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('Cotton-Eye Joe')), + 'f', + 6333); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Exotic Ethnic')), + 't', + 8812); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + 3 +); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Cotton-Eye Joe')), + 'f', + 6287); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Electro Tuned (the SubS Mix)')), + 't', + 8596); +INSERT INTO rounds (tournament, round, randomsongs, chosensongs) + VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 8, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')) +); +INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )), + 8, 0, + (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) +); +UPDATE rounds SET randomsongs=2 WHERE + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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 6' 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('Never Let You Down')), + 'f', + 6751); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Max 300')), + 'f', + 8548); +INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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 6' 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('Never Let You Down')), + 'f', + 6756); +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' 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('Max 300')), + 'f', + 8753); +commit;