(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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);
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),