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 tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
57 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
58 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
60 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
61 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
63 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
66 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
69 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
70 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
72 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
75 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
76 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
78 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
79 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
81 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
82 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
84 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
85 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
87 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
88 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
90 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
93 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
96 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
99 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
102 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
104 31, 'Lindaninja', 50);
105 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
108 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
111 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
114 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
117 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
120 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
123 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
126 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
131 INSERT INTO groups (tournament, round, parallel) VALUES (
132 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
134 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
137 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
139 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
142 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
144 UPDATE rounds SET randomsongs=2 WHERE
145 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
147 UPDATE rounds SET chosensongs=1 WHERE
148 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
151 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
154 (SELECT player FROM players WHERE nick='Eruanna'),
157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
160 (SELECT player FROM players WHERE nick='Eruanna'),
162 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
165 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
168 (SELECT player FROM players WHERE nick='Eruanna'),
170 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
176 (SELECT player FROM players WHERE nick='Eruanna'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
185 (SELECT player FROM players WHERE nick='Andeplane'),
188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
191 (SELECT player FROM players WHERE nick='Andeplane'),
193 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
196 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
197 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
199 (SELECT player FROM players WHERE nick='Andeplane'),
201 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
207 (SELECT player FROM players WHERE nick='Andeplane'),
209 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
212 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
213 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
216 (SELECT player FROM players WHERE nick='Zeila'),
219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
222 (SELECT player FROM players WHERE nick='Zeila'),
224 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
230 (SELECT player FROM players WHERE nick='Zeila'),
232 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
235 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
238 (SELECT player FROM players WHERE nick='Zeila'),
240 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
243 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
247 (SELECT player FROM players WHERE nick='Stream'),
250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
253 (SELECT player FROM players WHERE nick='Stream'),
255 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
261 (SELECT player FROM players WHERE nick='Stream'),
263 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
269 (SELECT player FROM players WHERE nick='Stream'),
271 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
274 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
275 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
276 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
278 (SELECT player FROM players WHERE nick='Bonzo'),
281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
284 (SELECT player FROM players WHERE nick='Bonzo'),
286 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
289 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
292 (SELECT player FROM players WHERE nick='Bonzo'),
294 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
297 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
298 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
300 (SELECT player FROM players WHERE nick='Bonzo'),
302 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
305 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
309 (SELECT player FROM players WHERE nick='Haggar'),
312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
315 (SELECT player FROM players WHERE nick='Haggar'),
317 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
323 (SELECT player FROM players WHERE nick='Haggar'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
331 (SELECT player FROM players WHERE nick='Haggar'),
333 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
336 INSERT INTO groups (tournament, round, parallel) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
339 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
342 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
344 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
347 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
349 UPDATE rounds SET randomsongs=2 WHERE
350 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
352 UPDATE rounds SET chosensongs=1 WHERE
353 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
355 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
356 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
359 (SELECT player FROM players WHERE nick='Chimera'),
362 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
365 (SELECT player FROM players WHERE nick='Chimera'),
367 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
373 (SELECT player FROM players WHERE nick='Chimera'),
375 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
378 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
381 (SELECT player FROM players WHERE nick='Chimera'),
383 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
386 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
387 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
390 (SELECT player FROM players WHERE nick='Alexxz'),
393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
396 (SELECT player FROM players WHERE nick='Alexxz'),
398 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
401 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
404 (SELECT player FROM players WHERE nick='Alexxz'),
406 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
412 (SELECT player FROM players WHERE nick='Alexxz'),
414 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
417 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
418 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
421 (SELECT player FROM players WHERE nick='Smiph'),
424 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
427 (SELECT player FROM players WHERE nick='Smiph'),
429 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
432 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
433 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
435 (SELECT player FROM players WHERE nick='Smiph'),
437 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
443 (SELECT player FROM players WHERE nick='Smiph'),
445 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
448 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
449 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
452 (SELECT player FROM players WHERE nick='Duckling'),
455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
458 (SELECT player FROM players WHERE nick='Duckling'),
460 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
466 (SELECT player FROM players WHERE nick='Duckling'),
468 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
471 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
472 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
474 (SELECT player FROM players WHERE nick='Duckling'),
476 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
479 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
480 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
481 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
483 (SELECT player FROM players WHERE nick='Pingo'),
486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
489 (SELECT player FROM players WHERE nick='Pingo'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
494 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
497 (SELECT player FROM players WHERE nick='Pingo'),
499 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
502 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
503 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
505 (SELECT player FROM players WHERE nick='Pingo'),
507 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
510 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
511 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
512 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
514 (SELECT player FROM players WHERE nick='DufF'),
517 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
520 (SELECT player FROM players WHERE nick='DufF'),
522 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
525 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
528 (SELECT player FROM players WHERE nick='DufF'),
530 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
533 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
534 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
536 (SELECT player FROM players WHERE nick='DufF'),
538 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
541 INSERT INTO groups (tournament, round, parallel) VALUES (
542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
544 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
545 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
547 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
549 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
554 UPDATE rounds SET randomsongs=2 WHERE
555 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
557 UPDATE rounds SET chosensongs=1 WHERE
558 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
560 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
561 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
564 (SELECT player FROM players WHERE nick='Mickva'),
567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
570 (SELECT player FROM players WHERE nick='Mickva'),
572 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
578 (SELECT player FROM players WHERE nick='Mickva'),
580 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
583 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
586 (SELECT player FROM players WHERE nick='Mickva'),
588 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
591 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
592 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
595 (SELECT player FROM players WHERE nick='Havok'),
598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
601 (SELECT player FROM players WHERE nick='Havok'),
603 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
609 (SELECT player FROM players WHERE nick='Havok'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
617 (SELECT player FROM players WHERE nick='Havok'),
619 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
622 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
623 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
626 (SELECT player FROM players WHERE nick='Felz'),
629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
632 (SELECT player FROM players WHERE nick='Felz'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
637 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
640 (SELECT player FROM players WHERE nick='Felz'),
642 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
645 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
646 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
648 (SELECT player FROM players WHERE nick='Felz'),
650 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
653 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
654 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
657 (SELECT player FROM players WHERE nick='Mync'),
660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
663 (SELECT player FROM players WHERE nick='Mync'),
665 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
671 (SELECT player FROM players WHERE nick='Mync'),
673 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
676 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
679 (SELECT player FROM players WHERE nick='Mync'),
681 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
684 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
685 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
688 (SELECT player FROM players WHERE nick='Gogo'),
691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
692 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
694 (SELECT player FROM players WHERE nick='Gogo'),
696 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
702 (SELECT player FROM players WHERE nick='Gogo'),
704 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
707 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
710 (SELECT player FROM players WHERE nick='Gogo'),
712 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
715 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
716 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
717 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
719 (SELECT player FROM players WHERE nick='Snute'),
722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
725 (SELECT player FROM players WHERE nick='Snute'),
727 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
730 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
731 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
733 (SELECT player FROM players WHERE nick='Snute'),
735 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
738 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
739 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
741 (SELECT player FROM players WHERE nick='Snute'),
743 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
746 INSERT INTO groups (tournament, round, parallel) VALUES (
747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
749 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
752 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
754 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
757 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
759 UPDATE rounds SET randomsongs=2 WHERE
760 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
762 UPDATE rounds SET chosensongs=1 WHERE
763 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
765 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
766 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
769 (SELECT player FROM players WHERE nick='Ingviild'),
772 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
773 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
775 (SELECT player FROM players WHERE nick='Ingviild'),
777 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
780 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
781 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
783 (SELECT player FROM players WHERE nick='Ingviild'),
785 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
791 (SELECT player FROM players WHERE nick='Ingviild'),
793 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
796 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
797 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
800 (SELECT player FROM players WHERE nick='Ngan'),
803 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
804 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
806 (SELECT player FROM players WHERE nick='Ngan'),
808 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
811 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
812 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
814 (SELECT player FROM players WHERE nick='Ngan'),
816 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
822 (SELECT player FROM players WHERE nick='Ngan'),
824 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
827 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
828 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
829 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
831 (SELECT player FROM players WHERE nick='Cuivien'),
834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
837 (SELECT player FROM players WHERE nick='Cuivien'),
839 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
842 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
843 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
845 (SELECT player FROM players WHERE nick='Cuivien'),
847 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
850 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
851 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
853 (SELECT player FROM players WHERE nick='Cuivien'),
855 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
858 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
859 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
862 (SELECT player FROM players WHERE nick='Daniil'),
865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
866 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
868 (SELECT player FROM players WHERE nick='Daniil'),
870 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
873 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
874 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
876 (SELECT player FROM players WHERE nick='Daniil'),
878 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
881 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
882 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
884 (SELECT player FROM players WHERE nick='Daniil'),
886 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
889 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
890 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
893 (SELECT player FROM players WHERE nick='Olemann'),
896 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
897 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
899 (SELECT player FROM players WHERE nick='Olemann'),
901 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
907 (SELECT player FROM players WHERE nick='Olemann'),
909 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
913 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
915 (SELECT player FROM players WHERE nick='Olemann'),
917 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
920 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
921 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
924 (SELECT player FROM players WHERE nick='RiChY'),
927 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
930 (SELECT player FROM players WHERE nick='RiChY'),
932 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
935 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
936 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
938 (SELECT player FROM players WHERE nick='RiChY'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
946 (SELECT player FROM players WHERE nick='RiChY'),
948 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
951 INSERT INTO groups (tournament, round, parallel) VALUES (
952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
954 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
955 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
957 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
959 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
962 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
964 UPDATE rounds SET randomsongs=2 WHERE
965 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
967 UPDATE rounds SET chosensongs=1 WHERE
968 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
970 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
971 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
972 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
974 (SELECT player FROM players WHERE nick='Maxion'),
977 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
978 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
980 (SELECT player FROM players WHERE nick='Maxion'),
982 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
986 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
988 (SELECT player FROM players WHERE nick='Maxion'),
990 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
993 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
994 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
996 (SELECT player FROM players WHERE nick='Maxion'),
998 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1001 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
1002 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1005 (SELECT player FROM players WHERE nick='Lindaninja'),
1008 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1011 (SELECT player FROM players WHERE nick='Lindaninja'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1016 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1017 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1019 (SELECT player FROM players WHERE nick='Lindaninja'),
1021 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1024 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1027 (SELECT player FROM players WHERE nick='Lindaninja'),
1029 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1032 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
1033 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1036 (SELECT player FROM players WHERE nick='Asphodel'),
1039 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1040 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1042 (SELECT player FROM players WHERE nick='Asphodel'),
1044 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1047 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1048 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1050 (SELECT player FROM players WHERE nick='Asphodel'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1055 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1056 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1058 (SELECT player FROM players WHERE nick='Asphodel'),
1060 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1063 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
1064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1067 (SELECT player FROM players WHERE nick='Cehtna'),
1070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1071 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1073 (SELECT player FROM players WHERE nick='Cehtna'),
1075 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1079 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1081 (SELECT player FROM players WHERE nick='Cehtna'),
1083 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1086 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1087 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1089 (SELECT player FROM players WHERE nick='Cehtna'),
1091 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1094 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1095 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1096 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1098 (SELECT player FROM players WHERE nick='T|na'),
1101 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1102 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1104 (SELECT player FROM players WHERE nick='T|na'),
1106 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1109 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1112 (SELECT player FROM players WHERE nick='T|na'),
1114 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1120 (SELECT player FROM players WHERE nick='T|na'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1125 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1129 (SELECT player FROM players WHERE nick='Ylini'),
1132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1135 (SELECT player FROM players WHERE nick='Ylini'),
1137 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1143 (SELECT player FROM players WHERE nick='Ylini'),
1145 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1151 (SELECT player FROM players WHERE nick='Ylini'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1157 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1160 (SELECT player FROM players WHERE nick='OJK'),
1163 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1166 (SELECT player FROM players WHERE nick='OJK'),
1168 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1171 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1172 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1174 (SELECT player FROM players WHERE nick='OJK'),
1176 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1179 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1182 (SELECT player FROM players WHERE nick='OJK'),
1184 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1187 INSERT INTO groups (tournament, round, parallel) VALUES (
1188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1190 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1193 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1195 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1200 UPDATE rounds SET randomsongs=2 WHERE
1201 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1203 UPDATE rounds SET chosensongs=1 WHERE
1204 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1206 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
1207 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1210 (SELECT player FROM players WHERE nick='Athena'),
1213 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1216 (SELECT player FROM players WHERE nick='Athena'),
1218 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1221 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1224 (SELECT player FROM players WHERE nick='Athena'),
1226 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1232 (SELECT player FROM players WHERE nick='Athena'),
1234 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1237 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
1238 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1241 (SELECT player FROM players WHERE nick='Andre'),
1244 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1247 (SELECT player FROM players WHERE nick='Andre'),
1249 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1255 (SELECT player FROM players WHERE nick='Andre'),
1257 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1263 (SELECT player FROM players WHERE nick='Andre'),
1265 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1268 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
1269 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1270 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1272 (SELECT player FROM players WHERE nick='Marilla'),
1275 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1276 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1278 (SELECT player FROM players WHERE nick='Marilla'),
1280 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1283 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1286 (SELECT player FROM players WHERE nick='Marilla'),
1288 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1291 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1294 (SELECT player FROM players WHERE nick='Marilla'),
1296 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1299 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1300 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1303 (SELECT player FROM players WHERE nick='Ozon'),
1306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1309 (SELECT player FROM players WHERE nick='Ozon'),
1311 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1314 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1315 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1317 (SELECT player FROM players WHERE nick='Ozon'),
1319 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1322 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1323 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1325 (SELECT player FROM players WHERE nick='Ozon'),
1327 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1330 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
1331 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1334 (SELECT player FROM players WHERE nick='Haanz'),
1337 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1340 (SELECT player FROM players WHERE nick='Haanz'),
1342 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1345 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1346 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1348 (SELECT player FROM players WHERE nick='Haanz'),
1350 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1353 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1354 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1356 (SELECT player FROM players WHERE nick='Haanz'),
1358 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1361 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1362 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1363 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1365 (SELECT player FROM players WHERE nick='Nameless'),
1368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1371 (SELECT player FROM players WHERE nick='Nameless'),
1373 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1379 (SELECT player FROM players WHERE nick='Nameless'),
1381 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1385 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1387 (SELECT player FROM players WHERE nick='Nameless'),
1389 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1392 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1393 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1396 (SELECT player FROM players WHERE nick='Oliyzia'),
1399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1402 (SELECT player FROM players WHERE nick='Oliyzia'),
1404 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1410 (SELECT player FROM players WHERE nick='Oliyzia'),
1412 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1418 (SELECT player FROM players WHERE nick='Oliyzia'),
1420 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1423 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1428 INSERT INTO groups (tournament, round, parallel) VALUES (
1429 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1431 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1434 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1436 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1439 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
1441 UPDATE rounds SET randomsongs=2 WHERE
1442 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1444 UPDATE rounds SET chosensongs=1 WHERE
1445 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1447 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1448 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1451 (SELECT player FROM players WHERE nick='Bonzo'),
1454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1455 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1457 (SELECT player FROM players WHERE nick='Bonzo'),
1459 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1462 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1463 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1465 (SELECT player FROM players WHERE nick='Bonzo'),
1467 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1473 (SELECT player FROM players WHERE nick='Bonzo'),
1475 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1478 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1479 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1480 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1482 (SELECT player FROM players WHERE nick='Mync'),
1485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1488 (SELECT player FROM players WHERE nick='Mync'),
1490 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1496 (SELECT player FROM players WHERE nick='Mync'),
1498 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1504 (SELECT player FROM players WHERE nick='Mync'),
1506 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1509 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1510 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1511 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1513 (SELECT player FROM players WHERE nick='Haggar'),
1516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1519 (SELECT player FROM players WHERE nick='Haggar'),
1521 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1527 (SELECT player FROM players WHERE nick='Haggar'),
1529 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1532 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1535 (SELECT player FROM players WHERE nick='Haggar'),
1537 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1540 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1541 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1544 (SELECT player FROM players WHERE nick='Daniil'),
1547 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1550 (SELECT player FROM players WHERE nick='Daniil'),
1552 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1555 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1558 (SELECT player FROM players WHERE nick='Daniil'),
1560 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1563 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1564 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1566 (SELECT player FROM players WHERE nick='Daniil'),
1568 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1571 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1572 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1575 (SELECT player FROM players WHERE nick='Snute'),
1578 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1581 (SELECT player FROM players WHERE nick='Snute'),
1583 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1587 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1589 (SELECT player FROM players WHERE nick='Snute'),
1591 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1597 (SELECT player FROM players WHERE nick='Snute'),
1599 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1602 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1603 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1604 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1606 (SELECT player FROM players WHERE nick='OJK'),
1609 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1610 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1612 (SELECT player FROM players WHERE nick='OJK'),
1614 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1618 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1620 (SELECT player FROM players WHERE nick='OJK'),
1622 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1625 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1626 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1628 (SELECT player FROM players WHERE nick='OJK'),
1630 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1633 INSERT INTO groups (tournament, round, parallel) VALUES (
1634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1636 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1637 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
1641 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1644 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1646 UPDATE rounds SET randomsongs=2 WHERE
1647 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1649 UPDATE rounds SET chosensongs=1 WHERE
1650 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1652 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1653 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1654 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1656 (SELECT player FROM players WHERE nick='Ozon'),
1659 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1660 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1662 (SELECT player FROM players WHERE nick='Ozon'),
1664 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1667 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1668 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1670 (SELECT player FROM players WHERE nick='Ozon'),
1672 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1675 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1678 (SELECT player FROM players WHERE nick='Ozon'),
1680 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1683 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1684 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1687 (SELECT player FROM players WHERE nick='RiChY'),
1690 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1691 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1693 (SELECT player FROM players WHERE nick='RiChY'),
1695 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1698 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1701 (SELECT player FROM players WHERE nick='RiChY'),
1703 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1709 (SELECT player FROM players WHERE nick='RiChY'),
1711 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1714 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1715 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1716 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1718 (SELECT player FROM players WHERE nick='Oliyzia'),
1721 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1722 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1724 (SELECT player FROM players WHERE nick='Oliyzia'),
1726 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1732 (SELECT player FROM players WHERE nick='Oliyzia'),
1734 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1740 (SELECT player FROM players WHERE nick='Oliyzia'),
1742 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1745 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1746 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1749 (SELECT player FROM players WHERE nick='T|na'),
1752 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1753 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1755 (SELECT player FROM players WHERE nick='T|na'),
1757 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1760 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1761 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1763 (SELECT player FROM players WHERE nick='T|na'),
1765 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1768 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1769 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1771 (SELECT player FROM players WHERE nick='T|na'),
1773 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1776 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1777 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1780 (SELECT player FROM players WHERE nick='Nameless'),
1783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1786 (SELECT player FROM players WHERE nick='Nameless'),
1788 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1794 (SELECT player FROM players WHERE nick='Nameless'),
1796 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1799 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1802 (SELECT player FROM players WHERE nick='Nameless'),
1804 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1807 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1808 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1809 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1811 (SELECT player FROM players WHERE nick='Olemann'),
1814 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1815 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1817 (SELECT player FROM players WHERE nick='Olemann'),
1819 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1822 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1823 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1825 (SELECT player FROM players WHERE nick='Olemann'),
1827 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1830 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1833 (SELECT player FROM players WHERE nick='Olemann'),
1835 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1838 INSERT INTO groups (tournament, round, parallel) VALUES (
1839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1841 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1842 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1844 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1846 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1849 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1851 UPDATE rounds SET randomsongs=2 WHERE
1852 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1854 UPDATE rounds SET chosensongs=1 WHERE
1855 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1857 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1858 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1859 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1861 (SELECT player FROM players WHERE nick='Ylini'),
1864 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1865 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1867 (SELECT player FROM players WHERE nick='Ylini'),
1869 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1872 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1873 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1875 (SELECT player FROM players WHERE nick='Ylini'),
1877 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1880 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1881 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1883 (SELECT player FROM players WHERE nick='Ylini'),
1885 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1888 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1889 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1890 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1892 (SELECT player FROM players WHERE nick='Pingo'),
1895 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1896 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1898 (SELECT player FROM players WHERE nick='Pingo'),
1900 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1903 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1904 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1906 (SELECT player FROM players WHERE nick='Pingo'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1911 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1914 (SELECT player FROM players WHERE nick='Pingo'),
1916 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1919 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1923 (SELECT player FROM players WHERE nick='Gogo'),
1926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1929 (SELECT player FROM players WHERE nick='Gogo'),
1931 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1937 (SELECT player FROM players WHERE nick='Gogo'),
1939 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1942 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1943 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1945 (SELECT player FROM players WHERE nick='Gogo'),
1947 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1950 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1951 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1954 (SELECT player FROM players WHERE nick='Duckling'),
1957 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1958 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1960 (SELECT player FROM players WHERE nick='Duckling'),
1962 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1965 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1968 (SELECT player FROM players WHERE nick='Duckling'),
1970 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1973 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1976 (SELECT player FROM players WHERE nick='Duckling'),
1978 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1981 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1982 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1985 (SELECT player FROM players WHERE nick='Stream'),
1988 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1991 (SELECT player FROM players WHERE nick='Stream'),
1993 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1999 (SELECT player FROM players WHERE nick='Stream'),
2001 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2007 (SELECT player FROM players WHERE nick='Stream'),
2009 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2012 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2013 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2014 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2016 (SELECT player FROM players WHERE nick='DufF'),
2019 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2020 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2022 (SELECT player FROM players WHERE nick='DufF'),
2024 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2027 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2028 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2030 (SELECT player FROM players WHERE nick='DufF'),
2032 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2035 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2036 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2038 (SELECT player FROM players WHERE nick='DufF'),
2040 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2043 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2045 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2048 INSERT INTO groups (tournament, round, parallel) VALUES (
2049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2051 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2052 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2054 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
2056 UPDATE rounds SET randomsongs=1 WHERE
2057 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2059 UPDATE rounds SET chosensongs=1 WHERE
2060 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2062 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2063 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2064 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2066 (SELECT player FROM players WHERE nick='RiChY'),
2069 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2070 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2072 (SELECT player FROM players WHERE nick='RiChY'),
2074 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2077 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2080 (SELECT player FROM players WHERE nick='RiChY'),
2082 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2085 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
2086 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2087 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2089 (SELECT player FROM players WHERE nick='Pingo'),
2092 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2093 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2095 (SELECT player FROM players WHERE nick='Pingo'),
2097 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2100 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2101 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2103 (SELECT player FROM players WHERE nick='Pingo'),
2105 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2109 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2112 (SELECT player FROM players WHERE nick='OJK'),
2115 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2118 (SELECT player FROM players WHERE nick='OJK'),
2120 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2123 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2126 (SELECT player FROM players WHERE nick='OJK'),
2128 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2131 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2132 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2135 (SELECT player FROM players WHERE nick='T|na'),
2138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2141 (SELECT player FROM players WHERE nick='T|na'),
2143 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2149 (SELECT player FROM players WHERE nick='T|na'),
2151 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2154 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2158 (SELECT player FROM players WHERE nick='Haggar'),
2161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2164 (SELECT player FROM players WHERE nick='Haggar'),
2166 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2172 (SELECT player FROM players WHERE nick='Haggar'),
2174 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2177 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
2178 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2181 (SELECT player FROM players WHERE nick='Gogo'),
2184 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2185 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2187 (SELECT player FROM players WHERE nick='Gogo'),
2189 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2195 (SELECT player FROM players WHERE nick='Gogo'),
2197 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2200 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2201 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2202 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2204 (SELECT player FROM players WHERE nick='Nameless'),
2207 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2210 (SELECT player FROM players WHERE nick='Nameless'),
2212 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2215 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2218 (SELECT player FROM players WHERE nick='Nameless'),
2220 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2227 (SELECT player FROM players WHERE nick='DufF'),
2230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2233 (SELECT player FROM players WHERE nick='DufF'),
2235 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2241 (SELECT player FROM players WHERE nick='DufF'),
2243 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2246 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2247 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2250 (SELECT player FROM players WHERE nick='Snute'),
2253 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2256 (SELECT player FROM players WHERE nick='Snute'),
2258 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2261 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2264 (SELECT player FROM players WHERE nick='Snute'),
2266 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2269 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2274 INSERT INTO groups (tournament, round, parallel) VALUES (
2275 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2277 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2280 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
2282 UPDATE rounds SET randomsongs=1 WHERE
2283 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2285 UPDATE rounds SET chosensongs=1 WHERE
2286 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2288 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
2289 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2292 (SELECT player FROM players WHERE nick='Gogo'),
2295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2298 (SELECT player FROM players WHERE nick='Gogo'),
2300 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2306 (SELECT player FROM players WHERE nick='Gogo'),
2308 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2311 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2315 (SELECT player FROM players WHERE nick='Haggar'),
2318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2321 (SELECT player FROM players WHERE nick='Haggar'),
2323 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2329 (SELECT player FROM players WHERE nick='Haggar'),
2331 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2338 (SELECT player FROM players WHERE nick='Nameless'),
2341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2344 (SELECT player FROM players WHERE nick='Nameless'),
2346 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2352 (SELECT player FROM players WHERE nick='Nameless'),
2354 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2357 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2358 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2361 (SELECT player FROM players WHERE nick='RiChY'),
2364 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2367 (SELECT player FROM players WHERE nick='RiChY'),
2369 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2375 (SELECT player FROM players WHERE nick='RiChY'),
2377 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2380 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2381 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2384 (SELECT player FROM players WHERE nick='DufF'),
2387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2390 (SELECT player FROM players WHERE nick='DufF'),
2392 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2395 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2396 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2398 (SELECT player FROM players WHERE nick='DufF'),
2400 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2403 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2404 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2405 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2407 (SELECT player FROM players WHERE nick='OJK'),
2410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2413 (SELECT player FROM players WHERE nick='OJK'),
2415 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2421 (SELECT player FROM players WHERE nick='OJK'),
2423 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2426 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2430 (SELECT player FROM players WHERE nick='Snute'),
2433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2436 (SELECT player FROM players WHERE nick='Snute'),
2438 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2444 (SELECT player FROM players WHERE nick='Snute'),
2446 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2449 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2451 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2454 INSERT INTO groups (tournament, round, parallel) VALUES (
2455 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2457 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2460 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
2462 UPDATE rounds SET randomsongs=1 WHERE
2463 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2465 UPDATE rounds SET chosensongs=1 WHERE
2466 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2468 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2469 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2472 (SELECT player FROM players WHERE nick='RiChY'),
2475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2478 (SELECT player FROM players WHERE nick='RiChY'),
2480 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2486 (SELECT player FROM players WHERE nick='RiChY'),
2488 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2491 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2492 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2495 (SELECT player FROM players WHERE nick='DufF'),
2498 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2501 (SELECT player FROM players WHERE nick='DufF'),
2503 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2506 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2509 (SELECT player FROM players WHERE nick='DufF'),
2511 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2514 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2515 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2518 (SELECT player FROM players WHERE nick='OJK'),
2521 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2524 (SELECT player FROM players WHERE nick='OJK'),
2526 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2532 (SELECT player FROM players WHERE nick='OJK'),
2534 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2537 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2538 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2541 (SELECT player FROM players WHERE nick='Snute'),
2544 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2545 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2547 (SELECT player FROM players WHERE nick='Snute'),
2549 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2552 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2553 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2555 (SELECT player FROM players WHERE nick='Snute'),
2557 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2560 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2561 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2564 (SELECT player FROM players WHERE nick='Haggar'),
2567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2570 (SELECT player FROM players WHERE nick='Haggar'),
2572 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2578 (SELECT player FROM players WHERE nick='Haggar'),
2580 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2583 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2588 INSERT INTO groups (tournament, round, parallel) VALUES (
2589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2591 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2592 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2594 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
2596 UPDATE rounds SET randomsongs=1 WHERE
2597 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2599 UPDATE rounds SET chosensongs=1 WHERE
2600 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2602 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2603 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2604 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2606 (SELECT player FROM players WHERE nick='Haggar'),
2609 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2610 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2612 (SELECT player FROM players WHERE nick='Haggar'),
2614 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2618 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2620 (SELECT player FROM players WHERE nick='Haggar'),
2622 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2625 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2629 (SELECT player FROM players WHERE nick='OJK'),
2632 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2635 (SELECT player FROM players WHERE nick='OJK'),
2637 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2640 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2643 (SELECT player FROM players WHERE nick='OJK'),
2645 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2648 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2649 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2650 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2652 (SELECT player FROM players WHERE nick='DufF'),
2655 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2658 (SELECT player FROM players WHERE nick='DufF'),
2660 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2663 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2666 (SELECT player FROM players WHERE nick='DufF'),
2668 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2671 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2672 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2675 (SELECT player FROM players WHERE nick='Snute'),
2678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2681 (SELECT player FROM players WHERE nick='Snute'),
2683 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2686 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2689 (SELECT player FROM players WHERE nick='Snute'),
2691 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2694 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2699 INSERT INTO groups (tournament, round, parallel) VALUES (
2700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2702 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2703 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2705 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
2707 UPDATE rounds SET randomsongs=1 WHERE
2708 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2710 UPDATE rounds SET chosensongs=1 WHERE
2711 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2713 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2717 (SELECT player FROM players WHERE nick='DufF'),
2720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2723 (SELECT player FROM players WHERE nick='DufF'),
2725 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2731 (SELECT player FROM players WHERE nick='DufF'),
2733 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2736 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2737 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2740 (SELECT player FROM players WHERE nick='Snute'),
2743 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2746 (SELECT player FROM players WHERE nick='Snute'),
2748 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2752 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2754 (SELECT player FROM players WHERE nick='Snute'),
2756 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2759 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2760 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2761 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2763 (SELECT player FROM players WHERE nick='Haggar'),
2766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2769 (SELECT player FROM players WHERE nick='Haggar'),
2771 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2777 (SELECT player FROM players WHERE nick='Haggar'),
2779 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2782 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2787 INSERT INTO groups (tournament, round, parallel) VALUES (
2788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2790 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2793 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
2795 UPDATE rounds SET randomsongs=1 WHERE
2796 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2798 UPDATE rounds SET chosensongs=1 WHERE
2799 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2801 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2802 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2803 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2805 (SELECT player FROM players WHERE nick='DufF'),
2808 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2809 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2811 (SELECT player FROM players WHERE nick='DufF'),
2813 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2816 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2817 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2819 (SELECT player FROM players WHERE nick='DufF'),
2821 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2824 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2828 (SELECT player FROM players WHERE nick='Snute'),
2831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2834 (SELECT player FROM players WHERE nick='Snute'),
2836 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2839 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2842 (SELECT player FROM players WHERE nick='Snute'),
2844 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2847 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2852 INSERT INTO groups (tournament, round, parallel) VALUES (
2853 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2855 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2858 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
2860 UPDATE rounds SET randomsongs=1 WHERE
2861 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2863 UPDATE rounds SET chosensongs=1 WHERE
2864 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2866 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
2867 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2870 (SELECT player FROM players WHERE nick='Ylini'),
2873 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2874 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2876 (SELECT player FROM players WHERE nick='Ylini'),
2878 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2881 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2882 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2884 (SELECT player FROM players WHERE nick='Ylini'),
2886 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2889 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2890 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2893 (SELECT player FROM players WHERE nick='Oliyzia'),
2896 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2897 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2899 (SELECT player FROM players WHERE nick='Oliyzia'),
2901 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2907 (SELECT player FROM players WHERE nick='Oliyzia'),
2909 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2912 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2913 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2916 (SELECT player FROM players WHERE nick='T|na'),
2919 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2922 (SELECT player FROM players WHERE nick='T|na'),
2924 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2927 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2930 (SELECT player FROM players WHERE nick='T|na'),
2932 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2935 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2940 INSERT INTO groups (tournament, round, parallel) VALUES (
2941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2943 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2946 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
2948 UPDATE rounds SET randomsongs=1 WHERE
2949 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2951 UPDATE rounds SET chosensongs=1 WHERE
2952 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2954 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2955 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2956 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2958 (SELECT player FROM players WHERE nick='T|na'),
2961 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2962 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2964 (SELECT player FROM players WHERE nick='T|na'),
2966 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2970 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2972 (SELECT player FROM players WHERE nick='T|na'),
2974 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2977 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2978 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2981 (SELECT player FROM players WHERE nick='Oliyzia'),
2984 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2985 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2987 (SELECT player FROM players WHERE nick='Oliyzia'),
2989 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2992 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2995 (SELECT player FROM players WHERE nick='Oliyzia'),
2997 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),