(SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
'f',
4251);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Bush'),
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 't',
+ 5910);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
'f',
6242);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ (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, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
'f',
6659);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+ 't',
+ 7572);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
'f',
6702);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 7631);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
'f',
7616);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
+ 't',
+ 6839);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1, 2);
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
3845);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Dabi'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 6484);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
6329);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8032);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
6336);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 7544);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
7672);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+ 't',
+ 8167);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
8426);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+ 't',
+ 8392);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1, 3);
(SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
'f',
4014);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 6940);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
'f',
0);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 7524);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
'f',
6284);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Havok'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
+ 't',
+ 4399);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
'f',
8076);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+ 't',
+ 7735);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
'f',
8303);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+ 't',
+ 8625);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
7286);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7657);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
7814);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7986);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
7747);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+ 't',
+ 7721);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
8215);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8053);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
8529);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8570);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
8478);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 8174);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
8743);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 't',
+ 8447);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
8695);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 't',
+ 8440);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
8798);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 't',
+ 8500);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
7698);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 7874);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
8241);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8574);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
8139);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8403);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
8661);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8456);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
8272);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 8353);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
8783);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+ 't',
+ 8673);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
'f',
8633);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 8584);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
'f',
5706);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8583);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
'f',
5726);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8056);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
'f',
5553);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8525);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
'f',
5822);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+ 't',
+ 8460);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
'f',
5922);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8725);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
'f',
6450);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8236);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
'f',
6742);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8728);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
'f',
6605);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 8534);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
'f',
6689);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8828);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
'f',
7343);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8871);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
'f',
7152);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8718);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
'f',
6908);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 9276);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
'f',
8662);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8776);
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 2'),
(SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
'f',
8676);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8831);
commit;