X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc6-04.sql;h=c1823f7363e75e21b8fd15cd4b4441e2b97f0295;hp=a489a0b9e698144fff1d30da5fde5c993a6d6fa3;hb=1c54093a61bb4f6633bc7649e72a33a2ccb3bb40;hpb=e81c2d9126e54860c49eb224f44dc50467790e84 diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql index a489a0b..c1823f7 100644 --- a/sql/cc04/cc6-04.sql +++ b/sql/cc04/cc6-04.sql @@ -54,6 +54,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 1, + (SELECT player FROM players WHERE nick='Pyro'), + (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'), @@ -75,6 +82,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 1, + (SELECT player FROM players WHERE nick='Th0rny'), + (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'), @@ -96,6 +110,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 1, + (SELECT player FROM players WHERE nick='Glukko'), + (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'), @@ -117,6 +138,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 1, + (SELECT player FROM players WHERE nick='Daniil'), + (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'), @@ -138,6 +166,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 1, + (SELECT player FROM players WHERE nick='Snofox'), + (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'), @@ -159,6 +194,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 1, + (SELECT player FROM players WHERE nick='Snute'), + (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'), 1, 2); @@ -199,6 +241,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 2, + (SELECT player FROM players WHERE nick='Glock'), + (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'), @@ -220,6 +269,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 2, + (SELECT player FROM players WHERE nick='Athena'), + (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'), @@ -241,6 +297,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 2, + (SELECT player FROM players WHERE nick='Matsi'), + (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'), @@ -262,6 +325,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 2, + (SELECT player FROM players WHERE nick='Bonzo'), + (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'), @@ -283,6 +353,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 2, + (SELECT player FROM players WHERE nick='Smiph'), + (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'), @@ -304,6 +381,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 2, + (SELECT player FROM players WHERE nick='DufF'), + (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'), 1, 3); @@ -344,6 +428,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='Ifrit'), + (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'), @@ -365,6 +456,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='ViD'), + (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'), @@ -386,6 +484,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='Hyper'), + (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'), @@ -407,6 +512,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='Andeplane'), + (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'), @@ -428,6 +540,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='Gogo'), + (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'), @@ -449,6 +568,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='Duckling'), + (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'), @@ -470,6 +596,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 3, + (SELECT player FROM players WHERE nick='OJK'), + (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'), 1, 4); @@ -510,6 +643,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Electron'), + (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'), @@ -531,6 +671,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Guru'), + (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'), @@ -552,6 +699,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Annkakri'), + (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'), @@ -573,6 +727,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Felz'), + (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'), @@ -594,6 +755,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Draconia'), + (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'), @@ -615,6 +783,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Ylini'), + (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'), @@ -636,6 +811,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 4, + (SELECT player FROM players WHERE nick='Haggar'), + (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'), 1, 5); @@ -676,6 +858,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='Goku'), + (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'), @@ -697,6 +886,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='Montana'), + (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'), @@ -718,6 +914,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='JonAnders'), + (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'), @@ -739,6 +942,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='Alexxz'), + (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'), @@ -760,6 +970,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='Pingo'), + (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'), @@ -781,6 +998,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='Nameless'), + (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'), @@ -802,6 +1026,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 5, + (SELECT player FROM players WHERE nick='RiChY'), + (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'), 1, 6); @@ -842,6 +1073,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='Matti'), + (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'), @@ -863,6 +1101,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='v|per'), + (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'), @@ -884,6 +1129,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='Zackie'), + (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'), @@ -905,6 +1157,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='Mync'), + (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'), @@ -926,6 +1185,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='Ozon'), + (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'), @@ -947,6 +1213,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='T|na'), + (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'), @@ -968,6 +1241,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 1, 6, + (SELECT player FROM players WHERE nick='Oliyzia'), + (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'), @@ -1013,6 +1293,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 1, + (SELECT player FROM players WHERE nick='Daniil'), + (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'), @@ -1034,6 +1321,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 1, + (SELECT player FROM players WHERE nick='ViD'), + (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'), @@ -1055,6 +1349,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 1, + (SELECT player FROM players WHERE nick='Ylini'), + (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'), @@ -1076,6 +1377,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 1, + (SELECT player FROM players WHERE nick='Bonzo'), + (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'), @@ -1097,6 +1405,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 1, + (SELECT player FROM players WHERE nick='Snute'), + (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'), @@ -1118,6 +1433,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 1, + (SELECT player FROM players WHERE nick='Gogo'), + (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'), 2, 2); @@ -1158,6 +1480,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 2, + (SELECT player FROM players WHERE nick='Felz'), + (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'), @@ -1179,6 +1508,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 2, + (SELECT player FROM players WHERE nick='Mync'), + (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'), @@ -1200,6 +1536,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 2, + (SELECT player FROM players WHERE nick='OJK'), + (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'), @@ -1221,6 +1564,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 2, + (SELECT player FROM players WHERE nick='T|na'), + (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'), @@ -1242,6 +1592,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 2, + (SELECT player FROM players WHERE nick='DufF'), + (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'), @@ -1263,6 +1620,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 2, + (SELECT player FROM players WHERE nick='Nameless'), + (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'), 2, 3); @@ -1303,6 +1667,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 3, + (SELECT player FROM players WHERE nick='Smiph'), + (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'), @@ -1324,6 +1695,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 3, + (SELECT player FROM players WHERE nick='RiChY'), + (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'), @@ -1345,6 +1723,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 3, + (SELECT player FROM players WHERE nick='Snofox'), + (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'), @@ -1366,6 +1751,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 3, + (SELECT player FROM players WHERE nick='Pingo'), + (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'), @@ -1387,6 +1779,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 3, + (SELECT player FROM players WHERE nick='Haggar'), + (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'), @@ -1408,6 +1807,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 2, 3, + (SELECT player FROM players WHERE nick='Oliyzia'), + (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'), @@ -1441,6 +1847,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Nameless'), + (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'), @@ -1455,6 +1868,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + (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'), @@ -1469,6 +1889,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Bonzo'), + (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'), @@ -1483,6 +1910,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Ylini'), + (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'), @@ -1497,6 +1931,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='OJK'), + (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'), @@ -1511,6 +1952,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Snofox'), + (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'), @@ -1525,6 +1973,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='DufF'), + (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'), @@ -1539,6 +1994,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Snute'), + (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'), @@ -1553,6 +2015,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 3, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (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'), @@ -1586,6 +2055,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='Nameless'), + (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'), @@ -1600,6 +2076,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + (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'), @@ -1614,6 +2097,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='Haggar'), + (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'), @@ -1628,6 +2118,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='Snofox'), + (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'), @@ -1642,6 +2139,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='DufF'), + (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'), @@ -1656,6 +2160,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='OJK'), + (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'), @@ -1670,6 +2181,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 4, 0, + (SELECT player FROM players WHERE nick='Snute'), + (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'), @@ -1703,6 +2221,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 5, 0, + (SELECT player FROM players WHERE nick='Snofox'), + (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'), @@ -1717,6 +2242,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 5, 0, + (SELECT player FROM players WHERE nick='DufF'), + (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'), @@ -1731,6 +2263,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 5, 0, + (SELECT player FROM players WHERE nick='OJK'), + (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'), @@ -1745,6 +2284,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 5, 0, + (SELECT player FROM players WHERE nick='Oliyzia'), + (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'), @@ -1759,6 +2305,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 5, 0, + (SELECT player FROM players WHERE nick='Snute'), + (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'), @@ -1792,6 +2345,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 6, 0, + (SELECT player FROM players WHERE nick='OJK'), + (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'), @@ -1806,6 +2366,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 6, 0, + (SELECT player FROM players WHERE nick='Snofox'), + (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'), @@ -1820,6 +2387,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 6, 0, + (SELECT player FROM players WHERE nick='DufF'), + (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'), @@ -1834,6 +2408,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 6, 0, + (SELECT player FROM players WHERE nick='Snute'), + (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'), @@ -1867,6 +2448,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 7, 0, + (SELECT player FROM players WHERE nick='OJK'), + (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'), @@ -1881,6 +2469,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 7, 0, + (SELECT player FROM players WHERE nick='DufF'), + (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'), @@ -1895,6 +2490,13 @@ INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VA (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'), + 7, 0, + (SELECT player FROM players WHERE nick='Snute'), + (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'),