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 4'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
28 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
36 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 );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
40 (SELECT player FROM players WHERE nick='Pål Andre'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
46 (SELECT player FROM players WHERE nick='Pål Andre'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
53 (SELECT player FROM players WHERE nick='Pål Andre'),
54 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
57 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' 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 4'),
61 (SELECT player FROM players WHERE nick='Tassen'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
67 (SELECT player FROM players WHERE nick='Tassen'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
74 (SELECT player FROM players WHERE nick='Tassen'),
75 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' 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 4'),
82 (SELECT player FROM players WHERE nick='Haggar'),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
88 (SELECT player FROM players WHERE nick='Haggar'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
92 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
95 (SELECT player FROM players WHERE nick='Haggar'),
96 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' 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 4'),
103 (SELECT player FROM players WHERE nick='Draconia'),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
109 (SELECT player FROM players WHERE nick='Draconia'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
116 (SELECT player FROM players WHERE nick='Draconia'),
117 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
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 4'),
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 4'),
130 (SELECT player FROM players WHERE nick='Snute'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
137 (SELECT player FROM players WHERE nick='Snute'),
138 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
141 INSERT INTO groups (tournament, round, parallel) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
144 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
145 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
147 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
149 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
154 UPDATE rounds SET randomsongs=2 WHERE
155 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
157 UPDATE rounds SET chosensongs=1 WHERE
158 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' 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 4'),
164 (SELECT player FROM players WHERE nick='Mync'),
167 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
170 (SELECT player FROM players WHERE nick='Mync'),
171 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
177 (SELECT player FROM players WHERE nick='Mync'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' 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 4'),
185 (SELECT player FROM players WHERE nick='Glukko'),
188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
191 (SELECT player FROM players WHERE nick='Glukko'),
192 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
195 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
198 (SELECT player FROM players WHERE nick='Glukko'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' 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 4'),
206 (SELECT player FROM players WHERE nick='Mulefisk'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
212 (SELECT player FROM players WHERE nick='Mulefisk'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
219 (SELECT player FROM players WHERE nick='Mulefisk'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' 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 4'),
227 (SELECT player FROM players WHERE nick='Ylini'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
233 (SELECT player FROM players WHERE nick='Ylini'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
240 (SELECT player FROM players WHERE nick='Ylini'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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 4'),
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 4'),
254 (SELECT player FROM players WHERE nick='DufF'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
261 (SELECT player FROM players WHERE nick='DufF'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
265 INSERT INTO groups (tournament, round, parallel) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
268 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
269 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
271 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
278 UPDATE rounds SET randomsongs=2 WHERE
279 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
281 UPDATE rounds SET chosensongs=1 WHERE
282 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
284 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' 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 4'),
288 (SELECT player FROM players WHERE nick='Pingo'),
291 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
294 (SELECT player FROM players WHERE nick='Pingo'),
295 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
298 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
301 (SELECT player FROM players WHERE nick='Pingo'),
302 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
305 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' 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 4'),
309 (SELECT player FROM players WHERE nick='Jim Andre'),
312 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
315 (SELECT player FROM players WHERE nick='Jim Andre'),
316 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
319 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
322 (SELECT player FROM players WHERE nick='Jim Andre'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' 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 4'),
330 (SELECT player FROM players WHERE nick='Dabi'),
333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
336 (SELECT player FROM players WHERE nick='Dabi'),
337 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
343 (SELECT player FROM players WHERE nick='Dabi'),
344 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
347 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 4'),
351 (SELECT player FROM players WHERE nick='Olemann'),
354 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
357 (SELECT player FROM players WHERE nick='Olemann'),
358 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
364 (SELECT player FROM players WHERE nick='Olemann'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
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 4'),
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 4'),
378 (SELECT player FROM players WHERE nick='OJK'),
379 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
385 (SELECT player FROM players WHERE nick='OJK'),
386 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
389 INSERT INTO groups (tournament, round, parallel) VALUES (
390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
392 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
393 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
395 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
397 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
398 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
402 UPDATE rounds SET randomsongs=2 WHERE
403 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
405 UPDATE rounds SET chosensongs=1 WHERE
406 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
408 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick WHERE 'Mario' 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 4'),
412 (SELECT player FROM players WHERE nick='Mario'),
415 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
416 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
418 (SELECT player FROM players WHERE nick='Mario'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
422 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
425 (SELECT player FROM players WHERE nick='Mario'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
429 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' 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 4'),
433 (SELECT player FROM players WHERE nick='Gogo'),
436 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
439 (SELECT player FROM players WHERE nick='Gogo'),
440 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
443 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
444 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
446 (SELECT player FROM players WHERE nick='Gogo'),
447 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
450 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' 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 4'),
454 (SELECT player FROM players WHERE nick='Ted Kristian'),
457 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
458 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
460 (SELECT player FROM players WHERE nick='Ted Kristian'),
461 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
464 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
467 (SELECT player FROM players WHERE nick='Ted Kristian'),
468 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
471 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' 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 4'),
475 (SELECT player FROM players WHERE nick='Duckling'),
478 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
481 (SELECT player FROM players WHERE nick='Duckling'),
482 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
485 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
488 (SELECT player FROM players WHERE nick='Duckling'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
492 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' 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 4'),
496 (SELECT player FROM players WHERE nick='Smiph'),
499 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
502 (SELECT player FROM players WHERE nick='Smiph'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
506 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
509 (SELECT player FROM players WHERE nick='Smiph'),
510 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
514 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
517 (SELECT player FROM players WHERE nick='RiChY'),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
523 (SELECT player FROM players WHERE nick='RiChY'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
530 (SELECT player FROM players WHERE nick='RiChY'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
534 INSERT INTO groups (tournament, round, parallel) VALUES (
535 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
537 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
538 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
540 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
542 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
547 UPDATE rounds SET randomsongs=2 WHERE
548 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
550 UPDATE rounds SET chosensongs=1 WHERE
551 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
553 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' 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 4'),
557 (SELECT player FROM players WHERE nick='Alexxz'),
560 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
563 (SELECT player FROM players WHERE nick='Alexxz'),
564 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
567 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
570 (SELECT player FROM players WHERE nick='Alexxz'),
571 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
574 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick WHERE 'Zeek' 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 4'),
578 (SELECT player FROM players WHERE nick='Zeek'),
581 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
584 (SELECT player FROM players WHERE nick='Zeek'),
585 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
588 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
591 (SELECT player FROM players WHERE nick='Zeek'),
592 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
595 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' 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 4'),
599 (SELECT player FROM players WHERE nick='Bonzo'),
602 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
605 (SELECT player FROM players WHERE nick='Bonzo'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
609 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
612 (SELECT player FROM players WHERE nick='Bonzo'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
616 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' 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 4'),
620 (SELECT player FROM players WHERE nick='Tom'),
623 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
626 (SELECT player FROM players WHERE nick='Tom'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
630 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
633 (SELECT player FROM players WHERE nick='Tom'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
637 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' 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 4'),
641 (SELECT player FROM players WHERE nick='Snofox'),
644 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
647 (SELECT player FROM players WHERE nick='Snofox'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
651 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
652 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
654 (SELECT player FROM players WHERE nick='Snofox'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
658 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
659 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
660 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
662 (SELECT player FROM players WHERE nick='T|na'),
665 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
668 (SELECT player FROM players WHERE nick='T|na'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
672 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
673 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
675 (SELECT player FROM players WHERE nick='T|na'),
676 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
679 INSERT INTO groups (tournament, round, parallel) VALUES (
680 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
682 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
685 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
687 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
688 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
690 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
692 UPDATE rounds SET randomsongs=2 WHERE
693 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
695 UPDATE rounds SET chosensongs=1 WHERE
696 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
698 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' 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 4'),
702 (SELECT player FROM players WHERE nick='Ozon'),
705 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
708 (SELECT player FROM players WHERE nick='Ozon'),
709 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
712 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
715 (SELECT player FROM players WHERE nick='Ozon'),
716 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
719 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' 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 4'),
723 (SELECT player FROM players WHERE nick='Hyper'),
726 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
729 (SELECT player FROM players WHERE nick='Hyper'),
730 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
733 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
736 (SELECT player FROM players WHERE nick='Hyper'),
737 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
740 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' 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 4'),
744 (SELECT player FROM players WHERE nick='Nameless'),
747 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
750 (SELECT player FROM players WHERE nick='Nameless'),
751 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
754 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
757 (SELECT player FROM players WHERE nick='Nameless'),
758 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
761 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' 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 4'),
765 (SELECT player FROM players WHERE nick='Daniil'),
768 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
771 (SELECT player FROM players WHERE nick='Daniil'),
772 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
775 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
778 (SELECT player FROM players WHERE nick='Daniil'),
779 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
782 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' 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 4'),
786 (SELECT player FROM players WHERE nick='Oliyzia'),
789 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
792 (SELECT player FROM players WHERE nick='Oliyzia'),
793 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
796 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
799 (SELECT player FROM players WHERE nick='Oliyzia'),
800 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
803 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
804 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
805 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
807 (SELECT player FROM players WHERE nick='Stream'),
810 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
811 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
813 (SELECT player FROM players WHERE nick='Stream'),
814 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
817 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
820 (SELECT player FROM players WHERE nick='Stream'),
821 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
824 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
829 INSERT INTO groups (tournament, round, parallel) VALUES (
830 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
832 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
833 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
835 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
837 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
838 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
840 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
842 UPDATE rounds SET randomsongs=2 WHERE
843 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
845 UPDATE rounds SET chosensongs=1 WHERE
846 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
848 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 4'),
852 (SELECT player FROM players WHERE nick='Olemann'),
855 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
856 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
858 (SELECT player FROM players WHERE nick='Olemann'),
859 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
862 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
863 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
865 (SELECT player FROM players WHERE nick='Olemann'),
866 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
869 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' 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 4'),
873 (SELECT player FROM players WHERE nick='T|na'),
876 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
879 (SELECT player FROM players WHERE nick='T|na'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
883 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
886 (SELECT player FROM players WHERE nick='T|na'),
887 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
890 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' 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 4'),
894 (SELECT player FROM players WHERE nick='Oliyzia'),
897 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
900 (SELECT player FROM players WHERE nick='Oliyzia'),
901 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
904 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
907 (SELECT player FROM players WHERE nick='Oliyzia'),
908 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
911 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' 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 4'),
915 (SELECT player FROM players WHERE nick='Snofox'),
918 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
921 (SELECT player FROM players WHERE nick='Snofox'),
922 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
925 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
928 (SELECT player FROM players WHERE nick='Snofox'),
929 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
932 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' 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 4'),
936 (SELECT player FROM players WHERE nick='Tom'),
939 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
940 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
942 (SELECT player FROM players WHERE nick='Tom'),
943 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
946 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
949 (SELECT player FROM players WHERE nick='Tom'),
950 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
953 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
954 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
955 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
957 (SELECT player FROM players WHERE nick='Snute'),
960 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
961 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
963 (SELECT player FROM players WHERE nick='Snute'),
964 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
967 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
968 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
970 (SELECT player FROM players WHERE nick='Snute'),
971 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
974 INSERT INTO groups (tournament, round, parallel) VALUES (
975 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
977 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
978 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
980 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
982 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
983 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
985 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
987 UPDATE rounds SET randomsongs=2 WHERE
988 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
990 UPDATE rounds SET chosensongs=1 WHERE
991 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
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 4'),
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 4'),
1003 (SELECT player FROM players WHERE nick='Duckling'),
1004 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1007 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1008 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1010 (SELECT player FROM players WHERE nick='Duckling'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1014 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' 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 4'),
1018 (SELECT player FROM players WHERE nick='Daniil'),
1021 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1022 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1024 (SELECT player FROM players WHERE nick='Daniil'),
1025 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1028 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1031 (SELECT player FROM players WHERE nick='Daniil'),
1032 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1035 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' 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 4'),
1039 (SELECT player FROM players WHERE nick='Mulefisk'),
1042 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1045 (SELECT player FROM players WHERE nick='Mulefisk'),
1046 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1049 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1052 (SELECT player FROM players WHERE nick='Mulefisk'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' 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 4'),
1060 (SELECT player FROM players WHERE nick='Haggar'),
1063 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1064 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1066 (SELECT player FROM players WHERE nick='Haggar'),
1067 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1070 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1071 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1073 (SELECT player FROM players WHERE nick='Haggar'),
1074 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1077 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' 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 4'),
1081 (SELECT player FROM players WHERE nick='Nameless'),
1084 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1087 (SELECT player FROM players WHERE nick='Nameless'),
1088 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1091 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1092 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1094 (SELECT player FROM players WHERE nick='Nameless'),
1095 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1098 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1102 (SELECT player FROM players WHERE nick='OJK'),
1105 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1108 (SELECT player FROM players WHERE nick='OJK'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1112 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1115 (SELECT player FROM players WHERE nick='OJK'),
1116 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1119 INSERT INTO groups (tournament, round, parallel) VALUES (
1120 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1122 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1123 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1125 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1127 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1132 UPDATE rounds SET randomsongs=2 WHERE
1133 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1135 UPDATE rounds SET chosensongs=1 WHERE
1136 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' 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 4'),
1142 (SELECT player FROM players WHERE nick='Tassen'),
1145 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1146 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1148 (SELECT player FROM players WHERE nick='Tassen'),
1149 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1152 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1155 (SELECT player FROM players WHERE nick='Tassen'),
1156 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1159 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' 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 4'),
1163 (SELECT player FROM players WHERE nick='Ylini'),
1166 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1167 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1169 (SELECT player FROM players WHERE nick='Ylini'),
1170 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1173 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1174 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1176 (SELECT player FROM players WHERE nick='Ylini'),
1177 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' 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 4'),
1184 (SELECT player FROM players WHERE nick='Pingo'),
1187 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1188 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1190 (SELECT player FROM players WHERE nick='Pingo'),
1191 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1194 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1195 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1197 (SELECT player FROM players WHERE nick='Pingo'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1201 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' 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 4'),
1205 (SELECT player FROM players WHERE nick='Gogo'),
1208 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1211 (SELECT player FROM players WHERE nick='Gogo'),
1212 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1215 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1216 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1218 (SELECT player FROM players WHERE nick='Gogo'),
1219 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' 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 4'),
1226 (SELECT player FROM players WHERE nick='RiChY'),
1229 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1230 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1232 (SELECT player FROM players WHERE nick='RiChY'),
1233 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1236 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1237 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1239 (SELECT player FROM players WHERE nick='RiChY'),
1240 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1243 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1247 (SELECT player FROM players WHERE nick='DufF'),
1250 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1251 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1253 (SELECT player FROM players WHERE nick='DufF'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1257 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1258 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1260 (SELECT player FROM players WHERE nick='DufF'),
1261 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1264 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1269 INSERT INTO groups (tournament, round, parallel) VALUES (
1270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1272 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1277 UPDATE rounds SET randomsongs=1 WHERE
1278 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1280 UPDATE rounds SET chosensongs=1 WHERE
1281 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1283 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1284 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1285 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1287 (SELECT player FROM players WHERE nick='OJK'),
1290 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1291 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1293 (SELECT player FROM players WHERE nick='OJK'),
1294 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1297 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1298 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1299 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1301 (SELECT player FROM players WHERE nick='Pingo'),
1304 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1307 (SELECT player FROM players WHERE nick='Pingo'),
1308 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1311 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1315 (SELECT player FROM players WHERE nick='Tom'),
1318 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1319 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1321 (SELECT player FROM players WHERE nick='Tom'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1325 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1326 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1327 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1329 (SELECT player FROM players WHERE nick='Nameless'),
1332 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1333 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1335 (SELECT player FROM players WHERE nick='Nameless'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1339 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1340 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1343 (SELECT player FROM players WHERE nick='RiChY'),
1346 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1347 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1349 (SELECT player FROM players WHERE nick='RiChY'),
1350 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1353 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1354 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1357 (SELECT player FROM players WHERE nick='Snofox'),
1360 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1361 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1363 (SELECT player FROM players WHERE nick='Snofox'),
1364 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1367 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1368 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1371 (SELECT player FROM players WHERE nick='Haggar'),
1374 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1375 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1377 (SELECT player FROM players WHERE nick='Haggar'),
1378 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1381 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1382 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1385 (SELECT player FROM players WHERE nick='Snute'),
1388 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1389 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1391 (SELECT player FROM players WHERE nick='Snute'),
1392 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1395 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1399 (SELECT player FROM players WHERE nick='DufF'),
1402 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1403 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1405 (SELECT player FROM players WHERE nick='DufF'),
1406 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1409 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1411 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1414 INSERT INTO groups (tournament, round, parallel) VALUES (
1415 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1417 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1420 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
1422 UPDATE rounds SET randomsongs=1 WHERE
1423 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1425 UPDATE rounds SET chosensongs=1 WHERE
1426 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1428 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1429 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1430 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1432 (SELECT player FROM players WHERE nick='Haggar'),
1435 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1438 (SELECT player FROM players WHERE nick='Haggar'),
1439 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1442 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1443 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1444 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1446 (SELECT player FROM players WHERE nick='Snofox'),
1449 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1450 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1452 (SELECT player FROM players WHERE nick='Snofox'),
1453 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1456 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1457 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1458 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1460 (SELECT player FROM players WHERE nick='RiChY'),
1463 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1464 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1466 (SELECT player FROM players WHERE nick='RiChY'),
1467 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1470 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1471 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1472 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1474 (SELECT player FROM players WHERE nick='Nameless'),
1477 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1478 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1480 (SELECT player FROM players WHERE nick='Nameless'),
1481 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1484 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1485 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1488 (SELECT player FROM players WHERE nick='Snute'),
1491 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1494 (SELECT player FROM players WHERE nick='Snute'),
1495 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1498 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1499 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1502 (SELECT player FROM players WHERE nick='DufF'),
1505 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1506 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1508 (SELECT player FROM players WHERE nick='DufF'),
1509 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1512 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1513 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1516 (SELECT player FROM players WHERE nick='OJK'),
1519 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1520 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1522 (SELECT player FROM players WHERE nick='OJK'),
1523 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1526 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1531 INSERT INTO groups (tournament, round, parallel) VALUES (
1532 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1534 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1535 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1537 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1539 UPDATE rounds SET randomsongs=1 WHERE
1540 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1542 UPDATE rounds SET chosensongs=1 WHERE
1543 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1545 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1546 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1547 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1549 (SELECT player FROM players WHERE nick='Nameless'),
1552 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1553 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1555 (SELECT player FROM players WHERE nick='Nameless'),
1556 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1559 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1560 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1563 (SELECT player FROM players WHERE nick='RiChY'),
1566 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1567 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1569 (SELECT player FROM players WHERE nick='RiChY'),
1570 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1573 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1575 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1577 (SELECT player FROM players WHERE nick='Haggar'),
1580 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1581 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1583 (SELECT player FROM players WHERE nick='Haggar'),
1584 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1587 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1588 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1591 (SELECT player FROM players WHERE nick='Snute'),
1594 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1595 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1597 (SELECT player FROM players WHERE nick='Snute'),
1598 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1601 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1605 (SELECT player FROM players WHERE nick='DufF'),
1608 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1609 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1611 (SELECT player FROM players WHERE nick='DufF'),
1612 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1615 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1617 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1620 INSERT INTO groups (tournament, round, parallel) VALUES (
1621 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1623 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1626 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
1628 UPDATE rounds SET randomsongs=1 WHERE
1629 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1631 UPDATE rounds SET chosensongs=1 WHERE
1632 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1634 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1635 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1636 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1638 (SELECT player FROM players WHERE nick='RiChY'),
1641 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1642 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1644 (SELECT player FROM players WHERE nick='RiChY'),
1645 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1648 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1649 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1650 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1652 (SELECT player FROM players WHERE nick='Haggar'),
1655 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1656 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1658 (SELECT player FROM players WHERE nick='Haggar'),
1659 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1662 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1663 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1666 (SELECT player FROM players WHERE nick='DufF'),
1669 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1670 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1672 (SELECT player FROM players WHERE nick='DufF'),
1673 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1676 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1677 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1678 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1680 (SELECT player FROM players WHERE nick='Snute'),
1683 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1684 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1686 (SELECT player FROM players WHERE nick='Snute'),
1687 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1690 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1695 INSERT INTO groups (tournament, round, parallel) VALUES (
1696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1698 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1699 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1701 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1703 UPDATE rounds SET randomsongs=1 WHERE
1704 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1706 UPDATE rounds SET chosensongs=1 WHERE
1707 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1709 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1710 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1711 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1713 (SELECT player FROM players WHERE nick='RiChY'),
1716 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1719 (SELECT player FROM players WHERE nick='RiChY'),
1720 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1723 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1724 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1725 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1727 (SELECT player FROM players WHERE nick='DufF'),
1730 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1731 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1733 (SELECT player FROM players WHERE nick='DufF'),
1734 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1737 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1738 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1741 (SELECT player FROM players WHERE nick='Snute'),
1744 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1747 (SELECT player FROM players WHERE nick='Snute'),
1748 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1751 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1753 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1756 INSERT INTO groups (tournament, round, parallel) VALUES (
1757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1759 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1760 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1762 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1764 UPDATE rounds SET randomsongs=1 WHERE
1765 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1767 UPDATE rounds SET chosensongs=1 WHERE
1768 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1770 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1771 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1772 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1774 (SELECT player FROM players WHERE nick='Snute'),
1777 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1780 (SELECT player FROM players WHERE nick='Snute'),
1781 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1786 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1788 (SELECT player FROM players WHERE nick='DufF'),
1791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1794 (SELECT player FROM players WHERE nick='DufF'),
1795 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),