2 INSERT INTO tournaments
3 (season, name, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
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 2'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
28 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' 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 2'),
40 (SELECT player FROM players WHERE nick='Bush'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
46 (SELECT player FROM players WHERE nick='Bush'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
53 (SELECT player FROM players WHERE nick='Bush'),
54 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
57 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' 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 2'),
61 (SELECT player FROM players WHERE nick='Ylini'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
67 (SELECT player FROM players WHERE nick='Ylini'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
74 (SELECT player FROM players WHERE nick='Ylini'),
75 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' 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 2'),
82 (SELECT player FROM players WHERE nick='Stream'),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
88 (SELECT player FROM players WHERE nick='Stream'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
92 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
95 (SELECT player FROM players WHERE nick='Stream'),
96 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' 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 2'),
103 (SELECT player FROM players WHERE nick='T|na'),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
109 (SELECT player FROM players WHERE nick='T|na'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
116 (SELECT player FROM players WHERE nick='T|na'),
117 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' 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 2'),
124 (SELECT player FROM players WHERE nick='Snute'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
130 (SELECT player FROM players WHERE nick='Snute'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
137 (SELECT player FROM players WHERE nick='Snute'),
138 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
141 INSERT INTO groups (tournament, round, parallel) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
144 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
145 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
147 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
149 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
154 UPDATE rounds SET randomsongs=2 WHERE
155 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
157 UPDATE rounds SET chosensongs=1 WHERE
158 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
164 (SELECT player FROM players WHERE nick='Dabi'),
167 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
170 (SELECT player FROM players WHERE nick='Dabi'),
171 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
177 (SELECT player FROM players WHERE nick='Dabi'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 2'),
185 (SELECT player FROM players WHERE nick='Olemann'),
188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
191 (SELECT player FROM players WHERE nick='Olemann'),
192 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
195 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
198 (SELECT player FROM players WHERE nick='Olemann'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' 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 2'),
206 (SELECT player FROM players WHERE nick='Smiph'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
212 (SELECT player FROM players WHERE nick='Smiph'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
219 (SELECT player FROM players WHERE nick='Smiph'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' 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 2'),
227 (SELECT player FROM players WHERE nick='RiChY'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
233 (SELECT player FROM players WHERE nick='RiChY'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
240 (SELECT player FROM players WHERE nick='RiChY'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' 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 2'),
248 (SELECT player FROM players WHERE nick='DufF'),
251 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
254 (SELECT player FROM players WHERE nick='DufF'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
261 (SELECT player FROM players WHERE nick='DufF'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
265 INSERT INTO groups (tournament, round, parallel) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
268 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
269 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
271 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
276 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
278 UPDATE rounds SET randomsongs=2 WHERE
279 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
281 UPDATE rounds SET chosensongs=1 WHERE
282 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
284 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
285 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
286 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
288 (SELECT player FROM players WHERE nick='Raazu'),
291 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
294 (SELECT player FROM players WHERE nick='Raazu'),
295 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
298 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
301 (SELECT player FROM players WHERE nick='Raazu'),
302 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
305 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
309 (SELECT player FROM players WHERE nick='Draconia'),
312 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
315 (SELECT player FROM players WHERE nick='Draconia'),
316 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
319 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
322 (SELECT player FROM players WHERE nick='Draconia'),
323 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' 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 2'),
330 (SELECT player FROM players WHERE nick='Havok'),
333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
336 (SELECT player FROM players WHERE nick='Havok'),
337 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
343 (SELECT player FROM players WHERE nick='Havok'),
344 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
347 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' 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 2'),
351 (SELECT player FROM players WHERE nick='Snofox'),
354 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
357 (SELECT player FROM players WHERE nick='Snofox'),
358 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
364 (SELECT player FROM players WHERE nick='Snofox'),
365 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
368 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' 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 2'),
372 (SELECT player FROM players WHERE nick='OJK'),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
378 (SELECT player FROM players WHERE nick='OJK'),
379 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
385 (SELECT player FROM players WHERE nick='OJK'),
386 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
389 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
394 INSERT INTO groups (tournament, round, parallel) VALUES (
395 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
397 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
398 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
402 UPDATE rounds SET randomsongs=1 WHERE
403 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
405 UPDATE rounds SET chosensongs=1 WHERE
406 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
408 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
409 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
410 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
412 (SELECT player FROM players WHERE nick='Raazu'),
415 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
416 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
418 (SELECT player FROM players WHERE nick='Raazu'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
422 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
423 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
424 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
426 (SELECT player FROM players WHERE nick='Stream'),
429 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
430 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
432 (SELECT player FROM players WHERE nick='Stream'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
436 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
437 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
438 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
440 (SELECT player FROM players WHERE nick='Olemann'),
443 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
444 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
446 (SELECT player FROM players WHERE nick='Olemann'),
447 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
450 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
451 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
454 (SELECT player FROM players WHERE nick='T|na'),
457 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
458 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
460 (SELECT player FROM players WHERE nick='T|na'),
461 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
464 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
465 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
466 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
468 (SELECT player FROM players WHERE nick='Snofox'),
471 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
472 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
474 (SELECT player FROM players WHERE nick='Snofox'),
475 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
478 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
479 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
480 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
482 (SELECT player FROM players WHERE nick='RiChY'),
485 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
488 (SELECT player FROM players WHERE nick='RiChY'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
492 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' 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 2'),
496 (SELECT player FROM players WHERE nick='Snute'),
499 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
502 (SELECT player FROM players WHERE nick='Snute'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
506 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
507 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
508 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
510 (SELECT player FROM players WHERE nick='OJK'),
513 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
516 (SELECT player FROM players WHERE nick='OJK'),
517 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
520 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
521 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
522 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
524 (SELECT player FROM players WHERE nick='DufF'),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
530 (SELECT player FROM players WHERE nick='DufF'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
534 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
539 INSERT INTO groups (tournament, round, parallel) VALUES (
540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
542 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
547 UPDATE rounds SET randomsongs=1 WHERE
548 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
550 UPDATE rounds SET chosensongs=1 WHERE
551 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
553 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
554 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
555 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
557 (SELECT player FROM players WHERE nick='Stream'),
560 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
563 (SELECT player FROM players WHERE nick='Stream'),
564 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
567 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
568 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
569 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
571 (SELECT player FROM players WHERE nick='T|na'),
574 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
575 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
577 (SELECT player FROM players WHERE nick='T|na'),
578 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
581 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
582 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
583 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
585 (SELECT player FROM players WHERE nick='RiChY'),
588 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
591 (SELECT player FROM players WHERE nick='RiChY'),
592 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
595 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
597 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
599 (SELECT player FROM players WHERE nick='Snofox'),
602 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
605 (SELECT player FROM players WHERE nick='Snofox'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
609 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
610 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
611 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
613 (SELECT player FROM players WHERE nick='OJK'),
616 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
617 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
619 (SELECT player FROM players WHERE nick='OJK'),
620 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
623 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
624 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
625 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
627 (SELECT player FROM players WHERE nick='Snute'),
630 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
633 (SELECT player FROM players WHERE nick='Snute'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
637 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' 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 2'),
641 (SELECT player FROM players WHERE nick='DufF'),
644 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
647 (SELECT player FROM players WHERE nick='DufF'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
651 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
653 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
656 INSERT INTO groups (tournament, round, parallel) VALUES (
657 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
659 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
660 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
662 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
664 UPDATE rounds SET randomsongs=1 WHERE
665 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
667 UPDATE rounds SET chosensongs=1 WHERE
668 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
670 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
671 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
672 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
674 (SELECT player FROM players WHERE nick='OJK'),
677 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
678 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
680 (SELECT player FROM players WHERE nick='OJK'),
681 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
684 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
685 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
686 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
688 (SELECT player FROM players WHERE nick='T|na'),
691 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
694 (SELECT player FROM players WHERE nick='T|na'),
695 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
698 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
699 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
700 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
702 (SELECT player FROM players WHERE nick='Snofox'),
705 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
708 (SELECT player FROM players WHERE nick='Snofox'),
709 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
712 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
713 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
714 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
716 (SELECT player FROM players WHERE nick='DufF'),
719 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
720 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
722 (SELECT player FROM players WHERE nick='DufF'),
723 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
726 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
727 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
728 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
730 (SELECT player FROM players WHERE nick='Snute'),
733 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
736 (SELECT player FROM players WHERE nick='Snute'),
737 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
740 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
742 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
745 INSERT INTO groups (tournament, round, parallel) VALUES (
746 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
748 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
749 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
751 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
753 UPDATE rounds SET randomsongs=1 WHERE
754 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
756 UPDATE rounds SET chosensongs=1 WHERE
757 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
759 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
760 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
761 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
763 (SELECT player FROM players WHERE nick='Snofox'),
766 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
769 (SELECT player FROM players WHERE nick='Snofox'),
770 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
773 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
774 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
775 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
777 (SELECT player FROM players WHERE nick='DufF'),
780 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
781 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
783 (SELECT player FROM players WHERE nick='DufF'),
784 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
787 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
788 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
789 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
791 (SELECT player FROM players WHERE nick='OJK'),
794 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
797 (SELECT player FROM players WHERE nick='OJK'),
798 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
801 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
802 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
803 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
805 (SELECT player FROM players WHERE nick='Snute'),
808 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
811 (SELECT player FROM players WHERE nick='Snute'),
812 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
815 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
817 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
820 INSERT INTO groups (tournament, round, parallel) VALUES (
821 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
823 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
824 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
826 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
828 UPDATE rounds SET randomsongs=1 WHERE
829 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
831 UPDATE rounds SET chosensongs=1 WHERE
832 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
834 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
835 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
836 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
838 (SELECT player FROM players WHERE nick='OJK'),
841 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
844 (SELECT player FROM players WHERE nick='OJK'),
845 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
848 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
849 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
850 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
852 (SELECT player FROM players WHERE nick='DufF'),
855 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
856 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
858 (SELECT player FROM players WHERE nick='DufF'),
859 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
862 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
863 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
864 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
866 (SELECT player FROM players WHERE nick='Snute'),
869 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
872 (SELECT player FROM players WHERE nick='Snute'),
873 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
876 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
878 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
881 INSERT INTO groups (tournament, round, parallel) VALUES (
882 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
884 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
885 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
887 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
889 UPDATE rounds SET randomsongs=1 WHERE
890 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
892 UPDATE rounds SET chosensongs=1 WHERE
893 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
895 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
896 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
897 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
899 (SELECT player FROM players WHERE nick='Snute'),
902 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
905 (SELECT player FROM players WHERE nick='Snute'),
906 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
909 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
910 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
911 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
913 (SELECT player FROM players WHERE nick='OJK'),
916 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
917 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
919 (SELECT player FROM players WHERE nick='OJK'),
920 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),