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 players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
58 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
59 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
61 (SELECT player FROM players WHERE nick='Andeplane'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
67 (SELECT player FROM players WHERE nick='Andeplane'),
68 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
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('Healing Vision (Angelic Mix)')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
79 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
80 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
82 (SELECT player FROM players WHERE nick='Zeila'),
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='Zeila'),
89 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
92 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
95 (SELECT player FROM players WHERE nick='Zeila'),
96 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
100 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
103 (SELECT player FROM players WHERE nick='Stream'),
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='Stream'),
110 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat 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='Stream'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' 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='Bonzo'),
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='Bonzo'),
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='Bonzo'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
141 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
142 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
145 (SELECT player FROM players WHERE nick='Haggar'),
148 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
149 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
151 (SELECT player FROM players WHERE nick='Haggar'),
152 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
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='Haggar'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
162 INSERT INTO groups (tournament, round, parallel) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
165 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
166 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
168 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
170 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
173 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
175 UPDATE rounds SET randomsongs=2 WHERE
176 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
178 UPDATE rounds SET chosensongs=1 WHERE
179 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
185 (SELECT player FROM players WHERE nick='Chimera'),
188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
191 (SELECT player FROM players WHERE nick='Chimera'),
192 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
195 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
198 (SELECT player FROM players WHERE nick='Chimera'),
199 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
203 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
204 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
206 (SELECT player FROM players WHERE nick='Alexxz'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
212 (SELECT player FROM players WHERE nick='Alexxz'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
219 (SELECT player FROM players WHERE nick='Alexxz'),
220 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' 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='Smiph'),
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='Smiph'),
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='Smiph'),
241 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
245 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
246 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
248 (SELECT player FROM players WHERE nick='Duckling'),
251 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
254 (SELECT player FROM players WHERE nick='Duckling'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
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='Duckling'),
262 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
265 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
266 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
269 (SELECT player FROM players WHERE nick='Pingo'),
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='Pingo'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
279 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
282 (SELECT player FROM players WHERE nick='Pingo'),
283 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
286 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
287 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
290 (SELECT player FROM players WHERE nick='DufF'),
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='DufF'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
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='DufF'),
304 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
307 INSERT INTO groups (tournament, round, parallel) VALUES (
308 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
310 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
313 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
315 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
316 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
320 UPDATE rounds SET randomsongs=2 WHERE
321 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
323 UPDATE rounds SET chosensongs=1 WHERE
324 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
327 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
328 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
330 (SELECT player FROM players WHERE nick='Mickva'),
333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
336 (SELECT player FROM players WHERE nick='Mickva'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
343 (SELECT player FROM players WHERE nick='Mickva'),
344 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
347 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
348 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
351 (SELECT player FROM players WHERE nick='Havok'),
354 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
357 (SELECT player FROM players WHERE nick='Havok'),
358 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
364 (SELECT player FROM players WHERE nick='Havok'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
368 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
369 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
370 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
372 (SELECT player FROM players WHERE nick='Felz'),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
378 (SELECT player FROM players WHERE nick='Felz'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
385 (SELECT player FROM players WHERE nick='Felz'),
386 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
389 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
390 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
393 (SELECT player FROM players WHERE nick='Mync'),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
399 (SELECT player FROM players WHERE nick='Mync'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
406 (SELECT player FROM players WHERE nick='Mync'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' 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='Gogo'),
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='Gogo'),
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='Gogo'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
431 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
432 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
433 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
435 (SELECT player FROM players WHERE nick='Snute'),
438 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
441 (SELECT player FROM players WHERE nick='Snute'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
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='Snute'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
452 INSERT INTO groups (tournament, round, parallel) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
455 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
456 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
460 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
461 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
465 UPDATE rounds SET randomsongs=2 WHERE
466 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
468 UPDATE rounds SET chosensongs=1 WHERE
469 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
471 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
472 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
473 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
475 (SELECT player FROM players WHERE nick='Ingviild'),
478 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
481 (SELECT player FROM players WHERE nick='Ingviild'),
482 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
485 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
488 (SELECT player FROM players WHERE nick='Ingviild'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
492 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
494 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
496 (SELECT player FROM players WHERE nick='Ngan'),
499 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
502 (SELECT player FROM players WHERE nick='Ngan'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
506 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
509 (SELECT player FROM players WHERE nick='Ngan'),
510 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
514 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
517 (SELECT player FROM players WHERE nick='Cuivien'),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
523 (SELECT player FROM players WHERE nick='Cuivien'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
530 (SELECT player FROM players WHERE nick='Cuivien'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
538 (SELECT player FROM players WHERE nick='Daniil'),
541 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
544 (SELECT player FROM players WHERE nick='Daniil'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
551 (SELECT player FROM players WHERE nick='Daniil'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
555 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
556 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
557 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
559 (SELECT player FROM players WHERE nick='Olemann'),
562 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
565 (SELECT player FROM players WHERE nick='Olemann'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
569 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
572 (SELECT player FROM players WHERE nick='Olemann'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
576 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
577 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
580 (SELECT player FROM players WHERE nick='RiChY'),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
586 (SELECT player FROM players WHERE nick='RiChY'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
590 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
593 (SELECT player FROM players WHERE nick='RiChY'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
597 INSERT INTO groups (tournament, round, parallel) VALUES (
598 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
600 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
601 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
603 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
605 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
606 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
610 UPDATE rounds SET randomsongs=2 WHERE
611 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
613 UPDATE rounds SET chosensongs=1 WHERE
614 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
616 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
617 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
618 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
620 (SELECT player FROM players WHERE nick='Maxion'),
623 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
626 (SELECT player FROM players WHERE nick='Maxion'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
630 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
633 (SELECT player FROM players WHERE nick='Maxion'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
637 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
641 (SELECT player FROM players WHERE nick='Lindaninja'),
644 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
647 (SELECT player FROM players WHERE nick='Lindaninja'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
651 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
652 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
654 (SELECT player FROM players WHERE nick='Lindaninja'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
658 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
659 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
660 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
662 (SELECT player FROM players WHERE nick='Asphodel'),
665 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
668 (SELECT player FROM players WHERE nick='Asphodel'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
672 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
673 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
675 (SELECT player FROM players WHERE nick='Asphodel'),
676 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
679 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
680 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
681 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
683 (SELECT player FROM players WHERE nick='Cehtna'),
686 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
689 (SELECT player FROM players WHERE nick='Cehtna'),
690 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
693 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
694 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
696 (SELECT player FROM players WHERE nick='Cehtna'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
700 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
701 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
702 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
704 (SELECT player FROM players WHERE nick='T|na'),
707 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
710 (SELECT player FROM players WHERE nick='T|na'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
714 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
717 (SELECT player FROM players WHERE nick='T|na'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
723 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
725 (SELECT player FROM players WHERE nick='Ylini'),
728 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
731 (SELECT player FROM players WHERE nick='Ylini'),
732 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
738 (SELECT player FROM players WHERE nick='Ylini'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
742 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
743 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
744 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
746 (SELECT player FROM players WHERE nick='OJK'),
749 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
752 (SELECT player FROM players WHERE nick='OJK'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
756 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
759 (SELECT player FROM players WHERE nick='OJK'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
763 INSERT INTO groups (tournament, round, parallel) VALUES (
764 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
766 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
769 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
771 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
772 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
776 UPDATE rounds SET randomsongs=2 WHERE
777 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
779 UPDATE rounds SET chosensongs=1 WHERE
780 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
782 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
784 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
786 (SELECT player FROM players WHERE nick='Athena'),
789 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
792 (SELECT player FROM players WHERE nick='Athena'),
793 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
796 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
799 (SELECT player FROM players WHERE nick='Athena'),
800 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
803 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
804 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
805 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
807 (SELECT player FROM players WHERE nick='Andre'),
810 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
811 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
813 (SELECT player FROM players WHERE nick='Andre'),
814 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
817 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
820 (SELECT player FROM players WHERE nick='Andre'),
821 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
824 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
828 (SELECT player FROM players WHERE nick='Marilla'),
831 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
834 (SELECT player FROM players WHERE nick='Marilla'),
835 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
838 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
841 (SELECT player FROM players WHERE nick='Marilla'),
842 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
845 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
846 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
847 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
849 (SELECT player FROM players WHERE nick='Ozon'),
852 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
855 (SELECT player FROM players WHERE nick='Ozon'),
856 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
859 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
860 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
862 (SELECT player FROM players WHERE nick='Ozon'),
863 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
866 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
867 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
868 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
870 (SELECT player FROM players WHERE nick='Haanz'),
873 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
874 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
876 (SELECT player FROM players WHERE nick='Haanz'),
877 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
880 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
881 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
883 (SELECT player FROM players WHERE nick='Haanz'),
884 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
889 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
891 (SELECT player FROM players WHERE nick='Nameless'),
894 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
897 (SELECT player FROM players WHERE nick='Nameless'),
898 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
901 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
902 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
904 (SELECT player FROM players WHERE nick='Nameless'),
905 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
908 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
909 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
910 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
912 (SELECT player FROM players WHERE nick='Oliyzia'),
915 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
916 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
918 (SELECT player FROM players WHERE nick='Oliyzia'),
919 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
925 (SELECT player FROM players WHERE nick='Oliyzia'),
926 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
929 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
931 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
934 INSERT INTO groups (tournament, round, parallel) VALUES (
935 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
937 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
938 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
942 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
943 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
945 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
947 UPDATE rounds SET randomsongs=2 WHERE
948 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
950 UPDATE rounds SET chosensongs=1 WHERE
951 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
953 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
954 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
955 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
957 (SELECT player FROM players WHERE nick='Bonzo'),
960 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
961 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
963 (SELECT player FROM players WHERE nick='Bonzo'),
964 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
967 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
968 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
970 (SELECT player FROM players WHERE nick='Bonzo'),
971 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
974 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
975 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
976 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
978 (SELECT player FROM players WHERE nick='Mync'),
981 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
982 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
984 (SELECT player FROM players WHERE nick='Mync'),
985 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
988 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
989 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
991 (SELECT player FROM players WHERE nick='Mync'),
992 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
995 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
996 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
997 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
999 (SELECT player FROM players WHERE nick='Haggar'),
1002 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1005 (SELECT player FROM players WHERE nick='Haggar'),
1006 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1009 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1010 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1012 (SELECT player FROM players WHERE nick='Haggar'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1016 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1017 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1018 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1020 (SELECT player FROM players WHERE nick='Daniil'),
1023 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1024 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1026 (SELECT player FROM players WHERE nick='Daniil'),
1027 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1030 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1031 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1033 (SELECT player FROM players WHERE nick='Daniil'),
1034 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1037 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1038 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1039 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1041 (SELECT player FROM players WHERE nick='Snute'),
1044 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1045 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1047 (SELECT player FROM players WHERE nick='Snute'),
1048 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1051 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1054 (SELECT player FROM players WHERE nick='Snute'),
1055 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1058 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1059 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1060 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1062 (SELECT player FROM players WHERE nick='OJK'),
1065 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1068 (SELECT player FROM players WHERE nick='OJK'),
1069 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1072 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1073 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1075 (SELECT player FROM players WHERE nick='OJK'),
1076 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1079 INSERT INTO groups (tournament, round, parallel) VALUES (
1080 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1082 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1083 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
1087 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1088 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1090 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1092 UPDATE rounds SET randomsongs=2 WHERE
1093 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1095 UPDATE rounds SET chosensongs=1 WHERE
1096 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1098 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1102 (SELECT player FROM players WHERE nick='Ozon'),
1105 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1108 (SELECT player FROM players WHERE nick='Ozon'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1112 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1115 (SELECT player FROM players WHERE nick='Ozon'),
1116 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1119 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1123 (SELECT player FROM players WHERE nick='RiChY'),
1126 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1129 (SELECT player FROM players WHERE nick='RiChY'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1133 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1134 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1136 (SELECT player FROM players WHERE nick='RiChY'),
1137 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1140 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1141 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1144 (SELECT player FROM players WHERE nick='Oliyzia'),
1147 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1148 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1150 (SELECT player FROM players WHERE nick='Oliyzia'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1154 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1155 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1157 (SELECT player FROM players WHERE nick='Oliyzia'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1161 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1162 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1165 (SELECT player FROM players WHERE nick='T|na'),
1168 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1171 (SELECT player FROM players WHERE nick='T|na'),
1172 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1175 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1178 (SELECT player FROM players WHERE nick='T|na'),
1179 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1182 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1183 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1186 (SELECT player FROM players WHERE nick='Nameless'),
1189 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1190 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1192 (SELECT player FROM players WHERE nick='Nameless'),
1193 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1196 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1199 (SELECT player FROM players WHERE nick='Nameless'),
1200 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1203 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1204 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1205 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1207 (SELECT player FROM players WHERE nick='Olemann'),
1210 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1211 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1213 (SELECT player FROM players WHERE nick='Olemann'),
1214 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1217 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1218 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1220 (SELECT player FROM players WHERE nick='Olemann'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1224 INSERT INTO groups (tournament, round, parallel) VALUES (
1225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1227 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1228 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1232 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1233 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1235 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1237 UPDATE rounds SET randomsongs=2 WHERE
1238 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1240 UPDATE rounds SET chosensongs=1 WHERE
1241 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1243 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1247 (SELECT player FROM players WHERE nick='Ylini'),
1250 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1251 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1253 (SELECT player FROM players WHERE nick='Ylini'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1257 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1258 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1260 (SELECT player FROM players WHERE nick='Ylini'),
1261 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1264 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1265 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1268 (SELECT player FROM players WHERE nick='Pingo'),
1271 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1274 (SELECT player FROM players WHERE nick='Pingo'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1278 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1279 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1281 (SELECT player FROM players WHERE nick='Pingo'),
1282 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1285 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1286 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1289 (SELECT player FROM players WHERE nick='Gogo'),
1292 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1293 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1295 (SELECT player FROM players WHERE nick='Gogo'),
1296 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1299 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1300 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1302 (SELECT player FROM players WHERE nick='Gogo'),
1303 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1306 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1308 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1310 (SELECT player FROM players WHERE nick='Duckling'),
1313 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1314 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1316 (SELECT player FROM players WHERE nick='Duckling'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1320 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1321 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1323 (SELECT player FROM players WHERE nick='Duckling'),
1324 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1327 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1328 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1331 (SELECT player FROM players WHERE nick='Stream'),
1334 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1337 (SELECT player FROM players WHERE nick='Stream'),
1338 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1341 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1344 (SELECT player FROM players WHERE nick='Stream'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1348 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1352 (SELECT player FROM players WHERE nick='DufF'),
1355 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1358 (SELECT player FROM players WHERE nick='DufF'),
1359 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1362 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1363 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1365 (SELECT player FROM players WHERE nick='DufF'),
1366 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1369 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1374 INSERT INTO groups (tournament, round, parallel) VALUES (
1375 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1377 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1378 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1380 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1382 UPDATE rounds SET randomsongs=1 WHERE
1383 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1385 UPDATE rounds SET chosensongs=1 WHERE
1386 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1388 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1389 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1392 (SELECT player FROM players WHERE nick='RiChY'),
1395 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1396 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1398 (SELECT player FROM players WHERE nick='RiChY'),
1399 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1402 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1406 (SELECT player FROM players WHERE nick='Pingo'),
1409 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1410 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1412 (SELECT player FROM players WHERE nick='Pingo'),
1413 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1416 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1417 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1420 (SELECT player FROM players WHERE nick='OJK'),
1423 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1424 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1426 (SELECT player FROM players WHERE nick='OJK'),
1427 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1430 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1431 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1434 (SELECT player FROM players WHERE nick='T|na'),
1437 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1440 (SELECT player FROM players WHERE nick='T|na'),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1444 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1448 (SELECT player FROM players WHERE nick='Haggar'),
1451 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1454 (SELECT player FROM players WHERE nick='Haggar'),
1455 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1458 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1459 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1462 (SELECT player FROM players WHERE nick='Gogo'),
1465 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1466 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1468 (SELECT player FROM players WHERE nick='Gogo'),
1469 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1472 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1473 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1476 (SELECT player FROM players WHERE nick='Nameless'),
1479 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1480 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1482 (SELECT player FROM players WHERE nick='Nameless'),
1483 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1486 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1487 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1490 (SELECT player FROM players WHERE nick='DufF'),
1493 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1494 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1496 (SELECT player FROM players WHERE nick='DufF'),
1497 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1500 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1501 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1504 (SELECT player FROM players WHERE nick='Snute'),
1507 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1508 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1510 (SELECT player FROM players WHERE nick='Snute'),
1511 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1514 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1519 INSERT INTO groups (tournament, round, parallel) VALUES (
1520 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1522 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1523 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1527 UPDATE rounds SET randomsongs=1 WHERE
1528 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1530 UPDATE rounds SET chosensongs=1 WHERE
1531 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1533 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1534 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1535 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1537 (SELECT player FROM players WHERE nick='Gogo'),
1540 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1541 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1543 (SELECT player FROM players WHERE nick='Gogo'),
1544 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1547 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1548 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1551 (SELECT player FROM players WHERE nick='Haggar'),
1554 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1555 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1557 (SELECT player FROM players WHERE nick='Haggar'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1561 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1562 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1565 (SELECT player FROM players WHERE nick='Nameless'),
1568 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1569 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1571 (SELECT player FROM players WHERE nick='Nameless'),
1572 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1575 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1576 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1577 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1579 (SELECT player FROM players WHERE nick='RiChY'),
1582 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1583 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1585 (SELECT player FROM players WHERE nick='RiChY'),
1586 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1589 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1593 (SELECT player FROM players WHERE nick='DufF'),
1596 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1597 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1599 (SELECT player FROM players WHERE nick='DufF'),
1600 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1603 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1604 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1607 (SELECT player FROM players WHERE nick='OJK'),
1610 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1611 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1613 (SELECT player FROM players WHERE nick='OJK'),
1614 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1617 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1618 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1619 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1621 (SELECT player FROM players WHERE nick='Snute'),
1624 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1625 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1627 (SELECT player FROM players WHERE nick='Snute'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1631 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1636 INSERT INTO groups (tournament, round, parallel) VALUES (
1637 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1639 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1642 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
1644 UPDATE rounds SET randomsongs=1 WHERE
1645 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1647 UPDATE rounds SET chosensongs=1 WHERE
1648 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1650 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1652 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1654 (SELECT player FROM players WHERE nick='RiChY'),
1657 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1658 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1660 (SELECT player FROM players WHERE nick='RiChY'),
1661 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1664 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1665 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1668 (SELECT player FROM players WHERE nick='DufF'),
1671 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1672 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1674 (SELECT player FROM players WHERE nick='DufF'),
1675 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1678 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1679 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1680 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1682 (SELECT player FROM players WHERE nick='OJK'),
1685 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1688 (SELECT player FROM players WHERE nick='OJK'),
1689 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1692 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1693 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1694 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1696 (SELECT player FROM players WHERE nick='Snute'),
1699 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1700 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1702 (SELECT player FROM players WHERE nick='Snute'),
1703 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1706 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1707 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1710 (SELECT player FROM players WHERE nick='Haggar'),
1713 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1714 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1716 (SELECT player FROM players WHERE nick='Haggar'),
1717 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1720 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1722 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1725 INSERT INTO groups (tournament, round, parallel) VALUES (
1726 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1728 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1731 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1733 UPDATE rounds SET randomsongs=1 WHERE
1734 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1736 UPDATE rounds SET chosensongs=1 WHERE
1737 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1739 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1740 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1741 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1743 (SELECT player FROM players WHERE nick='Haggar'),
1746 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1747 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1749 (SELECT player FROM players WHERE nick='Haggar'),
1750 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1753 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1754 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1757 (SELECT player FROM players WHERE nick='OJK'),
1760 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1761 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1763 (SELECT player FROM players WHERE nick='OJK'),
1764 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1767 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1768 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1771 (SELECT player FROM players WHERE nick='DufF'),
1774 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1775 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1777 (SELECT player FROM players WHERE nick='DufF'),
1778 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1781 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1783 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1785 (SELECT player FROM players WHERE nick='Snute'),
1788 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1789 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1791 (SELECT player FROM players WHERE nick='Snute'),
1792 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1795 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1800 INSERT INTO groups (tournament, round, parallel) VALUES (
1801 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1803 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1804 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1806 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1808 UPDATE rounds SET randomsongs=1 WHERE
1809 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1811 UPDATE rounds SET chosensongs=1 WHERE
1812 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1814 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1815 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1816 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1818 (SELECT player FROM players WHERE nick='DufF'),
1821 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1822 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1824 (SELECT player FROM players WHERE nick='DufF'),
1825 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1828 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1829 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1830 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1832 (SELECT player FROM players WHERE nick='Snute'),
1835 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1836 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1838 (SELECT player FROM players WHERE nick='Snute'),
1839 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1842 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1844 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1846 (SELECT player FROM players WHERE nick='Haggar'),
1849 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1850 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1852 (SELECT player FROM players WHERE nick='Haggar'),
1853 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1856 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1858 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1861 INSERT INTO groups (tournament, round, parallel) VALUES (
1862 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1864 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1865 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1867 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
1869 UPDATE rounds SET randomsongs=1 WHERE
1870 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1872 UPDATE rounds SET chosensongs=1 WHERE
1873 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1875 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1876 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1879 (SELECT player FROM players WHERE nick='DufF'),
1882 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1885 (SELECT player FROM players WHERE nick='DufF'),
1886 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1889 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1890 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1891 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1893 (SELECT player FROM players WHERE nick='Snute'),
1896 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1897 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1899 (SELECT player FROM players WHERE nick='Snute'),
1900 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1903 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1908 INSERT INTO groups (tournament, round, parallel) VALUES (
1909 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1911 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1912 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1914 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
1916 UPDATE rounds SET randomsongs=1 WHERE
1917 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1919 UPDATE rounds SET chosensongs=1 WHERE
1920 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1922 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1923 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1924 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1926 (SELECT player FROM players WHERE nick='Ylini'),
1929 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1930 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1932 (SELECT player FROM players WHERE nick='Ylini'),
1933 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1936 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1937 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1938 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1940 (SELECT player FROM players WHERE nick='Oliyzia'),
1943 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1944 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1946 (SELECT player FROM players WHERE nick='Oliyzia'),
1947 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1950 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1951 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1952 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1954 (SELECT player FROM players WHERE nick='T|na'),
1957 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1960 (SELECT player FROM players WHERE nick='T|na'),
1961 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1964 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1966 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1969 INSERT INTO groups (tournament, round, parallel) VALUES (
1970 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1972 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1973 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1975 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1977 UPDATE rounds SET randomsongs=1 WHERE
1978 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1980 UPDATE rounds SET chosensongs=1 WHERE
1981 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM') AND
1983 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1984 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1985 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1987 (SELECT player FROM players WHERE nick='T|na'),
1990 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1991 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
1993 (SELECT player FROM players WHERE nick='T|na'),
1994 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1997 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1998 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1999 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2001 (SELECT player FROM players WHERE nick='Oliyzia'),
2004 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2005 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 5 - NM'),
2007 (SELECT player FROM players WHERE nick='Oliyzia'),
2008 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),