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 3'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
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 3'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' 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 3'),
40 (SELECT player FROM players WHERE nick='Ted Kristian'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
46 (SELECT player FROM players WHERE nick='Ted Kristian'),
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 3'),
53 (SELECT player FROM players WHERE nick='Ted Kristian'),
54 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
57 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' 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 3'),
61 (SELECT player FROM players WHERE nick='Pål Andre'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
67 (SELECT player FROM players WHERE nick='Pål Andre'),
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 3'),
74 (SELECT player FROM players WHERE nick='Pål Andre'),
75 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' 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 3'),
82 (SELECT player FROM players WHERE nick='Mulefisk'),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
88 (SELECT player FROM players WHERE nick='Mulefisk'),
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 3'),
95 (SELECT player FROM players WHERE nick='Mulefisk'),
96 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' 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 3'),
103 (SELECT player FROM players WHERE nick='Haggar'),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
109 (SELECT player FROM players WHERE nick='Haggar'),
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 3'),
116 (SELECT player FROM players WHERE nick='Haggar'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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 3'),
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 3'),
130 (SELECT player FROM players WHERE nick='Snute'),
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 3'),
137 (SELECT player FROM players WHERE nick='Snute'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
141 INSERT INTO groups (tournament, round, parallel) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
144 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
145 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
147 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
149 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
154 UPDATE rounds SET randomsongs=2 WHERE
155 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
157 UPDATE rounds SET chosensongs=1 WHERE
158 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' 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 3'),
164 (SELECT player FROM players WHERE nick='Jim Andre'),
167 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
170 (SELECT player FROM players WHERE nick='Jim Andre'),
171 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
177 (SELECT player FROM players WHERE nick='Jim Andre'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' 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 3'),
185 (SELECT player FROM players WHERE nick='Andre'),
188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
191 (SELECT player FROM players WHERE nick='Andre'),
192 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
195 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
198 (SELECT player FROM players WHERE nick='Andre'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' 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 3'),
206 (SELECT player FROM players WHERE nick='Dabi'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
212 (SELECT player FROM players WHERE nick='Dabi'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
219 (SELECT player FROM players WHERE nick='Dabi'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' 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 3'),
227 (SELECT player FROM players WHERE nick='Oliyzia'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
233 (SELECT player FROM players WHERE nick='Oliyzia'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
240 (SELECT player FROM players WHERE nick='Oliyzia'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' 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 3'),
248 (SELECT player FROM players WHERE nick='OJK'),
251 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
254 (SELECT player FROM players WHERE nick='OJK'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
261 (SELECT player FROM players WHERE nick='OJK'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
265 INSERT INTO groups (tournament, round, parallel) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
268 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
269 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
271 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
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 3') AND
281 UPDATE rounds SET chosensongs=1 WHERE
282 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
284 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' 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 3'),
288 (SELECT player FROM players WHERE nick='Glukko'),
291 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
294 (SELECT player FROM players WHERE nick='Glukko'),
295 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
298 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
301 (SELECT player FROM players WHERE nick='Glukko'),
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, 'Ole-Christian' AS nick WHERE 'Ole-Christian' 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 3'),
309 (SELECT player FROM players WHERE nick='Ole-Christian'),
312 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
315 (SELECT player FROM players WHERE nick='Ole-Christian'),
316 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
319 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
322 (SELECT player FROM players WHERE nick='Ole-Christian'),
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, 'Zyc' AS nick WHERE 'Zyc' 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 3'),
330 (SELECT player FROM players WHERE nick='Zyc'),
333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
336 (SELECT player FROM players WHERE nick='Zyc'),
337 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
343 (SELECT player FROM players WHERE nick='Zyc'),
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, 'Ylini' AS nick WHERE 'Ylini' 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 3'),
351 (SELECT player FROM players WHERE nick='Ylini'),
354 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
357 (SELECT player FROM players WHERE nick='Ylini'),
358 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
364 (SELECT player FROM players WHERE nick='Ylini'),
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, 'DufF' AS nick WHERE 'DufF' 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 3'),
372 (SELECT player FROM players WHERE nick='DufF'),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
378 (SELECT player FROM players WHERE nick='DufF'),
379 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
385 (SELECT player FROM players WHERE nick='DufF'),
386 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
389 INSERT INTO groups (tournament, round, parallel) VALUES (
390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
392 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
393 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
395 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
397 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
398 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
402 UPDATE rounds SET randomsongs=2 WHERE
403 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
405 UPDATE rounds SET chosensongs=1 WHERE
406 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
408 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' 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 3'),
412 (SELECT player FROM players WHERE nick='Th0rny'),
415 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
416 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
418 (SELECT player FROM players WHERE nick='Th0rny'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
422 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
425 (SELECT player FROM players WHERE nick='Th0rny'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
429 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
430 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
431 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
433 (SELECT player FROM players WHERE nick='Nameless'),
436 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
439 (SELECT player FROM players WHERE nick='Nameless'),
440 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
443 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
444 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
446 (SELECT player FROM players WHERE nick='Nameless'),
447 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
450 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' 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 3'),
454 (SELECT player FROM players WHERE nick='Matsi'),
457 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
458 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
460 (SELECT player FROM players WHERE nick='Matsi'),
461 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
464 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
467 (SELECT player FROM players WHERE nick='Matsi'),
468 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
471 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' 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 3'),
475 (SELECT player FROM players WHERE nick='Draconia'),
478 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
481 (SELECT player FROM players WHERE nick='Draconia'),
482 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
485 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
488 (SELECT player FROM players WHERE nick='Draconia'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
492 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' 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 3'),
496 (SELECT player FROM players WHERE nick='RiChY'),
499 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
502 (SELECT player FROM players WHERE nick='RiChY'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
506 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
509 (SELECT player FROM players WHERE nick='RiChY'),
510 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
513 INSERT INTO groups (tournament, round, parallel) VALUES (
514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
516 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
517 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
521 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
522 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
526 UPDATE rounds SET randomsongs=2 WHERE
527 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
529 UPDATE rounds SET chosensongs=1 WHERE
530 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
532 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
533 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
534 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
536 (SELECT player FROM players WHERE nick='Eruanna'),
539 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
542 (SELECT player FROM players WHERE nick='Eruanna'),
543 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
546 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
549 (SELECT player FROM players WHERE nick='Eruanna'),
550 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
553 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' 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 3'),
557 (SELECT player FROM players WHERE nick='Advena'),
560 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
563 (SELECT player FROM players WHERE nick='Advena'),
564 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
567 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
570 (SELECT player FROM players WHERE nick='Advena'),
571 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
574 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
575 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
576 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
578 (SELECT player FROM players WHERE nick='Tassen'),
581 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
584 (SELECT player FROM players WHERE nick='Tassen'),
585 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
588 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
591 (SELECT player FROM players WHERE nick='Tassen'),
592 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
595 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' 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 3'),
599 (SELECT player FROM players WHERE nick='Duckling'),
602 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
605 (SELECT player FROM players WHERE nick='Duckling'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
609 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
612 (SELECT player FROM players WHERE nick='Duckling'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
616 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 3'),
620 (SELECT player FROM players WHERE nick='Olemann'),
623 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
626 (SELECT player FROM players WHERE nick='Olemann'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
630 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
633 (SELECT player FROM players WHERE nick='Olemann'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
637 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' 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 3'),
641 (SELECT player FROM players WHERE nick='T|na'),
644 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
647 (SELECT player FROM players WHERE nick='T|na'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
651 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
652 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
654 (SELECT player FROM players WHERE nick='T|na'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
658 INSERT INTO groups (tournament, round, parallel) VALUES (
659 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
661 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
662 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
664 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
666 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
671 UPDATE rounds SET randomsongs=2 WHERE
672 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
674 UPDATE rounds SET chosensongs=1 WHERE
675 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
677 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
678 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
679 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
681 (SELECT player FROM players WHERE nick='Bonzo'),
684 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
685 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
687 (SELECT player FROM players WHERE nick='Bonzo'),
688 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
691 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
694 (SELECT player FROM players WHERE nick='Bonzo'),
695 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
698 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' 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 3'),
702 (SELECT player FROM players WHERE nick='Gollum'),
705 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
708 (SELECT player FROM players WHERE nick='Gollum'),
709 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
712 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
715 (SELECT player FROM players WHERE nick='Gollum'),
716 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
719 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
720 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
721 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
723 (SELECT player FROM players WHERE nick='Hugo'),
726 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
729 (SELECT player FROM players WHERE nick='Hugo'),
730 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
733 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
736 (SELECT player FROM players WHERE nick='Hugo'),
737 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
740 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
741 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
742 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
744 (SELECT player FROM players WHERE nick='Auran'),
747 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
750 (SELECT player FROM players WHERE nick='Auran'),
751 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
754 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
757 (SELECT player FROM players WHERE nick='Auran'),
758 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
761 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
762 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
763 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
765 (SELECT player FROM players WHERE nick='Smiph'),
768 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
771 (SELECT player FROM players WHERE nick='Smiph'),
772 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
775 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
778 (SELECT player FROM players WHERE nick='Smiph'),
779 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
782 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' 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 3'),
786 (SELECT player FROM players WHERE nick='Stream'),
789 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
792 (SELECT player FROM players WHERE nick='Stream'),
793 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
796 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
799 (SELECT player FROM players WHERE nick='Stream'),
800 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
803 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
805 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
808 INSERT INTO groups (tournament, round, parallel) VALUES (
809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
811 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
812 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
816 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
817 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
819 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
821 UPDATE rounds SET randomsongs=2 WHERE
822 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
824 UPDATE rounds SET chosensongs=1 WHERE
825 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
827 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
828 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
829 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
831 (SELECT player FROM players WHERE nick='Smiph'),
834 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
835 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
837 (SELECT player FROM players WHERE nick='Smiph'),
838 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
841 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
844 (SELECT player FROM players WHERE nick='Smiph'),
845 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
848 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' 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 3'),
852 (SELECT player FROM players WHERE nick='Mulefisk'),
855 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
856 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
858 (SELECT player FROM players WHERE nick='Mulefisk'),
859 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
862 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
863 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
865 (SELECT player FROM players WHERE nick='Mulefisk'),
866 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
869 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
870 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
871 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
873 (SELECT player FROM players WHERE nick='Oliyzia'),
876 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
879 (SELECT player FROM players WHERE nick='Oliyzia'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
883 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
886 (SELECT player FROM players WHERE nick='Oliyzia'),
887 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
890 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
892 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
894 (SELECT player FROM players WHERE nick='Th0rny'),
897 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
900 (SELECT player FROM players WHERE nick='Th0rny'),
901 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
904 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
907 (SELECT player FROM players WHERE nick='Th0rny'),
908 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
911 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
912 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
913 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
915 (SELECT player FROM players WHERE nick='OJK'),
918 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
921 (SELECT player FROM players WHERE nick='OJK'),
922 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
925 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
928 (SELECT player FROM players WHERE nick='OJK'),
929 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
932 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
934 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
936 (SELECT player FROM players WHERE nick='T|na'),
939 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
940 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
942 (SELECT player FROM players WHERE nick='T|na'),
943 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
946 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
949 (SELECT player FROM players WHERE nick='T|na'),
950 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
953 INSERT INTO groups (tournament, round, parallel) VALUES (
954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
956 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
957 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
959 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
961 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
962 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
964 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
966 UPDATE rounds SET randomsongs=2 WHERE
967 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
969 UPDATE rounds SET chosensongs=1 WHERE
970 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
972 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
973 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
974 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
976 (SELECT player FROM players WHERE nick='Dabi'),
979 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
980 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
982 (SELECT player FROM players WHERE nick='Dabi'),
983 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
986 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
989 (SELECT player FROM players WHERE nick='Dabi'),
990 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
993 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
994 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
995 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
997 (SELECT player FROM players WHERE nick='Duckling'),
1000 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1001 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1003 (SELECT player FROM players WHERE nick='Duckling'),
1004 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1007 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1008 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1010 (SELECT player FROM players WHERE nick='Duckling'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1014 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1015 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1016 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1018 (SELECT player FROM players WHERE nick='Ylini'),
1021 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1022 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1024 (SELECT player FROM players WHERE nick='Ylini'),
1025 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1028 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1031 (SELECT player FROM players WHERE nick='Ylini'),
1032 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1035 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1039 (SELECT player FROM players WHERE nick='Stream'),
1042 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1045 (SELECT player FROM players WHERE nick='Stream'),
1046 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1049 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1052 (SELECT player FROM players WHERE nick='Stream'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1057 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1058 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1060 (SELECT player FROM players WHERE nick='Snute'),
1063 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1064 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1066 (SELECT player FROM players WHERE nick='Snute'),
1067 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1070 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1071 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1073 (SELECT player FROM players WHERE nick='Snute'),
1074 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1077 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1078 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1079 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1081 (SELECT player FROM players WHERE nick='Hugo'),
1084 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1087 (SELECT player FROM players WHERE nick='Hugo'),
1088 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1091 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1092 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1094 (SELECT player FROM players WHERE nick='Hugo'),
1095 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1098 INSERT INTO groups (tournament, round, parallel) VALUES (
1099 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1101 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1102 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1106 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1111 UPDATE rounds SET randomsongs=2 WHERE
1112 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1114 UPDATE rounds SET chosensongs=1 WHERE
1115 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1117 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
1118 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1119 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1121 (SELECT player FROM players WHERE nick='Zyc'),
1124 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1125 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1127 (SELECT player FROM players WHERE nick='Zyc'),
1128 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1131 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1132 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1134 (SELECT player FROM players WHERE nick='Zyc'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1139 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1140 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1142 (SELECT player FROM players WHERE nick='Nameless'),
1145 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1146 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1148 (SELECT player FROM players WHERE nick='Nameless'),
1149 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1152 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1155 (SELECT player FROM players WHERE nick='Nameless'),
1156 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1159 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1160 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1161 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1163 (SELECT player FROM players WHERE nick='Haggar'),
1166 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1167 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1169 (SELECT player FROM players WHERE nick='Haggar'),
1170 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1173 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1174 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1176 (SELECT player FROM players WHERE nick='Haggar'),
1177 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1184 (SELECT player FROM players WHERE nick='Olemann'),
1187 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1188 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1190 (SELECT player FROM players WHERE nick='Olemann'),
1191 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1194 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1195 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1197 (SELECT player FROM players WHERE nick='Olemann'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1201 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1202 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1205 (SELECT player FROM players WHERE nick='RiChY'),
1208 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1211 (SELECT player FROM players WHERE nick='RiChY'),
1212 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1215 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1216 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1218 (SELECT player FROM players WHERE nick='RiChY'),
1219 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1224 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1226 (SELECT player FROM players WHERE nick='DufF'),
1229 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1230 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1232 (SELECT player FROM players WHERE nick='DufF'),
1233 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1236 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1237 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1239 (SELECT player FROM players WHERE nick='DufF'),
1240 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1243 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1248 INSERT INTO groups (tournament, round, parallel) VALUES (
1249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1251 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1256 UPDATE rounds SET randomsongs=1 WHERE
1257 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1259 UPDATE rounds SET chosensongs=1 WHERE
1260 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1262 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1263 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1264 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1266 (SELECT player FROM players WHERE nick='Stream'),
1269 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1272 (SELECT player FROM players WHERE nick='Stream'),
1273 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1276 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1277 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1278 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1280 (SELECT player FROM players WHERE nick='T|na'),
1283 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1284 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1286 (SELECT player FROM players WHERE nick='T|na'),
1287 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1290 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1291 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1294 (SELECT player FROM players WHERE nick='DufF'),
1297 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1298 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1300 (SELECT player FROM players WHERE nick='DufF'),
1301 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1304 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1305 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1306 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1308 (SELECT player FROM players WHERE nick='OJK'),
1311 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1312 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1314 (SELECT player FROM players WHERE nick='OJK'),
1315 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1318 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1319 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1322 (SELECT player FROM players WHERE nick='Hugo'),
1325 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1326 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1328 (SELECT player FROM players WHERE nick='Hugo'),
1329 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1332 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1333 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1336 (SELECT player FROM players WHERE nick='RiChY'),
1339 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1340 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1342 (SELECT player FROM players WHERE nick='RiChY'),
1343 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1346 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1347 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1348 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1350 (SELECT player FROM players WHERE nick='Snute'),
1353 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1354 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1356 (SELECT player FROM players WHERE nick='Snute'),
1357 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1360 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1361 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1364 (SELECT player FROM players WHERE nick='Oliyzia'),
1367 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1368 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1370 (SELECT player FROM players WHERE nick='Oliyzia'),
1371 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1374 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1375 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1378 (SELECT player FROM players WHERE nick='Haggar'),
1381 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1382 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1384 (SELECT player FROM players WHERE nick='Haggar'),
1385 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1388 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1393 INSERT INTO groups (tournament, round, parallel) VALUES (
1394 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1396 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1399 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
1401 UPDATE rounds SET randomsongs=1 WHERE
1402 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1404 UPDATE rounds SET chosensongs=1 WHERE
1405 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1407 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1408 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1409 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1411 (SELECT player FROM players WHERE nick='Haggar'),
1414 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1415 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1417 (SELECT player FROM players WHERE nick='Haggar'),
1418 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1421 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1422 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1423 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1425 (SELECT player FROM players WHERE nick='Hugo'),
1428 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1429 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1431 (SELECT player FROM players WHERE nick='Hugo'),
1432 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1435 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1436 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1437 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1439 (SELECT player FROM players WHERE nick='RiChY'),
1442 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1443 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1445 (SELECT player FROM players WHERE nick='RiChY'),
1446 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1449 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1450 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1451 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1453 (SELECT player FROM players WHERE nick='OJK'),
1456 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1457 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1459 (SELECT player FROM players WHERE nick='OJK'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1463 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1467 (SELECT player FROM players WHERE nick='Oliyzia'),
1470 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1471 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1473 (SELECT player FROM players WHERE nick='Oliyzia'),
1474 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1481 (SELECT player FROM players WHERE nick='Snute'),
1484 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1485 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1487 (SELECT player FROM players WHERE nick='Snute'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1491 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1492 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1493 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1495 (SELECT player FROM players WHERE nick='DufF'),
1498 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1499 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1501 (SELECT player FROM players WHERE nick='DufF'),
1502 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1505 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1510 INSERT INTO groups (tournament, round, parallel) VALUES (
1511 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1513 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1516 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
1518 UPDATE rounds SET randomsongs=1 WHERE
1519 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1521 UPDATE rounds SET chosensongs=1 WHERE
1522 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1524 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1525 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1526 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1528 (SELECT player FROM players WHERE nick='Hugo'),
1531 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1532 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1534 (SELECT player FROM players WHERE nick='Hugo'),
1535 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1538 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1539 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1542 (SELECT player FROM players WHERE nick='RiChY'),
1545 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1546 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1548 (SELECT player FROM players WHERE nick='RiChY'),
1549 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1552 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1553 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1554 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1556 (SELECT player FROM players WHERE nick='DufF'),
1559 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1560 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1562 (SELECT player FROM players WHERE nick='DufF'),
1563 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1566 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1570 (SELECT player FROM players WHERE nick='Oliyzia'),
1573 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1574 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1576 (SELECT player FROM players WHERE nick='Oliyzia'),
1577 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1580 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1581 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1584 (SELECT player FROM players WHERE nick='Snute'),
1587 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1588 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1590 (SELECT player FROM players WHERE nick='Snute'),
1591 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1594 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1596 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1599 INSERT INTO groups (tournament, round, parallel) VALUES (
1600 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1602 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1605 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
1607 UPDATE rounds SET randomsongs=1 WHERE
1608 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1610 UPDATE rounds SET chosensongs=1 WHERE
1611 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1613 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1614 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1615 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1617 (SELECT player FROM players WHERE nick='Hugo'),
1620 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1621 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1623 (SELECT player FROM players WHERE nick='Hugo'),
1624 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1627 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1628 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1629 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1631 (SELECT player FROM players WHERE nick='Oliyzia'),
1634 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1635 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1637 (SELECT player FROM players WHERE nick='Oliyzia'),
1638 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1641 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1642 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1643 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1645 (SELECT player FROM players WHERE nick='Snute'),
1648 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1649 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1651 (SELECT player FROM players WHERE nick='Snute'),
1652 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1655 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1656 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1657 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1659 (SELECT player FROM players WHERE nick='DufF'),
1662 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1663 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1665 (SELECT player FROM players WHERE nick='DufF'),
1666 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1669 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1671 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1674 INSERT INTO groups (tournament, round, parallel) VALUES (
1675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1677 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1678 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1680 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1682 UPDATE rounds SET randomsongs=1 WHERE
1683 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1685 UPDATE rounds SET chosensongs=1 WHERE
1686 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1688 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1689 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1690 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1692 (SELECT player FROM players WHERE nick='Hugo'),
1695 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1698 (SELECT player FROM players WHERE nick='Hugo'),
1699 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1702 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1703 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1704 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1706 (SELECT player FROM players WHERE nick='DufF'),
1709 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1710 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1712 (SELECT player FROM players WHERE nick='DufF'),
1713 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1716 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1717 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1718 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1720 (SELECT player FROM players WHERE nick='Snute'),
1723 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1724 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1726 (SELECT player FROM players WHERE nick='Snute'),
1727 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1730 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1732 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1735 INSERT INTO groups (tournament, round, parallel) VALUES (
1736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1738 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1741 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
1743 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1744 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1746 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
1748 UPDATE rounds SET randomsongs=2 WHERE
1749 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1751 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1752 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1753 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1755 (SELECT player FROM players WHERE nick='DufF'),
1758 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1761 (SELECT player FROM players WHERE nick='DufF'),
1762 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1765 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1766 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1768 (SELECT player FROM players WHERE nick='DufF'),
1769 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1772 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1773 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1774 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1776 (SELECT player FROM players WHERE nick='Snute'),
1779 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1780 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1782 (SELECT player FROM players WHERE nick='Snute'),
1783 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1786 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1787 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1789 (SELECT player FROM players WHERE nick='Snute'),
1790 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),