2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
5 'Challenge Cup 5 - NM',
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
23 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
40 (SELECT player FROM players WHERE nick='Eruanna'),
43 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
46 (SELECT player FROM players WHERE nick='Eruanna'),
48 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
54 (SELECT player FROM players WHERE nick='Eruanna'),
56 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
62 (SELECT player FROM players WHERE nick='Eruanna'),
64 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
67 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
68 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
69 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
71 (SELECT player FROM players WHERE nick='Andeplane'),
74 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
75 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
77 (SELECT player FROM players WHERE nick='Andeplane'),
79 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
85 (SELECT player FROM players WHERE nick='Andeplane'),
87 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
93 (SELECT player FROM players WHERE nick='Andeplane'),
95 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
99 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
102 (SELECT player FROM players WHERE nick='Zeila'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
108 (SELECT player FROM players WHERE nick='Zeila'),
110 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
116 (SELECT player FROM players WHERE nick='Zeila'),
118 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
124 (SELECT player FROM players WHERE nick='Zeila'),
126 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
133 (SELECT player FROM players WHERE nick='Stream'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
139 (SELECT player FROM players WHERE nick='Stream'),
141 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
147 (SELECT player FROM players WHERE nick='Stream'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
155 (SELECT player FROM players WHERE nick='Stream'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
164 (SELECT player FROM players WHERE nick='Bonzo'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
170 (SELECT player FROM players WHERE nick='Bonzo'),
172 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
178 (SELECT player FROM players WHERE nick='Bonzo'),
180 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
186 (SELECT player FROM players WHERE nick='Bonzo'),
188 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
195 (SELECT player FROM players WHERE nick='Haggar'),
198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
201 (SELECT player FROM players WHERE nick='Haggar'),
203 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
209 (SELECT player FROM players WHERE nick='Haggar'),
211 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
217 (SELECT player FROM players WHERE nick='Haggar'),
219 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
222 INSERT INTO groups (tournament, round, parallel) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
225 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
228 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
233 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
235 UPDATE rounds SET randomsongs=2 WHERE
236 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
238 UPDATE rounds SET chosensongs=1 WHERE
239 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
245 (SELECT player FROM players WHERE nick='Chimera'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
251 (SELECT player FROM players WHERE nick='Chimera'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
259 (SELECT player FROM players WHERE nick='Chimera'),
261 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
267 (SELECT player FROM players WHERE nick='Chimera'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
276 (SELECT player FROM players WHERE nick='Alexxz'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
282 (SELECT player FROM players WHERE nick='Alexxz'),
284 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
290 (SELECT player FROM players WHERE nick='Alexxz'),
292 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
298 (SELECT player FROM players WHERE nick='Alexxz'),
300 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
307 (SELECT player FROM players WHERE nick='Smiph'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
313 (SELECT player FROM players WHERE nick='Smiph'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
321 (SELECT player FROM players WHERE nick='Smiph'),
323 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
329 (SELECT player FROM players WHERE nick='Smiph'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
338 (SELECT player FROM players WHERE nick='Duckling'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
344 (SELECT player FROM players WHERE nick='Duckling'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
352 (SELECT player FROM players WHERE nick='Duckling'),
354 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
360 (SELECT player FROM players WHERE nick='Duckling'),
362 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
365 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
369 (SELECT player FROM players WHERE nick='Pingo'),
372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
375 (SELECT player FROM players WHERE nick='Pingo'),
377 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
383 (SELECT player FROM players WHERE nick='Pingo'),
385 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
391 (SELECT player FROM players WHERE nick='Pingo'),
393 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
396 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
400 (SELECT player FROM players WHERE nick='DufF'),
403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
406 (SELECT player FROM players WHERE nick='DufF'),
408 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
414 (SELECT player FROM players WHERE nick='DufF'),
416 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
422 (SELECT player FROM players WHERE nick='DufF'),
424 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
427 INSERT INTO groups (tournament, round, parallel) VALUES (
428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
430 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
435 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
436 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
438 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
440 UPDATE rounds SET randomsongs=2 WHERE
441 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
443 UPDATE rounds SET chosensongs=1 WHERE
444 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
450 (SELECT player FROM players WHERE nick='Mickva'),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
456 (SELECT player FROM players WHERE nick='Mickva'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
464 (SELECT player FROM players WHERE nick='Mickva'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
472 (SELECT player FROM players WHERE nick='Mickva'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
481 (SELECT player FROM players WHERE nick='Havok'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
487 (SELECT player FROM players WHERE nick='Havok'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
495 (SELECT player FROM players WHERE nick='Havok'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
503 (SELECT player FROM players WHERE nick='Havok'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
509 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
512 (SELECT player FROM players WHERE nick='Felz'),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
518 (SELECT player FROM players WHERE nick='Felz'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
526 (SELECT player FROM players WHERE nick='Felz'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
534 (SELECT player FROM players WHERE nick='Felz'),
536 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
539 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
540 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
543 (SELECT player FROM players WHERE nick='Mync'),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
549 (SELECT player FROM players WHERE nick='Mync'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
557 (SELECT player FROM players WHERE nick='Mync'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
565 (SELECT player FROM players WHERE nick='Mync'),
567 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
570 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
571 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
574 (SELECT player FROM players WHERE nick='Gogo'),
577 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
578 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
580 (SELECT player FROM players WHERE nick='Gogo'),
582 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
585 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
586 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
588 (SELECT player FROM players WHERE nick='Gogo'),
590 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
594 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
596 (SELECT player FROM players WHERE nick='Gogo'),
598 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
601 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
605 (SELECT player FROM players WHERE nick='Snute'),
608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
611 (SELECT player FROM players WHERE nick='Snute'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
619 (SELECT player FROM players WHERE nick='Snute'),
621 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
627 (SELECT player FROM players WHERE nick='Snute'),
629 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
632 INSERT INTO groups (tournament, round, parallel) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
635 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
638 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
640 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
645 UPDATE rounds SET randomsongs=2 WHERE
646 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
648 UPDATE rounds SET chosensongs=1 WHERE
649 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
651 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
652 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
655 (SELECT player FROM players WHERE nick='Ingviild'),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
661 (SELECT player FROM players WHERE nick='Ingviild'),
663 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
669 (SELECT player FROM players WHERE nick='Ingviild'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
677 (SELECT player FROM players WHERE nick='Ingviild'),
679 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
682 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
683 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
684 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
686 (SELECT player FROM players WHERE nick='Ngan'),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
692 (SELECT player FROM players WHERE nick='Ngan'),
694 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
700 (SELECT player FROM players WHERE nick='Ngan'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
705 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
708 (SELECT player FROM players WHERE nick='Ngan'),
710 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
713 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
717 (SELECT player FROM players WHERE nick='Cuivien'),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
723 (SELECT player FROM players WHERE nick='Cuivien'),
725 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
731 (SELECT player FROM players WHERE nick='Cuivien'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
739 (SELECT player FROM players WHERE nick='Cuivien'),
741 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
744 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
745 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
748 (SELECT player FROM players WHERE nick='Daniil'),
751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
754 (SELECT player FROM players WHERE nick='Daniil'),
756 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
762 (SELECT player FROM players WHERE nick='Daniil'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
770 (SELECT player FROM players WHERE nick='Daniil'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
775 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
776 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
779 (SELECT player FROM players WHERE nick='Olemann'),
782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
785 (SELECT player FROM players WHERE nick='Olemann'),
787 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
793 (SELECT player FROM players WHERE nick='Olemann'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
801 (SELECT player FROM players WHERE nick='Olemann'),
803 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
806 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
807 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
810 (SELECT player FROM players WHERE nick='RiChY'),
813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
816 (SELECT player FROM players WHERE nick='RiChY'),
818 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
824 (SELECT player FROM players WHERE nick='RiChY'),
826 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
829 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
832 (SELECT player FROM players WHERE nick='RiChY'),
834 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
837 INSERT INTO groups (tournament, round, parallel) VALUES (
838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
840 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
843 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
845 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
848 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
850 UPDATE rounds SET randomsongs=2 WHERE
851 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
853 UPDATE rounds SET chosensongs=1 WHERE
854 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
856 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
857 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
858 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
860 (SELECT player FROM players WHERE nick='Maxion'),
863 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
866 (SELECT player FROM players WHERE nick='Maxion'),
868 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
874 (SELECT player FROM players WHERE nick='Maxion'),
876 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
880 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
882 (SELECT player FROM players WHERE nick='Maxion'),
884 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
889 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
891 (SELECT player FROM players WHERE nick='Lindaninja'),
894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
897 (SELECT player FROM players WHERE nick='Lindaninja'),
899 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
905 (SELECT player FROM players WHERE nick='Lindaninja'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
913 (SELECT player FROM players WHERE nick='Lindaninja'),
915 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
918 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
919 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
922 (SELECT player FROM players WHERE nick='Asphodel'),
925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
928 (SELECT player FROM players WHERE nick='Asphodel'),
930 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
936 (SELECT player FROM players WHERE nick='Asphodel'),
938 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
944 (SELECT player FROM players WHERE nick='Asphodel'),
946 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
949 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
953 (SELECT player FROM players WHERE nick='Cehtna'),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
959 (SELECT player FROM players WHERE nick='Cehtna'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
967 (SELECT player FROM players WHERE nick='Cehtna'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
975 (SELECT player FROM players WHERE nick='Cehtna'),
977 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
980 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
984 (SELECT player FROM players WHERE nick='T|na'),
987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
990 (SELECT player FROM players WHERE nick='T|na'),
992 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
998 (SELECT player FROM players WHERE nick='T|na'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1006 (SELECT player FROM players WHERE nick='T|na'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1011 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1015 (SELECT player FROM players WHERE nick='Ylini'),
1018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1021 (SELECT player FROM players WHERE nick='Ylini'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1027 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1029 (SELECT player FROM players WHERE nick='Ylini'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1037 (SELECT player FROM players WHERE nick='Ylini'),
1039 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1042 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1043 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1044 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1046 (SELECT player FROM players WHERE nick='OJK'),
1049 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1052 (SELECT player FROM players WHERE nick='OJK'),
1054 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1057 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1058 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1060 (SELECT player FROM players WHERE nick='OJK'),
1062 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1065 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1068 (SELECT player FROM players WHERE nick='OJK'),
1070 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1073 INSERT INTO groups (tournament, round, parallel) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1076 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1081 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1082 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1084 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1086 UPDATE rounds SET randomsongs=2 WHERE
1087 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1089 UPDATE rounds SET chosensongs=1 WHERE
1090 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1092 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
1093 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1096 (SELECT player FROM players WHERE nick='Athena'),
1099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1102 (SELECT player FROM players WHERE nick='Athena'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1110 (SELECT player FROM players WHERE nick='Athena'),
1112 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1115 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1118 (SELECT player FROM players WHERE nick='Athena'),
1120 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1123 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
1124 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1125 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1127 (SELECT player FROM players WHERE nick='Andre'),
1130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1133 (SELECT player FROM players WHERE nick='Andre'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1141 (SELECT player FROM players WHERE nick='Andre'),
1143 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1149 (SELECT player FROM players WHERE nick='Andre'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1154 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
1155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1158 (SELECT player FROM players WHERE nick='Marilla'),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1164 (SELECT player FROM players WHERE nick='Marilla'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1172 (SELECT player FROM players WHERE nick='Marilla'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1180 (SELECT player FROM players WHERE nick='Marilla'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1185 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1189 (SELECT player FROM players WHERE nick='Ozon'),
1192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1195 (SELECT player FROM players WHERE nick='Ozon'),
1197 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1203 (SELECT player FROM players WHERE nick='Ozon'),
1205 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1211 (SELECT player FROM players WHERE nick='Ozon'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1216 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
1217 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1220 (SELECT player FROM players WHERE nick='Haanz'),
1223 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1226 (SELECT player FROM players WHERE nick='Haanz'),
1228 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1231 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1234 (SELECT player FROM players WHERE nick='Haanz'),
1236 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1239 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1242 (SELECT player FROM players WHERE nick='Haanz'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1247 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1248 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1251 (SELECT player FROM players WHERE nick='Nameless'),
1254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1257 (SELECT player FROM players WHERE nick='Nameless'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1265 (SELECT player FROM players WHERE nick='Nameless'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1273 (SELECT player FROM players WHERE nick='Nameless'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1278 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1279 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1282 (SELECT player FROM players WHERE nick='Oliyzia'),
1285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1286 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1288 (SELECT player FROM players WHERE nick='Oliyzia'),
1290 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1294 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1296 (SELECT player FROM players WHERE nick='Oliyzia'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1304 (SELECT player FROM players WHERE nick='Oliyzia'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1309 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1314 INSERT INTO groups (tournament, round, parallel) VALUES (
1315 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1317 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1320 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1322 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1323 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1325 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
1327 UPDATE rounds SET randomsongs=2 WHERE
1328 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1330 UPDATE rounds SET chosensongs=1 WHERE
1331 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1333 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1334 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1337 (SELECT player FROM players WHERE nick='Bonzo'),
1340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1343 (SELECT player FROM players WHERE nick='Bonzo'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1351 (SELECT player FROM players WHERE nick='Bonzo'),
1353 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1359 (SELECT player FROM players WHERE nick='Bonzo'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1364 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1365 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1368 (SELECT player FROM players WHERE nick='Mync'),
1371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1374 (SELECT player FROM players WHERE nick='Mync'),
1376 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1382 (SELECT player FROM players WHERE nick='Mync'),
1384 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1390 (SELECT player FROM players WHERE nick='Mync'),
1392 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1395 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1399 (SELECT player FROM players WHERE nick='Haggar'),
1402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1405 (SELECT player FROM players WHERE nick='Haggar'),
1407 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1413 (SELECT player FROM players WHERE nick='Haggar'),
1415 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1421 (SELECT player FROM players WHERE nick='Haggar'),
1423 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1426 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1430 (SELECT player FROM players WHERE nick='Daniil'),
1433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1436 (SELECT player FROM players WHERE nick='Daniil'),
1438 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1444 (SELECT player FROM players WHERE nick='Daniil'),
1446 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1449 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1452 (SELECT player FROM players WHERE nick='Daniil'),
1454 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1457 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1458 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1459 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1461 (SELECT player FROM players WHERE nick='Snute'),
1464 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1467 (SELECT player FROM players WHERE nick='Snute'),
1469 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1472 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1473 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1475 (SELECT player FROM players WHERE nick='Snute'),
1477 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1480 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1481 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1483 (SELECT player FROM players WHERE nick='Snute'),
1485 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1488 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1489 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1492 (SELECT player FROM players WHERE nick='OJK'),
1495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1498 (SELECT player FROM players WHERE nick='OJK'),
1500 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1506 (SELECT player FROM players WHERE nick='OJK'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1512 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1514 (SELECT player FROM players WHERE nick='OJK'),
1516 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1519 INSERT INTO groups (tournament, round, parallel) VALUES (
1520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1522 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1523 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
1527 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1528 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1530 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1532 UPDATE rounds SET randomsongs=2 WHERE
1533 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1535 UPDATE rounds SET chosensongs=1 WHERE
1536 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1538 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1539 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1542 (SELECT player FROM players WHERE nick='Ozon'),
1545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1548 (SELECT player FROM players WHERE nick='Ozon'),
1550 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1556 (SELECT player FROM players WHERE nick='Ozon'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1564 (SELECT player FROM players WHERE nick='Ozon'),
1566 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1569 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1570 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1573 (SELECT player FROM players WHERE nick='RiChY'),
1576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1579 (SELECT player FROM players WHERE nick='RiChY'),
1581 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1587 (SELECT player FROM players WHERE nick='RiChY'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1595 (SELECT player FROM players WHERE nick='RiChY'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1600 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1601 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1604 (SELECT player FROM players WHERE nick='Oliyzia'),
1607 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1608 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1610 (SELECT player FROM players WHERE nick='Oliyzia'),
1612 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1615 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1618 (SELECT player FROM players WHERE nick='Oliyzia'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1623 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1626 (SELECT player FROM players WHERE nick='Oliyzia'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1631 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1635 (SELECT player FROM players WHERE nick='T|na'),
1638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1641 (SELECT player FROM players WHERE nick='T|na'),
1643 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1649 (SELECT player FROM players WHERE nick='T|na'),
1651 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1654 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1657 (SELECT player FROM players WHERE nick='T|na'),
1659 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1662 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1663 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1666 (SELECT player FROM players WHERE nick='Nameless'),
1669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1672 (SELECT player FROM players WHERE nick='Nameless'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1680 (SELECT player FROM players WHERE nick='Nameless'),
1682 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1688 (SELECT player FROM players WHERE nick='Nameless'),
1690 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1693 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1694 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1697 (SELECT player FROM players WHERE nick='Olemann'),
1700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1701 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1703 (SELECT player FROM players WHERE nick='Olemann'),
1705 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1711 (SELECT player FROM players WHERE nick='Olemann'),
1713 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1716 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1717 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1719 (SELECT player FROM players WHERE nick='Olemann'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1724 INSERT INTO groups (tournament, round, parallel) VALUES (
1725 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1727 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1730 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1732 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1733 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1735 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1737 UPDATE rounds SET randomsongs=2 WHERE
1738 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1740 UPDATE rounds SET chosensongs=1 WHERE
1741 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1743 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1744 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1747 (SELECT player FROM players WHERE nick='Ylini'),
1750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1751 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1753 (SELECT player FROM players WHERE nick='Ylini'),
1755 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1761 (SELECT player FROM players WHERE nick='Ylini'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1769 (SELECT player FROM players WHERE nick='Ylini'),
1771 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1774 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1775 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1778 (SELECT player FROM players WHERE nick='Pingo'),
1781 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1782 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1784 (SELECT player FROM players WHERE nick='Pingo'),
1786 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1792 (SELECT player FROM players WHERE nick='Pingo'),
1794 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1800 (SELECT player FROM players WHERE nick='Pingo'),
1802 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1805 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1806 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1807 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1809 (SELECT player FROM players WHERE nick='Gogo'),
1812 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1813 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1815 (SELECT player FROM players WHERE nick='Gogo'),
1817 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1820 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1821 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1823 (SELECT player FROM players WHERE nick='Gogo'),
1825 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1828 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1829 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1831 (SELECT player FROM players WHERE nick='Gogo'),
1833 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1836 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1840 (SELECT player FROM players WHERE nick='Duckling'),
1843 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1846 (SELECT player FROM players WHERE nick='Duckling'),
1848 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1851 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1854 (SELECT player FROM players WHERE nick='Duckling'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1862 (SELECT player FROM players WHERE nick='Duckling'),
1864 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1867 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1868 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1871 (SELECT player FROM players WHERE nick='Stream'),
1874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1875 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1877 (SELECT player FROM players WHERE nick='Stream'),
1879 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1885 (SELECT player FROM players WHERE nick='Stream'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1893 (SELECT player FROM players WHERE nick='Stream'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1898 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1899 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1902 (SELECT player FROM players WHERE nick='DufF'),
1905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1908 (SELECT player FROM players WHERE nick='DufF'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1916 (SELECT player FROM players WHERE nick='DufF'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1921 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1924 (SELECT player FROM players WHERE nick='DufF'),
1926 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1929 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1934 INSERT INTO groups (tournament, round, parallel) VALUES (
1935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1937 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1938 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1940 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1942 UPDATE rounds SET randomsongs=1 WHERE
1943 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1945 UPDATE rounds SET chosensongs=1 WHERE
1946 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1948 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1949 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1950 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1952 (SELECT player FROM players WHERE nick='RiChY'),
1955 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1956 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1958 (SELECT player FROM players WHERE nick='RiChY'),
1960 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1963 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1964 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1966 (SELECT player FROM players WHERE nick='RiChY'),
1968 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1971 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1972 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1975 (SELECT player FROM players WHERE nick='Pingo'),
1978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1981 (SELECT player FROM players WHERE nick='Pingo'),
1983 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1989 (SELECT player FROM players WHERE nick='Pingo'),
1991 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1994 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1995 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1998 (SELECT player FROM players WHERE nick='OJK'),
2001 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2002 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2004 (SELECT player FROM players WHERE nick='OJK'),
2006 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2009 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2010 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2012 (SELECT player FROM players WHERE nick='OJK'),
2014 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2017 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2018 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2021 (SELECT player FROM players WHERE nick='T|na'),
2024 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2027 (SELECT player FROM players WHERE nick='T|na'),
2029 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2032 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2033 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2035 (SELECT player FROM players WHERE nick='T|na'),
2037 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2040 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2041 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2044 (SELECT player FROM players WHERE nick='Haggar'),
2047 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2048 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2050 (SELECT player FROM players WHERE nick='Haggar'),
2052 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2055 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2056 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2058 (SELECT player FROM players WHERE nick='Haggar'),
2060 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2063 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
2064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2067 (SELECT player FROM players WHERE nick='Gogo'),
2070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2071 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2073 (SELECT player FROM players WHERE nick='Gogo'),
2075 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2079 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2081 (SELECT player FROM players WHERE nick='Gogo'),
2083 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2086 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2087 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2090 (SELECT player FROM players WHERE nick='Nameless'),
2093 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2096 (SELECT player FROM players WHERE nick='Nameless'),
2098 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2101 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2102 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2104 (SELECT player FROM players WHERE nick='Nameless'),
2106 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2109 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2110 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2113 (SELECT player FROM players WHERE nick='DufF'),
2116 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2119 (SELECT player FROM players WHERE nick='DufF'),
2121 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2124 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2125 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2127 (SELECT player FROM players WHERE nick='DufF'),
2129 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2133 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2136 (SELECT player FROM players WHERE nick='Snute'),
2139 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2142 (SELECT player FROM players WHERE nick='Snute'),
2144 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2147 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2150 (SELECT player FROM players WHERE nick='Snute'),
2152 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2155 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2160 INSERT INTO groups (tournament, round, parallel) VALUES (
2161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2163 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2166 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
2168 UPDATE rounds SET randomsongs=1 WHERE
2169 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2171 UPDATE rounds SET chosensongs=1 WHERE
2172 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
2175 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2178 (SELECT player FROM players WHERE nick='Gogo'),
2181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2184 (SELECT player FROM players WHERE nick='Gogo'),
2186 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2190 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2192 (SELECT player FROM players WHERE nick='Gogo'),
2194 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2197 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2201 (SELECT player FROM players WHERE nick='Haggar'),
2204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2207 (SELECT player FROM players WHERE nick='Haggar'),
2209 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2215 (SELECT player FROM players WHERE nick='Haggar'),
2217 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2220 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2221 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2224 (SELECT player FROM players WHERE nick='Nameless'),
2227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2230 (SELECT player FROM players WHERE nick='Nameless'),
2232 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2235 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2238 (SELECT player FROM players WHERE nick='Nameless'),
2240 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2243 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2247 (SELECT player FROM players WHERE nick='RiChY'),
2250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2253 (SELECT player FROM players WHERE nick='RiChY'),
2255 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2261 (SELECT player FROM players WHERE nick='RiChY'),
2263 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2266 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2267 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2268 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2270 (SELECT player FROM players WHERE nick='DufF'),
2273 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2276 (SELECT player FROM players WHERE nick='DufF'),
2278 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2284 (SELECT player FROM players WHERE nick='DufF'),
2286 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2289 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2290 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2293 (SELECT player FROM players WHERE nick='OJK'),
2296 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2299 (SELECT player FROM players WHERE nick='OJK'),
2301 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2307 (SELECT player FROM players WHERE nick='OJK'),
2309 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2312 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2313 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2316 (SELECT player FROM players WHERE nick='Snute'),
2319 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2322 (SELECT player FROM players WHERE nick='Snute'),
2324 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2327 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2330 (SELECT player FROM players WHERE nick='Snute'),
2332 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2335 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2340 INSERT INTO groups (tournament, round, parallel) VALUES (
2341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2343 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2346 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
2348 UPDATE rounds SET randomsongs=1 WHERE
2349 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2351 UPDATE rounds SET chosensongs=1 WHERE
2352 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2354 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2358 (SELECT player FROM players WHERE nick='RiChY'),
2361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2364 (SELECT player FROM players WHERE nick='RiChY'),
2366 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2369 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2372 (SELECT player FROM players WHERE nick='RiChY'),
2374 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2377 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2378 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2381 (SELECT player FROM players WHERE nick='DufF'),
2384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2385 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2387 (SELECT player FROM players WHERE nick='DufF'),
2389 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2392 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2393 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2395 (SELECT player FROM players WHERE nick='DufF'),
2397 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2400 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2401 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2404 (SELECT player FROM players WHERE nick='OJK'),
2407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2410 (SELECT player FROM players WHERE nick='OJK'),
2412 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2418 (SELECT player FROM players WHERE nick='OJK'),
2420 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2423 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2424 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2427 (SELECT player FROM players WHERE nick='Snute'),
2430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2433 (SELECT player FROM players WHERE nick='Snute'),
2435 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2441 (SELECT player FROM players WHERE nick='Snute'),
2443 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2450 (SELECT player FROM players WHERE nick='Haggar'),
2453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2456 (SELECT player FROM players WHERE nick='Haggar'),
2458 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2464 (SELECT player FROM players WHERE nick='Haggar'),
2466 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2469 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2474 INSERT INTO groups (tournament, round, parallel) VALUES (
2475 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2477 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2480 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
2482 UPDATE rounds SET randomsongs=1 WHERE
2483 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2485 UPDATE rounds SET chosensongs=1 WHERE
2486 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2488 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2489 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2492 (SELECT player FROM players WHERE nick='Haggar'),
2495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2498 (SELECT player FROM players WHERE nick='Haggar'),
2500 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2506 (SELECT player FROM players WHERE nick='Haggar'),
2508 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2511 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2512 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2515 (SELECT player FROM players WHERE nick='OJK'),
2518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2521 (SELECT player FROM players WHERE nick='OJK'),
2523 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2527 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2529 (SELECT player FROM players WHERE nick='OJK'),
2531 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2538 (SELECT player FROM players WHERE nick='DufF'),
2541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2544 (SELECT player FROM players WHERE nick='DufF'),
2546 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2552 (SELECT player FROM players WHERE nick='DufF'),
2554 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2557 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2558 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2561 (SELECT player FROM players WHERE nick='Snute'),
2564 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2565 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2567 (SELECT player FROM players WHERE nick='Snute'),
2569 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2575 (SELECT player FROM players WHERE nick='Snute'),
2577 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2580 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2582 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2585 INSERT INTO groups (tournament, round, parallel) VALUES (
2586 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2588 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2591 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
2593 UPDATE rounds SET randomsongs=1 WHERE
2594 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2596 UPDATE rounds SET chosensongs=1 WHERE
2597 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2599 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2600 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2603 (SELECT player FROM players WHERE nick='DufF'),
2606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2609 (SELECT player FROM players WHERE nick='DufF'),
2611 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2617 (SELECT player FROM players WHERE nick='DufF'),
2619 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2622 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2623 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2626 (SELECT player FROM players WHERE nick='Snute'),
2629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2632 (SELECT player FROM players WHERE nick='Snute'),
2634 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2637 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2640 (SELECT player FROM players WHERE nick='Snute'),
2642 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2645 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2649 (SELECT player FROM players WHERE nick='Haggar'),
2652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2655 (SELECT player FROM players WHERE nick='Haggar'),
2657 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2663 (SELECT player FROM players WHERE nick='Haggar'),
2665 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2668 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2673 INSERT INTO groups (tournament, round, parallel) VALUES (
2674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2676 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2679 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
2681 UPDATE rounds SET randomsongs=1 WHERE
2682 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2684 UPDATE rounds SET chosensongs=1 WHERE
2685 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2687 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2688 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2691 (SELECT player FROM players WHERE nick='DufF'),
2694 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2697 (SELECT player FROM players WHERE nick='DufF'),
2699 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2702 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2703 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2705 (SELECT player FROM players WHERE nick='DufF'),
2707 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2710 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2711 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2714 (SELECT player FROM players WHERE nick='Snute'),
2717 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2718 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2720 (SELECT player FROM players WHERE nick='Snute'),
2722 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2725 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2728 (SELECT player FROM players WHERE nick='Snute'),
2730 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2733 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2735 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2738 INSERT INTO groups (tournament, round, parallel) VALUES (
2739 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2741 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2744 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
2746 UPDATE rounds SET randomsongs=1 WHERE
2747 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2749 UPDATE rounds SET chosensongs=1 WHERE
2750 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2752 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
2753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2756 (SELECT player FROM players WHERE nick='Ylini'),
2759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2762 (SELECT player FROM players WHERE nick='Ylini'),
2764 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2770 (SELECT player FROM players WHERE nick='Ylini'),
2772 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2775 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2776 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2777 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2779 (SELECT player FROM players WHERE nick='Oliyzia'),
2782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2785 (SELECT player FROM players WHERE nick='Oliyzia'),
2787 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2793 (SELECT player FROM players WHERE nick='Oliyzia'),
2795 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2798 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2799 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2802 (SELECT player FROM players WHERE nick='T|na'),
2805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2808 (SELECT player FROM players WHERE nick='T|na'),
2810 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2816 (SELECT player FROM players WHERE nick='T|na'),
2818 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2821 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2823 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2826 INSERT INTO groups (tournament, round, parallel) VALUES (
2827 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2829 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2832 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
2834 UPDATE rounds SET randomsongs=1 WHERE
2835 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2837 UPDATE rounds SET chosensongs=1 WHERE
2838 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2840 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2841 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2842 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2844 (SELECT player FROM players WHERE nick='T|na'),
2847 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2850 (SELECT player FROM players WHERE nick='T|na'),
2852 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2855 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2858 (SELECT player FROM players WHERE nick='T|na'),
2860 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2863 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2864 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2865 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2867 (SELECT player FROM players WHERE nick='Oliyzia'),
2870 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2871 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2873 (SELECT player FROM players WHERE nick='Oliyzia'),
2875 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2878 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2879 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2881 (SELECT player FROM players WHERE nick='Oliyzia'),
2883 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),