X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc6-04.sql;h=8c6fcdf6d8273dfc109a30cc2d8336fad2f034f7;hp=c1823f7363e75e21b8fd15cd4b4441e2b97f0295;hb=4ddc2d1937960d5cf4017644a41433eac2f6f391;hpb=1c54093a61bb4f6633bc7649e72a33a2ccb3bb40 diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql index c1823f7..8c6fcdf 100644 --- a/sql/cc04/cc6-04.sql +++ b/sql/cc04/cc6-04.sql @@ -1,2562 +1,2916 @@ begin; INSERT INTO tournaments - (season, name, country, location, "date", machine, scoringsystem) VALUES ( - (SELECT season FROM seasons WHERE name='Challenge Cup 2004'), + (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES ( + (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'), 'Challenge Cup 6', - (SELECT country FROM countries WHERE name='Norway'), + (SELECT country FROM countries WHERE countryname='Norway'), 'Fredrikstad Mestern Bowling', '2004-10-24', - (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'), - (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score') -); + (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), + (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') +); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 1, 'Snute', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 2, 'DufF', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 3, 'OJK', 81); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 4, 'Snofox', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 5, 'Oliyzia', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 6, 'Haggar', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 7, 'Nameless', 55); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 8, 'Ylini', 51); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 9, 'Bonzo', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 10, 'T|na', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 11, 'Daniil', 45); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 12, 'Pingo', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 13, 'RiChY', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 14, 'ViD', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 15, 'Felz', 41); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 16, 'Gogo', 40); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 17, 'Smiph', 39); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 18, 'Mync', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 19, 'Duckling', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 20, 'Goku', 36); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 21, 'Th0rny', 35); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 22, 'Matsi', 34); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 23, 'Draconia', 33); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 24, 'Ozon', 32); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 25, 'Andeplane', 31); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 26, 'Alexxz', 30); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 27, 'Electron', 29); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 28, 'Pyro', 28); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 29, 'Matti', 27); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 30, 'Athena', 26); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 31, 'Hyper', 25); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 32, 'Zackie', 24); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 33, 'Montana', 23); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 34, 'Annkakri', 22); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 35, 'Glukko', 21); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 36, 'Glock', 20); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 37, 'v|per', 19); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 38, 'Ifrit', 18); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 39, 'JonAnders', 17); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 40, 'Guru', 16); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 5540); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5501); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Pyro'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7419); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Th0rny'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Th0rny'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 6512); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Th0rny'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6227); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Th0rny'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8128); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Glukko'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Glukko'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 4245); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Glukko'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 5710); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Glukko'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')), 't', 6217); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Daniil'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 6454); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6776); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 7682); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 6948); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 6685); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snofox'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 7879); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')), 'f', 7506); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')), 'f', 7370); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 1, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')), 't', 7850); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Higher')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 4122); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 4862); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Glock'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')), 't', 6209); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Athena'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Athena'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 4533); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Athena'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 4915); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Athena'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6770); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5130); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6092); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Matsi'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8000); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Bonzo'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 6490); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6430); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8087); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 5325); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 5959); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8164); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Higher')), 'f', 6723); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')), 'f', 6834); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 2, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7948); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Ifrit'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Ifrit'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 3057); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Ifrit'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 4486); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Ifrit'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6459); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='ViD'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='ViD'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8517); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='ViD'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6820); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='ViD'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8600); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Hyper'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Hyper'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 7935); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Hyper'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 5109); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Hyper'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7931); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Andeplane'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Andeplane'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 7938); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Andeplane'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 5713); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Andeplane'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8175); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8841); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 7573); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Gogo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7759); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Duckling'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Duckling'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8650); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Duckling'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 6988); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='Duckling'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7904); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 'f', 8893); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('DXY!')), 'f', 7599); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 3, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')), 't', 7661); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Electron'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Electron'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 5545); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Electron'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 5420); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Electron'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 7443); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Guru'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Guru'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 5318); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Guru'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 4598); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Guru'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 4905); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Annkakri'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Annkakri'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 4415); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Annkakri'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 4341); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Annkakri'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 6245); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Felz'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Felz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 6274); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Felz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 5600); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Felz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8080); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 5075); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 6218); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Draconia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 7977); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Ylini'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 6801); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 5958); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')), 't', 7425); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')), 'f', 7178); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')), 'f', 6748); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 4, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 't', 7973); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Goku'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Goku'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5857); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Goku'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5900); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Goku'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 't', 8359); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Montana'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Montana'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5411); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Montana'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 4624); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Montana'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 6637); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='JonAnders'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='JonAnders'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 4643); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='JonAnders'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 4202); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='JonAnders'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')), 't', 5502); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6074); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6053); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Alexxz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7984); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Pingo'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6413); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6100); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Pingo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8393); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Nameless'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 6518); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 6543); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8218); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')), 'f', 5975); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Living in America')), 'f', 5993); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 5, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8380); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT song FROM songs WHERE lower(title)=lower('20th November')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=1; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Matti'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Matti'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6024); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Matti'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 5382); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Matti'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 6848); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='v|per'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='v|per'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 5783); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='v|per'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 5011); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='v|per'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 6587); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Zackie'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Zackie'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 5507); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Zackie'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 4324); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Zackie'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 7930); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Mync'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 6750); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 5565); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Mync'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8405); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7482); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 5751); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Ozon'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 7400); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7036); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 6416); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8174); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')), 'f', 7381); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('20th November')), 'f', 6500); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 1, 6, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8217); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=2; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6540); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7085); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Daniil'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8642); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='ViD'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='ViD'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6437); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='ViD'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7492); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='ViD'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8193); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Ylini'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6534); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7877); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Ylini'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8246); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6464); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 7370); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Bonzo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8578); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6899); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 8498); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Snute'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')), 't', 7791); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')), 'f', 6182); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')), 'f', 6574); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 1, (SELECT player FROM players WHERE nick='Gogo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8746); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Memories')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=2; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Felz'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Felz'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 5421); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Felz'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), 'f', 5171); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Felz'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 7990); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Mync'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Mync'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 5685); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Mync'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), 'f', 4738); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Mync'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Afronova')), 't', 7743); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6952); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), 'f', 6567); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='OJK'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 't', 8418); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 6339); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), 'f', 5690); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='T|na'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8644); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='DufF'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7547); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), 'f', 6182); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='DufF'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')), 't', 8377); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7228); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')), 'f', 5429); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 2, (SELECT player FROM players WHERE nick='Nameless'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Dead End')), 't', 8230); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=2; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=2; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Smiph'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Smiph'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 6286); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Smiph'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 7291); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Smiph'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8168); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7500); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8560); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='RiChY'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 7971); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 8198); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8719); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Snofox'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8686); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 7920); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8333); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Pingo'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8544); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 8713); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8720); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Haggar'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8793); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 'f', 8307); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 'f', 8545); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 2, 3, (SELECT player FROM players WHERE nick='Oliyzia'), + 2, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8190); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=3; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=3; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8064); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8627); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8296); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8550); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Bonzo'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8207); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Bonzo'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8133); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8015); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Ylini'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8414); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8704); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8635); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8494); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8459); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8755); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8367); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), 8 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8769); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')), 't', 8743); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), 9 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')), 'f', 8631); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 3, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')), 't', 8251); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=4; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=4; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6585); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Nameless'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8675); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 7296); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')), 't', 8557); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6862); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Haggar'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8753); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6871); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8802); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 6848); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')), 't', 8826); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), 6 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 7316); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')), 't', 8493); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), 7 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')), 'f', 7651); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 4, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')), 't', 8673); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=5; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=5; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6649); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8825); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6860); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8636); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6603); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8868); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6652); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Oliyzia'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8169); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), 5 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')), 'f', 6675); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 5, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')), 't', 8939); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=6; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=6; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), 'f', 5446); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 't', 8499); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='Snofox'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='Snofox'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), 'f', 5477); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='Snofox'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8241); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), 'f', 6489); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')), 't', 8776); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), 4 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')), 'f', 6480); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 6, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')), 't', 8849); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')) ); UPDATE rounds SET randomsongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=7; UPDATE rounds SET chosensongs=1 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=7; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7282); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='OJK'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Candy')), 't', 8841); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7327); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Crash!')), 't', 8803); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), 3 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Memories')), 'f', 7717); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 7, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')), 't', 8717); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, 0); INSERT INTO groups (tournament, round, parallel) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT song FROM songs WHERE lower(title)=lower('Destiny')) ); INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')) ); UPDATE rounds SET randomsongs=2 WHERE - tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND + tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND round=8; INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), 1 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Destiny')), 'f', 5834); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT player FROM players WHERE nick='DufF'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9140); INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players ); INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), 2 ); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 0, (SELECT song FROM songs WHERE lower(title)=lower('Destiny')), 'f', 6579); -INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES ( - (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'), +INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), 8, 0, (SELECT player FROM players WHERE nick='Snute'), + 1, (SELECT song FROM songs WHERE lower(title)=lower('Max 300')), 'f', 9681);