(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
'f',
0);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Eruanna'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 6966);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
'f',
6152);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Andeplane'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 7108);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
'f',
5352);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Zeila'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 7198);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
'f',
7590);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8352);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
'f',
6831);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Bonzo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 7766);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
'f',
7576);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+ 't',
+ 7626);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1, 2);
(SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
'f',
4361);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Chimera'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 5565);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
'f',
6262);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Alexxz'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7712);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
'f',
6603);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8273);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
'f',
7596);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Duckling'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 7879);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
'f',
7084);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Pingo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8287);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
'f',
8406);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 7950);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1, 3);
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
'f',
4028);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Mickva'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 5991);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
'f',
4843);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Havok'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 7321);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
'f',
5815);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Felz'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 7912);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
'f',
5942);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Mync'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 8607);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
'f',
6570);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Gogo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 7713);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
'f',
6463);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 't',
+ 7926);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1, 4);
(SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
'f',
4881);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Ingviild'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 6608);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
'f',
5443);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Ngan'),
+ (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+ 't',
+ 5594);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
'f',
6291);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Cuivien'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 8215);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
'f',
6442);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Daniil'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8048);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
'f',
6436);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 8156);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
'f',
6351);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 4,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 8482);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1, 5);
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
6617);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='Maxion'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
+ 't',
+ 5844);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
6631);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='Lindaninja'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7569);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
6061);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='Asphodel'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7656);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
7520);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='Cehtna'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 't',
+ 7030);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
7930);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 7759);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
'f',
7758);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
+ 't',
+ 7463);
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 5 - NM'),
(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 5 - NM'),
+ 1, 5,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
+ 't',
+ 8195);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1, 6);
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
5292);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Athena'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 6141);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
5618);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Andre'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 6345);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
5008);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Marilla'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 6534);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
6589);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Ozon'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 8005);
INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
6176);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Haanz'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 7953);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
8064);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Nameless'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 't',
+ 7648);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
'f',
7686);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 1, 6,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 7587);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
'f',
7553);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Bonzo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8550);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
'f',
7442);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Mync'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8239);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
'f',
8478);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 't',
+ 8785);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
'f',
7626);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Daniil'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 8773);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
'f',
8640);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 't',
+ 8773);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
'f',
7952);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 1,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 't',
+ 8653);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2, 2);
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
'f',
6369);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Ozon'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8251);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
'f',
6971);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8504);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
'f',
6863);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8476);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
'f',
6938);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 2,
+ (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',
+ 8378);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
'f',
7037);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 2,
+ (SELECT player FROM players WHERE nick='Nameless'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8454);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
'f',
6748);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 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',
+ 8457);
INSERT INTO groups (tournament, round, parallel) VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2, 3);
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8037);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 3,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8235);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8011);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 3,
+ (SELECT player FROM players WHERE nick='Pingo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 8558);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8240);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 3,
+ (SELECT player FROM players WHERE nick='Gogo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8820);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8158);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 3,
+ (SELECT player FROM players WHERE nick='Duckling'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8486);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
7795);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 3,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8495);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8658);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 2, 3,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+ 't',
+ 8677);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8665);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8561);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8071);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Pingo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8262);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8651);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8731);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
7787);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8652);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8492);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8654);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8267);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Gogo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8734);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8565);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Nameless'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8643);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8580);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
+ 't',
+ 8693);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
'f',
8805);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 't',
+ 8819);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6387);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Gogo'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 't',
+ 7925);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6883);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 8820);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6593);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Nameless'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 8561);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6498);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8723);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6765);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8606);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6536);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+ 't',
+ 8855);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
'f',
6884);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8757);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
7858);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8472);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
8682);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8800);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
8257);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8754);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
8741);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 5, 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',
+ 8766);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
'f',
8403);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 8604);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
'f',
8198);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 9195);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
'f',
7744);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8691);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
'f',
8365);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
+ 't',
+ 8600);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
'f',
8455);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 8875);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
'f',
8550);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8972);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
'f',
8763);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8905);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
'f',
8516);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Haggar'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 8070);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
'f',
6621);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 8, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 8891);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
'f',
6634);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 8, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 9672);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Higher')),
'f',
5271);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 9, 0,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 7905);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Higher')),
'f',
5683);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 9, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8381);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Higher')),
'f',
5509);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 9, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8471);
INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
VALUES (
(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8343);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 10, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
+ 't',
+ 8674);
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 5 - NM'),
(SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
'f',
8013);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
+ 10, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 7325);
commit;
projects / ccbs / blobdiff