2 INSERT INTO tournaments
3 (season, name, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
5 'Challenge Cup 5 - NM',
6 (SELECT country FROM countries WHERE name='Norway'),
9 (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
23 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
40 (SELECT player FROM players WHERE nick='Eruanna'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
46 (SELECT player FROM players WHERE nick='Eruanna'),
47 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
53 (SELECT player FROM players WHERE nick='Eruanna'),
54 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
57 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
60 (SELECT player FROM players WHERE nick='Eruanna'),
61 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
64 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
65 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
66 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
68 (SELECT player FROM players WHERE nick='Andeplane'),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
74 (SELECT player FROM players WHERE nick='Andeplane'),
75 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
81 (SELECT player FROM players WHERE nick='Andeplane'),
82 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
88 (SELECT player FROM players WHERE nick='Andeplane'),
89 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
93 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
94 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
96 (SELECT player FROM players WHERE nick='Zeila'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
102 (SELECT player FROM players WHERE nick='Zeila'),
103 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
109 (SELECT player FROM players WHERE nick='Zeila'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
116 (SELECT player FROM players WHERE nick='Zeila'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
124 (SELECT player FROM players WHERE nick='Stream'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
130 (SELECT player FROM players WHERE nick='Stream'),
131 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
137 (SELECT player FROM players WHERE nick='Stream'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
144 (SELECT player FROM players WHERE nick='Stream'),
145 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
152 (SELECT player FROM players WHERE nick='Bonzo'),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
158 (SELECT player FROM players WHERE nick='Bonzo'),
159 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
165 (SELECT player FROM players WHERE nick='Bonzo'),
166 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
172 (SELECT player FROM players WHERE nick='Bonzo'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
176 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
180 (SELECT player FROM players WHERE nick='Haggar'),
183 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
186 (SELECT player FROM players WHERE nick='Haggar'),
187 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
190 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
191 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
193 (SELECT player FROM players WHERE nick='Haggar'),
194 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
197 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
198 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
200 (SELECT player FROM players WHERE nick='Haggar'),
201 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
204 INSERT INTO groups (tournament, round, parallel) VALUES (
205 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
207 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
208 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
210 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
212 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
213 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
215 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
217 UPDATE rounds SET randomsongs=2 WHERE
218 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
220 UPDATE rounds SET chosensongs=1 WHERE
221 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
227 (SELECT player FROM players WHERE nick='Chimera'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
233 (SELECT player FROM players WHERE nick='Chimera'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
240 (SELECT player FROM players WHERE nick='Chimera'),
241 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
247 (SELECT player FROM players WHERE nick='Chimera'),
248 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
255 (SELECT player FROM players WHERE nick='Alexxz'),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
261 (SELECT player FROM players WHERE nick='Alexxz'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
268 (SELECT player FROM players WHERE nick='Alexxz'),
269 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
275 (SELECT player FROM players WHERE nick='Alexxz'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
283 (SELECT player FROM players WHERE nick='Smiph'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
289 (SELECT player FROM players WHERE nick='Smiph'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
296 (SELECT player FROM players WHERE nick='Smiph'),
297 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
303 (SELECT player FROM players WHERE nick='Smiph'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
311 (SELECT player FROM players WHERE nick='Duckling'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
317 (SELECT player FROM players WHERE nick='Duckling'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
324 (SELECT player FROM players WHERE nick='Duckling'),
325 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
331 (SELECT player FROM players WHERE nick='Duckling'),
332 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
335 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
339 (SELECT player FROM players WHERE nick='Pingo'),
342 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
345 (SELECT player FROM players WHERE nick='Pingo'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
349 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
352 (SELECT player FROM players WHERE nick='Pingo'),
353 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
356 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
357 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
359 (SELECT player FROM players WHERE nick='Pingo'),
360 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
363 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
367 (SELECT player FROM players WHERE nick='DufF'),
370 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
373 (SELECT player FROM players WHERE nick='DufF'),
374 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
377 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
378 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
380 (SELECT player FROM players WHERE nick='DufF'),
381 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
384 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
387 (SELECT player FROM players WHERE nick='DufF'),
388 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
391 INSERT INTO groups (tournament, round, parallel) VALUES (
392 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
394 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
395 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
397 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
399 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
402 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
404 UPDATE rounds SET randomsongs=2 WHERE
405 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
407 UPDATE rounds SET chosensongs=1 WHERE
408 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
411 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
414 (SELECT player FROM players WHERE nick='Mickva'),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
420 (SELECT player FROM players WHERE nick='Mickva'),
421 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
427 (SELECT player FROM players WHERE nick='Mickva'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
431 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
434 (SELECT player FROM players WHERE nick='Mickva'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
442 (SELECT player FROM players WHERE nick='Havok'),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
448 (SELECT player FROM players WHERE nick='Havok'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
452 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
455 (SELECT player FROM players WHERE nick='Havok'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
459 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
462 (SELECT player FROM players WHERE nick='Havok'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
470 (SELECT player FROM players WHERE nick='Felz'),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
476 (SELECT player FROM players WHERE nick='Felz'),
477 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
483 (SELECT player FROM players WHERE nick='Felz'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
490 (SELECT player FROM players WHERE nick='Felz'),
491 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
498 (SELECT player FROM players WHERE nick='Mync'),
501 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
504 (SELECT player FROM players WHERE nick='Mync'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
508 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
511 (SELECT player FROM players WHERE nick='Mync'),
512 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
515 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
518 (SELECT player FROM players WHERE nick='Mync'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
522 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
526 (SELECT player FROM players WHERE nick='Gogo'),
529 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
532 (SELECT player FROM players WHERE nick='Gogo'),
533 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
536 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
537 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
539 (SELECT player FROM players WHERE nick='Gogo'),
540 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
543 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
544 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
546 (SELECT player FROM players WHERE nick='Gogo'),
547 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
554 (SELECT player FROM players WHERE nick='Snute'),
557 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
560 (SELECT player FROM players WHERE nick='Snute'),
561 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
564 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
565 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
567 (SELECT player FROM players WHERE nick='Snute'),
568 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
571 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
574 (SELECT player FROM players WHERE nick='Snute'),
575 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
578 INSERT INTO groups (tournament, round, parallel) VALUES (
579 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
581 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
584 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
586 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
587 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
591 UPDATE rounds SET randomsongs=2 WHERE
592 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
594 UPDATE rounds SET chosensongs=1 WHERE
595 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
599 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
601 (SELECT player FROM players WHERE nick='Ingviild'),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
607 (SELECT player FROM players WHERE nick='Ingviild'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
614 (SELECT player FROM players WHERE nick='Ingviild'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
618 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
619 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
621 (SELECT player FROM players WHERE nick='Ingviild'),
622 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
625 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
629 (SELECT player FROM players WHERE nick='Ngan'),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
635 (SELECT player FROM players WHERE nick='Ngan'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
639 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
642 (SELECT player FROM players WHERE nick='Ngan'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
646 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
649 (SELECT player FROM players WHERE nick='Ngan'),
650 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
653 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
654 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
657 (SELECT player FROM players WHERE nick='Cuivien'),
660 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
663 (SELECT player FROM players WHERE nick='Cuivien'),
664 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
667 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
668 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
670 (SELECT player FROM players WHERE nick='Cuivien'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
674 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
677 (SELECT player FROM players WHERE nick='Cuivien'),
678 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
685 (SELECT player FROM players WHERE nick='Daniil'),
688 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
691 (SELECT player FROM players WHERE nick='Daniil'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
695 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
698 (SELECT player FROM players WHERE nick='Daniil'),
699 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
702 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
703 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
705 (SELECT player FROM players WHERE nick='Daniil'),
706 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
709 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
710 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
711 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
713 (SELECT player FROM players WHERE nick='Olemann'),
716 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
719 (SELECT player FROM players WHERE nick='Olemann'),
720 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
723 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
726 (SELECT player FROM players WHERE nick='Olemann'),
727 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
730 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
731 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
733 (SELECT player FROM players WHERE nick='Olemann'),
734 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
737 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
738 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
741 (SELECT player FROM players WHERE nick='RiChY'),
744 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
747 (SELECT player FROM players WHERE nick='RiChY'),
748 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
751 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
754 (SELECT player FROM players WHERE nick='RiChY'),
755 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
758 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
759 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
761 (SELECT player FROM players WHERE nick='RiChY'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
765 INSERT INTO groups (tournament, round, parallel) VALUES (
766 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
768 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
771 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
773 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
774 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
778 UPDATE rounds SET randomsongs=2 WHERE
779 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
781 UPDATE rounds SET chosensongs=1 WHERE
782 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
788 (SELECT player FROM players WHERE nick='Maxion'),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
794 (SELECT player FROM players WHERE nick='Maxion'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
801 (SELECT player FROM players WHERE nick='Maxion'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
805 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
806 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
808 (SELECT player FROM players WHERE nick='Maxion'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
812 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
816 (SELECT player FROM players WHERE nick='Lindaninja'),
819 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
822 (SELECT player FROM players WHERE nick='Lindaninja'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
826 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
829 (SELECT player FROM players WHERE nick='Lindaninja'),
830 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
833 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
834 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
836 (SELECT player FROM players WHERE nick='Lindaninja'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
840 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
841 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
844 (SELECT player FROM players WHERE nick='Asphodel'),
847 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
850 (SELECT player FROM players WHERE nick='Asphodel'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
854 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
855 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
857 (SELECT player FROM players WHERE nick='Asphodel'),
858 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
861 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
864 (SELECT player FROM players WHERE nick='Asphodel'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
868 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
869 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
872 (SELECT player FROM players WHERE nick='Cehtna'),
875 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
878 (SELECT player FROM players WHERE nick='Cehtna'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
882 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
885 (SELECT player FROM players WHERE nick='Cehtna'),
886 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
889 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
890 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
892 (SELECT player FROM players WHERE nick='Cehtna'),
893 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
896 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
900 (SELECT player FROM players WHERE nick='T|na'),
903 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
904 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
906 (SELECT player FROM players WHERE nick='T|na'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
910 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
913 (SELECT player FROM players WHERE nick='T|na'),
914 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
917 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
918 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
920 (SELECT player FROM players WHERE nick='T|na'),
921 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
924 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
925 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
928 (SELECT player FROM players WHERE nick='Ylini'),
931 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
932 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
934 (SELECT player FROM players WHERE nick='Ylini'),
935 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
938 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
939 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
941 (SELECT player FROM players WHERE nick='Ylini'),
942 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
945 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
946 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
948 (SELECT player FROM players WHERE nick='Ylini'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
952 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
953 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
956 (SELECT player FROM players WHERE nick='OJK'),
959 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
960 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
962 (SELECT player FROM players WHERE nick='OJK'),
963 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
966 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
969 (SELECT player FROM players WHERE nick='OJK'),
970 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
973 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
974 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
976 (SELECT player FROM players WHERE nick='OJK'),
977 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
980 INSERT INTO groups (tournament, round, parallel) VALUES (
981 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
983 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
984 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
986 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
988 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
989 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
993 UPDATE rounds SET randomsongs=2 WHERE
994 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
996 UPDATE rounds SET chosensongs=1 WHERE
997 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
999 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
1000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1001 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1003 (SELECT player FROM players WHERE nick='Athena'),
1006 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1009 (SELECT player FROM players WHERE nick='Athena'),
1010 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1013 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1014 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1016 (SELECT player FROM players WHERE nick='Athena'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1020 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1021 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1023 (SELECT player FROM players WHERE nick='Athena'),
1024 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1027 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
1028 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1031 (SELECT player FROM players WHERE nick='Andre'),
1034 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1037 (SELECT player FROM players WHERE nick='Andre'),
1038 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1041 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1042 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1044 (SELECT player FROM players WHERE nick='Andre'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1048 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1051 (SELECT player FROM players WHERE nick='Andre'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1055 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
1056 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1059 (SELECT player FROM players WHERE nick='Marilla'),
1062 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1063 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1065 (SELECT player FROM players WHERE nick='Marilla'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1069 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1070 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1072 (SELECT player FROM players WHERE nick='Marilla'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1076 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1079 (SELECT player FROM players WHERE nick='Marilla'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1083 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1084 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1087 (SELECT player FROM players WHERE nick='Ozon'),
1090 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1091 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1093 (SELECT player FROM players WHERE nick='Ozon'),
1094 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1097 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1098 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1100 (SELECT player FROM players WHERE nick='Ozon'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1104 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1107 (SELECT player FROM players WHERE nick='Ozon'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1111 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
1112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1115 (SELECT player FROM players WHERE nick='Haanz'),
1118 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1121 (SELECT player FROM players WHERE nick='Haanz'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1125 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1128 (SELECT player FROM players WHERE nick='Haanz'),
1129 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1132 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1133 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1135 (SELECT player FROM players WHERE nick='Haanz'),
1136 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1139 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1140 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1143 (SELECT player FROM players WHERE nick='Nameless'),
1146 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1149 (SELECT player FROM players WHERE nick='Nameless'),
1150 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1153 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1156 (SELECT player FROM players WHERE nick='Nameless'),
1157 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1160 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1161 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1163 (SELECT player FROM players WHERE nick='Nameless'),
1164 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1167 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1171 (SELECT player FROM players WHERE nick='Oliyzia'),
1174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1177 (SELECT player FROM players WHERE nick='Oliyzia'),
1178 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1181 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1184 (SELECT player FROM players WHERE nick='Oliyzia'),
1185 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1191 (SELECT player FROM players WHERE nick='Oliyzia'),
1192 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1195 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1200 INSERT INTO groups (tournament, round, parallel) VALUES (
1201 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1203 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1204 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1206 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1208 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1209 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1211 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
1213 UPDATE rounds SET randomsongs=2 WHERE
1214 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1216 UPDATE rounds SET chosensongs=1 WHERE
1217 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1219 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1220 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1221 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1223 (SELECT player FROM players WHERE nick='Bonzo'),
1226 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1227 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1229 (SELECT player FROM players WHERE nick='Bonzo'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1233 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1234 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1236 (SELECT player FROM players WHERE nick='Bonzo'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1240 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1241 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1243 (SELECT player FROM players WHERE nick='Bonzo'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1247 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1248 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1251 (SELECT player FROM players WHERE nick='Mync'),
1254 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1257 (SELECT player FROM players WHERE nick='Mync'),
1258 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1261 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1262 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1264 (SELECT player FROM players WHERE nick='Mync'),
1265 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1268 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1269 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1271 (SELECT player FROM players WHERE nick='Mync'),
1272 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1275 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1277 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1279 (SELECT player FROM players WHERE nick='Haggar'),
1282 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1283 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1285 (SELECT player FROM players WHERE nick='Haggar'),
1286 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1289 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1290 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1292 (SELECT player FROM players WHERE nick='Haggar'),
1293 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1296 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1297 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1299 (SELECT player FROM players WHERE nick='Haggar'),
1300 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1307 (SELECT player FROM players WHERE nick='Daniil'),
1310 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1313 (SELECT player FROM players WHERE nick='Daniil'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1317 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1320 (SELECT player FROM players WHERE nick='Daniil'),
1321 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1324 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1325 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1327 (SELECT player FROM players WHERE nick='Daniil'),
1328 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1331 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1332 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1333 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1335 (SELECT player FROM players WHERE nick='Snute'),
1338 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1339 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1341 (SELECT player FROM players WHERE nick='Snute'),
1342 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1345 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1346 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1348 (SELECT player FROM players WHERE nick='Snute'),
1349 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1352 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1353 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1355 (SELECT player FROM players WHERE nick='Snute'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1359 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1360 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1361 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1363 (SELECT player FROM players WHERE nick='OJK'),
1366 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1367 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1369 (SELECT player FROM players WHERE nick='OJK'),
1370 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1373 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1374 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1376 (SELECT player FROM players WHERE nick='OJK'),
1377 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1380 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1381 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1383 (SELECT player FROM players WHERE nick='OJK'),
1384 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1387 INSERT INTO groups (tournament, round, parallel) VALUES (
1388 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1390 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1393 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
1395 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1396 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1400 UPDATE rounds SET randomsongs=2 WHERE
1401 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1403 UPDATE rounds SET chosensongs=1 WHERE
1404 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1406 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1407 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1408 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1410 (SELECT player FROM players WHERE nick='Ozon'),
1413 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1416 (SELECT player FROM players WHERE nick='Ozon'),
1417 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1420 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1421 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1423 (SELECT player FROM players WHERE nick='Ozon'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1427 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1428 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1430 (SELECT player FROM players WHERE nick='Ozon'),
1431 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1434 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1435 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1438 (SELECT player FROM players WHERE nick='RiChY'),
1441 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1444 (SELECT player FROM players WHERE nick='RiChY'),
1445 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1448 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1449 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1451 (SELECT player FROM players WHERE nick='RiChY'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1455 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1458 (SELECT player FROM players WHERE nick='RiChY'),
1459 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1462 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1464 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1466 (SELECT player FROM players WHERE nick='Oliyzia'),
1469 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1470 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1472 (SELECT player FROM players WHERE nick='Oliyzia'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1476 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1477 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1479 (SELECT player FROM players WHERE nick='Oliyzia'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1483 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1486 (SELECT player FROM players WHERE nick='Oliyzia'),
1487 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1490 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1491 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1494 (SELECT player FROM players WHERE nick='T|na'),
1497 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1498 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1500 (SELECT player FROM players WHERE nick='T|na'),
1501 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1504 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1505 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1507 (SELECT player FROM players WHERE nick='T|na'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1511 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1512 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1514 (SELECT player FROM players WHERE nick='T|na'),
1515 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1518 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1519 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1520 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1522 (SELECT player FROM players WHERE nick='Nameless'),
1525 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1526 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1528 (SELECT player FROM players WHERE nick='Nameless'),
1529 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1532 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1535 (SELECT player FROM players WHERE nick='Nameless'),
1536 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1539 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1542 (SELECT player FROM players WHERE nick='Nameless'),
1543 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1546 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1547 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1548 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1550 (SELECT player FROM players WHERE nick='Olemann'),
1553 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1556 (SELECT player FROM players WHERE nick='Olemann'),
1557 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1560 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1563 (SELECT player FROM players WHERE nick='Olemann'),
1564 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1567 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1570 (SELECT player FROM players WHERE nick='Olemann'),
1571 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1574 INSERT INTO groups (tournament, round, parallel) VALUES (
1575 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1577 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1580 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1582 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1583 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1585 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1587 UPDATE rounds SET randomsongs=2 WHERE
1588 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1590 UPDATE rounds SET chosensongs=1 WHERE
1591 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1593 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1594 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1595 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1597 (SELECT player FROM players WHERE nick='Ylini'),
1600 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1601 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1603 (SELECT player FROM players WHERE nick='Ylini'),
1604 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1607 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1608 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1610 (SELECT player FROM players WHERE nick='Ylini'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1614 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1615 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1617 (SELECT player FROM players WHERE nick='Ylini'),
1618 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1621 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1622 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1623 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1625 (SELECT player FROM players WHERE nick='Pingo'),
1628 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1629 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1631 (SELECT player FROM players WHERE nick='Pingo'),
1632 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1635 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1636 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1638 (SELECT player FROM players WHERE nick='Pingo'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1642 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1643 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1645 (SELECT player FROM players WHERE nick='Pingo'),
1646 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1649 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1650 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1651 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1653 (SELECT player FROM players WHERE nick='Gogo'),
1656 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1657 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1659 (SELECT player FROM players WHERE nick='Gogo'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1663 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1666 (SELECT player FROM players WHERE nick='Gogo'),
1667 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1670 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1671 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1673 (SELECT player FROM players WHERE nick='Gogo'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1677 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1678 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1679 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1681 (SELECT player FROM players WHERE nick='Duckling'),
1684 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1685 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1687 (SELECT player FROM players WHERE nick='Duckling'),
1688 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1691 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1694 (SELECT player FROM players WHERE nick='Duckling'),
1695 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1698 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1699 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1701 (SELECT player FROM players WHERE nick='Duckling'),
1702 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1705 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1706 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1707 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1709 (SELECT player FROM players WHERE nick='Stream'),
1712 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1715 (SELECT player FROM players WHERE nick='Stream'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1719 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1722 (SELECT player FROM players WHERE nick='Stream'),
1723 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1726 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1727 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1729 (SELECT player FROM players WHERE nick='Stream'),
1730 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1733 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1735 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1737 (SELECT player FROM players WHERE nick='DufF'),
1740 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1741 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1743 (SELECT player FROM players WHERE nick='DufF'),
1744 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1747 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1750 (SELECT player FROM players WHERE nick='DufF'),
1751 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1754 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1757 (SELECT player FROM players WHERE nick='DufF'),
1758 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1761 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1763 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1766 INSERT INTO groups (tournament, round, parallel) VALUES (
1767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1769 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1770 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1772 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1774 UPDATE rounds SET randomsongs=1 WHERE
1775 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1777 UPDATE rounds SET chosensongs=1 WHERE
1778 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1780 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1781 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1782 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1784 (SELECT player FROM players WHERE nick='RiChY'),
1787 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1788 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1790 (SELECT player FROM players WHERE nick='RiChY'),
1791 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1794 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1797 (SELECT player FROM players WHERE nick='RiChY'),
1798 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1801 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1802 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1803 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1805 (SELECT player FROM players WHERE nick='Pingo'),
1808 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1811 (SELECT player FROM players WHERE nick='Pingo'),
1812 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1815 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1816 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1818 (SELECT player FROM players WHERE nick='Pingo'),
1819 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1822 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1823 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1824 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1826 (SELECT player FROM players WHERE nick='OJK'),
1829 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1830 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1832 (SELECT player FROM players WHERE nick='OJK'),
1833 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1836 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1837 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1839 (SELECT player FROM players WHERE nick='OJK'),
1840 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1843 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1844 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1845 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1847 (SELECT player FROM players WHERE nick='T|na'),
1850 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1851 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1853 (SELECT player FROM players WHERE nick='T|na'),
1854 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1857 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1858 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1860 (SELECT player FROM players WHERE nick='T|na'),
1861 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1864 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1865 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1866 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1868 (SELECT player FROM players WHERE nick='Haggar'),
1871 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1872 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1874 (SELECT player FROM players WHERE nick='Haggar'),
1875 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1878 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1879 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1881 (SELECT player FROM players WHERE nick='Haggar'),
1882 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1885 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1886 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1887 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1889 (SELECT player FROM players WHERE nick='Gogo'),
1892 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1893 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1895 (SELECT player FROM players WHERE nick='Gogo'),
1896 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1899 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1900 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1902 (SELECT player FROM players WHERE nick='Gogo'),
1903 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1906 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1907 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1908 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1910 (SELECT player FROM players WHERE nick='Nameless'),
1913 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1916 (SELECT player FROM players WHERE nick='Nameless'),
1917 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1920 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1921 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1923 (SELECT player FROM players WHERE nick='Nameless'),
1924 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1927 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1928 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1929 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1931 (SELECT player FROM players WHERE nick='DufF'),
1934 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1937 (SELECT player FROM players WHERE nick='DufF'),
1938 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1941 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1942 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1944 (SELECT player FROM players WHERE nick='DufF'),
1945 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1948 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1949 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1950 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1952 (SELECT player FROM players WHERE nick='Snute'),
1955 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1956 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1958 (SELECT player FROM players WHERE nick='Snute'),
1959 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1962 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1963 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1965 (SELECT player FROM players WHERE nick='Snute'),
1966 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1969 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1971 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1974 INSERT INTO groups (tournament, round, parallel) VALUES (
1975 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1977 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1978 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1980 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1982 UPDATE rounds SET randomsongs=1 WHERE
1983 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1985 UPDATE rounds SET chosensongs=1 WHERE
1986 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1988 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1989 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1990 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1992 (SELECT player FROM players WHERE nick='Gogo'),
1995 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1996 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1998 (SELECT player FROM players WHERE nick='Gogo'),
1999 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2002 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2003 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2005 (SELECT player FROM players WHERE nick='Gogo'),
2006 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2009 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2010 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2011 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2013 (SELECT player FROM players WHERE nick='Haggar'),
2016 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2017 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2019 (SELECT player FROM players WHERE nick='Haggar'),
2020 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2023 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2024 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2026 (SELECT player FROM players WHERE nick='Haggar'),
2027 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2030 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2031 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2032 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2034 (SELECT player FROM players WHERE nick='Nameless'),
2037 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2038 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2040 (SELECT player FROM players WHERE nick='Nameless'),
2041 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2044 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2045 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2047 (SELECT player FROM players WHERE nick='Nameless'),
2048 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2051 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2052 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2053 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2055 (SELECT player FROM players WHERE nick='RiChY'),
2058 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2059 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2061 (SELECT player FROM players WHERE nick='RiChY'),
2062 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2065 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2066 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2068 (SELECT player FROM players WHERE nick='RiChY'),
2069 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2072 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2073 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2074 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2076 (SELECT player FROM players WHERE nick='DufF'),
2079 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2080 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2082 (SELECT player FROM players WHERE nick='DufF'),
2083 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2086 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2089 (SELECT player FROM players WHERE nick='DufF'),
2090 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2093 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2094 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2095 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2097 (SELECT player FROM players WHERE nick='OJK'),
2100 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2103 (SELECT player FROM players WHERE nick='OJK'),
2104 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2107 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2108 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2110 (SELECT player FROM players WHERE nick='OJK'),
2111 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2115 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2116 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2118 (SELECT player FROM players WHERE nick='Snute'),
2121 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2124 (SELECT player FROM players WHERE nick='Snute'),
2125 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2128 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2129 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2131 (SELECT player FROM players WHERE nick='Snute'),
2132 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2135 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2137 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2140 INSERT INTO groups (tournament, round, parallel) VALUES (
2141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2143 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2144 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2146 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
2148 UPDATE rounds SET randomsongs=1 WHERE
2149 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2151 UPDATE rounds SET chosensongs=1 WHERE
2152 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2154 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2158 (SELECT player FROM players WHERE nick='RiChY'),
2161 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2162 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2164 (SELECT player FROM players WHERE nick='RiChY'),
2165 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2168 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2171 (SELECT player FROM players WHERE nick='RiChY'),
2172 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2175 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2176 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2177 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2179 (SELECT player FROM players WHERE nick='DufF'),
2182 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2183 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2185 (SELECT player FROM players WHERE nick='DufF'),
2186 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2189 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2190 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2192 (SELECT player FROM players WHERE nick='DufF'),
2193 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2196 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2198 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2200 (SELECT player FROM players WHERE nick='OJK'),
2203 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2204 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2206 (SELECT player FROM players WHERE nick='OJK'),
2207 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2210 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2211 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2213 (SELECT player FROM players WHERE nick='OJK'),
2214 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2217 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2218 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2219 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2221 (SELECT player FROM players WHERE nick='Snute'),
2224 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2227 (SELECT player FROM players WHERE nick='Snute'),
2228 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2231 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2232 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2234 (SELECT player FROM players WHERE nick='Snute'),
2235 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2238 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2239 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2240 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2242 (SELECT player FROM players WHERE nick='Haggar'),
2245 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2246 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2248 (SELECT player FROM players WHERE nick='Haggar'),
2249 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2252 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2255 (SELECT player FROM players WHERE nick='Haggar'),
2256 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2259 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2261 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2264 INSERT INTO groups (tournament, round, parallel) VALUES (
2265 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2267 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2268 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2270 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
2272 UPDATE rounds SET randomsongs=1 WHERE
2273 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2275 UPDATE rounds SET chosensongs=1 WHERE
2276 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2278 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2279 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2282 (SELECT player FROM players WHERE nick='Haggar'),
2285 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2286 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2288 (SELECT player FROM players WHERE nick='Haggar'),
2289 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2292 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2293 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2295 (SELECT player FROM players WHERE nick='Haggar'),
2296 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2299 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2300 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2303 (SELECT player FROM players WHERE nick='OJK'),
2306 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2307 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2309 (SELECT player FROM players WHERE nick='OJK'),
2310 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2313 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2314 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2316 (SELECT player FROM players WHERE nick='OJK'),
2317 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2320 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2321 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2324 (SELECT player FROM players WHERE nick='DufF'),
2327 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2328 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2330 (SELECT player FROM players WHERE nick='DufF'),
2331 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2334 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2335 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2337 (SELECT player FROM players WHERE nick='DufF'),
2338 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2341 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2342 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2343 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2345 (SELECT player FROM players WHERE nick='Snute'),
2348 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2351 (SELECT player FROM players WHERE nick='Snute'),
2352 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2355 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2358 (SELECT player FROM players WHERE nick='Snute'),
2359 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2362 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2364 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2367 INSERT INTO groups (tournament, round, parallel) VALUES (
2368 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2370 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2373 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
2375 UPDATE rounds SET randomsongs=1 WHERE
2376 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2378 UPDATE rounds SET chosensongs=1 WHERE
2379 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2381 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2382 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2385 (SELECT player FROM players WHERE nick='DufF'),
2388 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2389 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2391 (SELECT player FROM players WHERE nick='DufF'),
2392 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2395 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2396 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2398 (SELECT player FROM players WHERE nick='DufF'),
2399 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2402 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2406 (SELECT player FROM players WHERE nick='Snute'),
2409 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2410 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2412 (SELECT player FROM players WHERE nick='Snute'),
2413 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2416 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2417 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2419 (SELECT player FROM players WHERE nick='Snute'),
2420 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2423 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2424 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2427 (SELECT player FROM players WHERE nick='Haggar'),
2430 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2431 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2433 (SELECT player FROM players WHERE nick='Haggar'),
2434 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2437 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2438 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2440 (SELECT player FROM players WHERE nick='Haggar'),
2441 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2444 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2449 INSERT INTO groups (tournament, round, parallel) VALUES (
2450 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2452 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2455 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
2457 UPDATE rounds SET randomsongs=1 WHERE
2458 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2460 UPDATE rounds SET chosensongs=1 WHERE
2461 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2463 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2467 (SELECT player FROM players WHERE nick='DufF'),
2470 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2471 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2473 (SELECT player FROM players WHERE nick='DufF'),
2474 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2477 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2478 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2480 (SELECT player FROM players WHERE nick='DufF'),
2481 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2484 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2485 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2488 (SELECT player FROM players WHERE nick='Snute'),
2491 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2494 (SELECT player FROM players WHERE nick='Snute'),
2495 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2498 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2499 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2501 (SELECT player FROM players WHERE nick='Snute'),
2502 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2505 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2510 INSERT INTO groups (tournament, round, parallel) VALUES (
2511 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2513 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2516 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
2518 UPDATE rounds SET randomsongs=1 WHERE
2519 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2521 UPDATE rounds SET chosensongs=1 WHERE
2522 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2524 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
2525 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2526 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2528 (SELECT player FROM players WHERE nick='Ylini'),
2531 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2532 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2534 (SELECT player FROM players WHERE nick='Ylini'),
2535 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2538 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2539 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2541 (SELECT player FROM players WHERE nick='Ylini'),
2542 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2545 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2546 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2547 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2549 (SELECT player FROM players WHERE nick='Oliyzia'),
2552 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2553 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2555 (SELECT player FROM players WHERE nick='Oliyzia'),
2556 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2559 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2560 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2562 (SELECT player FROM players WHERE nick='Oliyzia'),
2563 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2566 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2570 (SELECT player FROM players WHERE nick='T|na'),
2573 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2574 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2576 (SELECT player FROM players WHERE nick='T|na'),
2577 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2580 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2581 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2583 (SELECT player FROM players WHERE nick='T|na'),
2584 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2587 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2592 INSERT INTO groups (tournament, round, parallel) VALUES (
2593 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2595 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2596 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2598 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
2600 UPDATE rounds SET randomsongs=1 WHERE
2601 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2603 UPDATE rounds SET chosensongs=1 WHERE
2604 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
2606 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
2607 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2608 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2610 (SELECT player FROM players WHERE nick='T|na'),
2613 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2614 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2616 (SELECT player FROM players WHERE nick='T|na'),
2617 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2620 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2621 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2623 (SELECT player FROM players WHERE nick='T|na'),
2624 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2627 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2628 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2629 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2631 (SELECT player FROM players WHERE nick='Oliyzia'),
2634 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2635 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2637 (SELECT player FROM players WHERE nick='Oliyzia'),
2638 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2641 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2642 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2644 (SELECT player FROM players WHERE nick='Oliyzia'),
2645 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),