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'),
7 'Tønsberg - Sjøsenteret bowling',
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 7'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
28 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Crienexzy' AS nick WHERE 'Crienexzy' 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 7'),
40 (SELECT player FROM players WHERE nick='Crienexzy'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
46 (SELECT player FROM players WHERE nick='Crienexzy'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
53 (SELECT player FROM players WHERE nick='Crienexzy'),
54 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
57 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tove' AS nick WHERE 'Tove' 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 7'),
61 (SELECT player FROM players WHERE nick='Tove'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
67 (SELECT player FROM players WHERE nick='Tove'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
74 (SELECT player FROM players WHERE nick='Tove'),
75 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' 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 7'),
82 (SELECT player FROM players WHERE nick='JonAnders'),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
88 (SELECT player FROM players WHERE nick='JonAnders'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
92 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
95 (SELECT player FROM players WHERE nick='JonAnders'),
96 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' 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 7'),
103 (SELECT player FROM players WHERE nick='Andeplane'),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
109 (SELECT player FROM players WHERE nick='Andeplane'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
116 (SELECT player FROM players WHERE nick='Andeplane'),
117 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' 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 7'),
124 (SELECT player FROM players WHERE nick='Matsi'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
130 (SELECT player FROM players WHERE nick='Matsi'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
137 (SELECT player FROM players WHERE nick='Matsi'),
138 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
141 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
142 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
145 (SELECT player FROM players WHERE nick='Snofox'),
148 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
149 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
151 (SELECT player FROM players WHERE nick='Snofox'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
158 (SELECT player FROM players WHERE nick='Snofox'),
159 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
163 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
164 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
166 (SELECT player FROM players WHERE nick='T|na'),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
172 (SELECT player FROM players WHERE nick='T|na'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
176 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
177 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
179 (SELECT player FROM players WHERE nick='T|na'),
180 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
183 INSERT INTO groups (tournament, round, parallel) VALUES (
184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
186 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
187 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
189 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
191 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
192 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
194 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
196 UPDATE rounds SET randomsongs=2 WHERE
197 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
199 UPDATE rounds SET chosensongs=1 WHERE
200 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'uSimen' AS nick WHERE 'uSimen' 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 7'),
206 (SELECT player FROM players WHERE nick='uSimen'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
212 (SELECT player FROM players WHERE nick='uSimen'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
219 (SELECT player FROM players WHERE nick='uSimen'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick WHERE 'Pfxp' 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 7'),
227 (SELECT player FROM players WHERE nick='Pfxp'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
233 (SELECT player FROM players WHERE nick='Pfxp'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
240 (SELECT player FROM players WHERE nick='Pfxp'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' 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 7'),
248 (SELECT player FROM players WHERE nick='Glock'),
251 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
254 (SELECT player FROM players WHERE nick='Glock'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
261 (SELECT player FROM players WHERE nick='Glock'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
265 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
266 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
269 (SELECT player FROM players WHERE nick='Eruanna'),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
275 (SELECT player FROM players WHERE nick='Eruanna'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
279 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
282 (SELECT player FROM players WHERE nick='Eruanna'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
286 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
287 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
290 (SELECT player FROM players WHERE nick='v|per'),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
296 (SELECT player FROM players WHERE nick='v|per'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
303 (SELECT player FROM players WHERE nick='v|per'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
311 (SELECT player FROM players WHERE nick='Daniil'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
317 (SELECT player FROM players WHERE nick='Daniil'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
324 (SELECT player FROM players WHERE nick='Daniil'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
328 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
329 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
330 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
332 (SELECT player FROM players WHERE nick='Nameless'),
335 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
338 (SELECT player FROM players WHERE nick='Nameless'),
339 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
342 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
345 (SELECT player FROM players WHERE nick='Nameless'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
349 INSERT INTO groups (tournament, round, parallel) VALUES (
350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
352 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
353 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
355 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
357 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
360 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
362 UPDATE rounds SET randomsongs=2 WHERE
363 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
365 UPDATE rounds SET chosensongs=1 WHERE
366 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
368 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick WHERE 'Benny' 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 7'),
372 (SELECT player FROM players WHERE nick='Benny'),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
378 (SELECT player FROM players WHERE nick='Benny'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
385 (SELECT player FROM players WHERE nick='Benny'),
386 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
389 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Volstad' AS nick WHERE 'Volstad' NOT IN ( SELECT nick FROM players );
390 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
393 (SELECT player FROM players WHERE nick='Volstad'),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
399 (SELECT player FROM players WHERE nick='Volstad'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
406 (SELECT player FROM players WHERE nick='Volstad'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
411 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
414 (SELECT player FROM players WHERE nick='Annkakri'),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
420 (SELECT player FROM players WHERE nick='Annkakri'),
421 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
427 (SELECT player FROM players WHERE nick='Annkakri'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
431 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
432 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
433 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
435 (SELECT player FROM players WHERE nick='Athena'),
438 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
441 (SELECT player FROM players WHERE nick='Athena'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
448 (SELECT player FROM players WHERE nick='Athena'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
452 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
453 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
454 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
456 (SELECT player FROM players WHERE nick='Felz'),
459 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
462 (SELECT player FROM players WHERE nick='Felz'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
466 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
467 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
469 (SELECT player FROM players WHERE nick='Felz'),
470 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
473 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
474 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
475 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
477 (SELECT player FROM players WHERE nick='Ylini'),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
483 (SELECT player FROM players WHERE nick='Ylini'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
490 (SELECT player FROM players WHERE nick='Ylini'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
498 (SELECT player FROM players WHERE nick='Oliyzia'),
501 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
504 (SELECT player FROM players WHERE nick='Oliyzia'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
508 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
511 (SELECT player FROM players WHERE nick='Oliyzia'),
512 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
515 INSERT INTO groups (tournament, round, parallel) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
518 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
519 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
521 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
523 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
526 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
528 UPDATE rounds SET randomsongs=2 WHERE
529 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
531 UPDATE rounds SET chosensongs=1 WHERE
532 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Voffen' AS nick WHERE 'Voffen' NOT IN ( SELECT nick FROM players );
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
538 (SELECT player FROM players WHERE nick='Voffen'),
541 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
544 (SELECT player FROM players WHERE nick='Voffen'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
551 (SELECT player FROM players WHERE nick='Voffen'),
552 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
555 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
556 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
557 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
559 (SELECT player FROM players WHERE nick='Zackie'),
562 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
565 (SELECT player FROM players WHERE nick='Zackie'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
569 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
572 (SELECT player FROM players WHERE nick='Zackie'),
573 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
576 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
577 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
580 (SELECT player FROM players WHERE nick='Zeila'),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
586 (SELECT player FROM players WHERE nick='Zeila'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
590 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
593 (SELECT player FROM players WHERE nick='Zeila'),
594 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
599 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
601 (SELECT player FROM players WHERE nick='Alexxz'),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
607 (SELECT player FROM players WHERE nick='Alexxz'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
614 (SELECT player FROM players WHERE nick='Alexxz'),
615 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
618 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
619 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
620 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
622 (SELECT player FROM players WHERE nick='Olemann'),
625 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
626 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
628 (SELECT player FROM players WHERE nick='Olemann'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
635 (SELECT player FROM players WHERE nick='Olemann'),
636 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
639 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
640 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
641 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
643 (SELECT player FROM players WHERE nick='RiChY'),
646 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
649 (SELECT player FROM players WHERE nick='RiChY'),
650 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
653 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
654 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
656 (SELECT player FROM players WHERE nick='RiChY'),
657 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
660 INSERT INTO groups (tournament, round, parallel) VALUES (
661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
663 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
666 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
668 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
669 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
673 UPDATE rounds SET randomsongs=2 WHERE
674 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
676 UPDATE rounds SET chosensongs=1 WHERE
677 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
679 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'SLC' AS nick WHERE 'SLC' NOT IN ( SELECT nick FROM players );
680 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
681 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
683 (SELECT player FROM players WHERE nick='SLC'),
686 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
689 (SELECT player FROM players WHERE nick='SLC'),
690 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
693 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
694 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
696 (SELECT player FROM players WHERE nick='SLC'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
700 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
701 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
702 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
704 (SELECT player FROM players WHERE nick='Matti'),
707 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
710 (SELECT player FROM players WHERE nick='Matti'),
711 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
714 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
717 (SELECT player FROM players WHERE nick='Matti'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
723 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
725 (SELECT player FROM players WHERE nick='Hyper'),
728 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
731 (SELECT player FROM players WHERE nick='Hyper'),
732 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
738 (SELECT player FROM players WHERE nick='Hyper'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
742 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
743 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
744 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
746 (SELECT player FROM players WHERE nick='Mync'),
749 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
752 (SELECT player FROM players WHERE nick='Mync'),
753 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
756 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
759 (SELECT player FROM players WHERE nick='Mync'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
763 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
765 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
767 (SELECT player FROM players WHERE nick='Duckling'),
770 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
773 (SELECT player FROM players WHERE nick='Duckling'),
774 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
777 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
780 (SELECT player FROM players WHERE nick='Duckling'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
788 (SELECT player FROM players WHERE nick='Haggar'),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
794 (SELECT player FROM players WHERE nick='Haggar'),
795 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
801 (SELECT player FROM players WHERE nick='Haggar'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
805 INSERT INTO groups (tournament, round, parallel) VALUES (
806 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
808 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
811 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
813 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
814 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
816 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
818 UPDATE rounds SET randomsongs=2 WHERE
819 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
821 UPDATE rounds SET chosensongs=1 WHERE
822 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
824 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dritago' AS nick WHERE 'Dritago' NOT IN ( SELECT nick FROM players );
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
828 (SELECT player FROM players WHERE nick='Dritago'),
831 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
834 (SELECT player FROM players WHERE nick='Dritago'),
835 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
838 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
841 (SELECT player FROM players WHERE nick='Dritago'),
842 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
845 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
846 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
847 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
849 (SELECT player FROM players WHERE nick='Pyro'),
852 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
855 (SELECT player FROM players WHERE nick='Pyro'),
856 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
859 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
860 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
862 (SELECT player FROM players WHERE nick='Pyro'),
863 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
866 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
867 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
868 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
870 (SELECT player FROM players WHERE nick='Marilla'),
873 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
874 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
876 (SELECT player FROM players WHERE nick='Marilla'),
877 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
880 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
881 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
883 (SELECT player FROM players WHERE nick='Marilla'),
884 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
889 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
891 (SELECT player FROM players WHERE nick='Pingo'),
894 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
897 (SELECT player FROM players WHERE nick='Pingo'),
898 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
901 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
902 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
904 (SELECT player FROM players WHERE nick='Pingo'),
905 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
908 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
909 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
910 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
912 (SELECT player FROM players WHERE nick='Bonzo'),
915 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
916 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
918 (SELECT player FROM players WHERE nick='Bonzo'),
919 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
925 (SELECT player FROM players WHERE nick='Bonzo'),
926 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
929 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
930 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
931 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
933 (SELECT player FROM players WHERE nick='OJK'),
936 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
939 (SELECT player FROM players WHERE nick='OJK'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
943 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
946 (SELECT player FROM players WHERE nick='OJK'),
947 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
950 INSERT INTO groups (tournament, round, parallel) VALUES (
951 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
953 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
956 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
958 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
959 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
963 UPDATE rounds SET randomsongs=2 WHERE
964 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
966 UPDATE rounds SET chosensongs=1 WHERE
967 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
969 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
970 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
971 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
973 (SELECT player FROM players WHERE nick='Indy'),
976 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
977 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
979 (SELECT player FROM players WHERE nick='Indy'),
980 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
983 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
984 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
986 (SELECT player FROM players WHERE nick='Indy'),
987 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
990 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
991 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
992 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
994 (SELECT player FROM players WHERE nick='Electron'),
997 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
998 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1000 (SELECT player FROM players WHERE nick='Electron'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1004 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1005 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1007 (SELECT player FROM players WHERE nick='Electron'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1011 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1015 (SELECT player FROM players WHERE nick='Bush'),
1018 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1021 (SELECT player FROM players WHERE nick='Bush'),
1022 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1025 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1026 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1028 (SELECT player FROM players WHERE nick='Bush'),
1029 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1032 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1033 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1034 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1036 (SELECT player FROM players WHERE nick='Gogo'),
1039 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1040 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1042 (SELECT player FROM players WHERE nick='Gogo'),
1043 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1046 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1047 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1049 (SELECT player FROM players WHERE nick='Gogo'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1053 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1055 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1057 (SELECT player FROM players WHERE nick='Smiph'),
1060 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1061 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1063 (SELECT player FROM players WHERE nick='Smiph'),
1064 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1067 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1068 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1070 (SELECT player FROM players WHERE nick='Smiph'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1074 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1075 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1076 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1078 (SELECT player FROM players WHERE nick='Snute'),
1081 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1082 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1084 (SELECT player FROM players WHERE nick='Snute'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1088 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1091 (SELECT player FROM players WHERE nick='Snute'),
1092 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1095 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1097 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1100 INSERT INTO groups (tournament, round, parallel) VALUES (
1101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1103 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1104 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1106 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
1108 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1109 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1111 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1113 UPDATE rounds SET randomsongs=2 WHERE
1114 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1116 UPDATE rounds SET chosensongs=1 WHERE
1117 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1119 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1123 (SELECT player FROM players WHERE nick='v|per'),
1126 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1129 (SELECT player FROM players WHERE nick='v|per'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1133 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1134 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1136 (SELECT player FROM players WHERE nick='v|per'),
1137 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1140 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1141 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1144 (SELECT player FROM players WHERE nick='Mync'),
1147 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1148 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1150 (SELECT player FROM players WHERE nick='Mync'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1154 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1155 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1157 (SELECT player FROM players WHERE nick='Mync'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1161 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1162 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1165 (SELECT player FROM players WHERE nick='Duckling'),
1168 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1171 (SELECT player FROM players WHERE nick='Duckling'),
1172 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1175 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1178 (SELECT player FROM players WHERE nick='Duckling'),
1179 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1182 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1183 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1186 (SELECT player FROM players WHERE nick='T|na'),
1189 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1190 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1192 (SELECT player FROM players WHERE nick='T|na'),
1193 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1196 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1199 (SELECT player FROM players WHERE nick='T|na'),
1200 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1203 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1204 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1205 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1207 (SELECT player FROM players WHERE nick='Pingo'),
1210 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1211 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1213 (SELECT player FROM players WHERE nick='Pingo'),
1214 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1217 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1218 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1220 (SELECT player FROM players WHERE nick='Pingo'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1224 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1225 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1226 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1228 (SELECT player FROM players WHERE nick='Haggar'),
1231 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1234 (SELECT player FROM players WHERE nick='Haggar'),
1235 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1238 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1241 (SELECT player FROM players WHERE nick='Haggar'),
1242 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1245 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1247 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1249 (SELECT player FROM players WHERE nick='OJK'),
1252 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1255 (SELECT player FROM players WHERE nick='OJK'),
1256 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1259 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1260 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1262 (SELECT player FROM players WHERE nick='OJK'),
1263 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1266 INSERT INTO groups (tournament, round, parallel) VALUES (
1267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1269 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1272 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1274 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1275 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1277 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
1279 UPDATE rounds SET randomsongs=2 WHERE
1280 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1282 UPDATE rounds SET chosensongs=1 WHERE
1283 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1285 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
1286 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1289 (SELECT player FROM players WHERE nick='Alexxz'),
1292 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1293 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1295 (SELECT player FROM players WHERE nick='Alexxz'),
1296 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1299 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1300 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1302 (SELECT player FROM players WHERE nick='Alexxz'),
1303 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1306 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1308 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1310 (SELECT player FROM players WHERE nick='Smiph'),
1313 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1314 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1316 (SELECT player FROM players WHERE nick='Smiph'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1320 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1321 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1323 (SELECT player FROM players WHERE nick='Smiph'),
1324 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1327 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1328 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1331 (SELECT player FROM players WHERE nick='Ylini'),
1334 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1337 (SELECT player FROM players WHERE nick='Ylini'),
1338 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1341 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1344 (SELECT player FROM players WHERE nick='Ylini'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1348 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1352 (SELECT player FROM players WHERE nick='Gogo'),
1355 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1358 (SELECT player FROM players WHERE nick='Gogo'),
1359 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1362 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1363 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1365 (SELECT player FROM players WHERE nick='Gogo'),
1366 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1369 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1370 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1373 (SELECT player FROM players WHERE nick='Oliyzia'),
1376 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1377 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1379 (SELECT player FROM players WHERE nick='Oliyzia'),
1380 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1383 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1386 (SELECT player FROM players WHERE nick='Oliyzia'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1390 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1392 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1394 (SELECT player FROM players WHERE nick='RiChY'),
1397 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1400 (SELECT player FROM players WHERE nick='RiChY'),
1401 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1404 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1405 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1407 (SELECT player FROM players WHERE nick='RiChY'),
1408 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1411 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1412 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1413 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1415 (SELECT player FROM players WHERE nick='Snute'),
1418 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1419 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1421 (SELECT player FROM players WHERE nick='Snute'),
1422 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1425 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1426 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1428 (SELECT player FROM players WHERE nick='Snute'),
1429 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1432 INSERT INTO groups (tournament, round, parallel) VALUES (
1433 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1435 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1438 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1440 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1441 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1443 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
1445 UPDATE rounds SET randomsongs=2 WHERE
1446 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1448 UPDATE rounds SET chosensongs=1 WHERE
1449 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1451 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
1452 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1455 (SELECT player FROM players WHERE nick='Felz'),
1458 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1459 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1461 (SELECT player FROM players WHERE nick='Felz'),
1462 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1465 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1466 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1468 (SELECT player FROM players WHERE nick='Felz'),
1469 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1472 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
1473 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1476 (SELECT player FROM players WHERE nick='Andeplane'),
1479 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1480 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1482 (SELECT player FROM players WHERE nick='Andeplane'),
1483 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1486 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1487 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1489 (SELECT player FROM players WHERE nick='Andeplane'),
1490 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1493 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1494 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1495 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1497 (SELECT player FROM players WHERE nick='Bonzo'),
1500 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1501 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1503 (SELECT player FROM players WHERE nick='Bonzo'),
1504 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1507 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1508 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1510 (SELECT player FROM players WHERE nick='Bonzo'),
1511 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1514 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1515 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1518 (SELECT player FROM players WHERE nick='Daniil'),
1521 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1522 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1524 (SELECT player FROM players WHERE nick='Daniil'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1528 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1529 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1531 (SELECT player FROM players WHERE nick='Daniil'),
1532 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1535 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1536 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1537 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1539 (SELECT player FROM players WHERE nick='Olemann'),
1542 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1545 (SELECT player FROM players WHERE nick='Olemann'),
1546 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1549 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1550 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1552 (SELECT player FROM players WHERE nick='Olemann'),
1553 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1556 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1557 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1560 (SELECT player FROM players WHERE nick='Snofox'),
1563 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1564 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1566 (SELECT player FROM players WHERE nick='Snofox'),
1567 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1570 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1571 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1573 (SELECT player FROM players WHERE nick='Snofox'),
1574 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1577 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1579 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1581 (SELECT player FROM players WHERE nick='Nameless'),
1584 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1587 (SELECT player FROM players WHERE nick='Nameless'),
1588 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1591 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1592 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1594 (SELECT player FROM players WHERE nick='Nameless'),
1595 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1598 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1600 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1603 INSERT INTO groups (tournament, round, parallel) VALUES (
1604 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1606 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1607 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1609 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1611 UPDATE rounds SET randomsongs=1 WHERE
1612 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1614 UPDATE rounds SET chosensongs=1 WHERE
1615 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1617 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1618 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1619 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1621 (SELECT player FROM players WHERE nick='RiChY'),
1624 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1625 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1627 (SELECT player FROM players WHERE nick='RiChY'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1631 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1635 (SELECT player FROM players WHERE nick='Snofox'),
1638 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1641 (SELECT player FROM players WHERE nick='Snofox'),
1642 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1645 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1649 (SELECT player FROM players WHERE nick='Pingo'),
1652 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1653 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1655 (SELECT player FROM players WHERE nick='Pingo'),
1656 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1659 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1660 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1663 (SELECT player FROM players WHERE nick='OJK'),
1666 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1669 (SELECT player FROM players WHERE nick='OJK'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1673 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1677 (SELECT player FROM players WHERE nick='Oliyzia'),
1680 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1681 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1683 (SELECT player FROM players WHERE nick='Oliyzia'),
1684 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1687 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1688 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1691 (SELECT player FROM players WHERE nick='Bonzo'),
1694 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1695 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1697 (SELECT player FROM players WHERE nick='Bonzo'),
1698 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1701 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1702 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1703 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1705 (SELECT player FROM players WHERE nick='Snute'),
1708 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1709 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1711 (SELECT player FROM players WHERE nick='Snute'),
1712 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1715 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1716 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1719 (SELECT player FROM players WHERE nick='Nameless'),
1722 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1723 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1725 (SELECT player FROM players WHERE nick='Nameless'),
1726 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1729 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1730 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1731 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1733 (SELECT player FROM players WHERE nick='Haggar'),
1736 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1737 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1739 (SELECT player FROM players WHERE nick='Haggar'),
1740 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1743 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1748 INSERT INTO groups (tournament, round, parallel) VALUES (
1749 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1751 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1754 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
1756 UPDATE rounds SET randomsongs=1 WHERE
1757 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1759 UPDATE rounds SET chosensongs=1 WHERE
1760 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1762 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1763 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1764 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1766 (SELECT player FROM players WHERE nick='Nameless'),
1769 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1770 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1772 (SELECT player FROM players WHERE nick='Nameless'),
1773 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1776 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1777 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1780 (SELECT player FROM players WHERE nick='RiChY'),
1783 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1784 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1786 (SELECT player FROM players WHERE nick='RiChY'),
1787 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1790 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1791 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1794 (SELECT player FROM players WHERE nick='Oliyzia'),
1797 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1798 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1800 (SELECT player FROM players WHERE nick='Oliyzia'),
1801 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1804 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1805 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1806 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1808 (SELECT player FROM players WHERE nick='Snofox'),
1811 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1812 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1814 (SELECT player FROM players WHERE nick='Snofox'),
1815 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1818 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1819 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1820 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1822 (SELECT player FROM players WHERE nick='Snute'),
1825 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1828 (SELECT player FROM players WHERE nick='Snute'),
1829 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1832 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1833 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1834 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1836 (SELECT player FROM players WHERE nick='Haggar'),
1839 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1840 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1842 (SELECT player FROM players WHERE nick='Haggar'),
1843 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1846 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1847 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1848 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1850 (SELECT player FROM players WHERE nick='Bonzo'),
1853 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1854 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1856 (SELECT player FROM players WHERE nick='Bonzo'),
1857 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1860 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1862 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1865 INSERT INTO groups (tournament, round, parallel) VALUES (
1866 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1868 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1869 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1871 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
1873 UPDATE rounds SET randomsongs=1 WHERE
1874 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1876 UPDATE rounds SET chosensongs=1 WHERE
1877 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1879 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1880 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1881 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1883 (SELECT player FROM players WHERE nick='Bonzo'),
1886 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1887 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1889 (SELECT player FROM players WHERE nick='Bonzo'),
1890 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1893 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1894 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1897 (SELECT player FROM players WHERE nick='Nameless'),
1900 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1901 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1903 (SELECT player FROM players WHERE nick='Nameless'),
1904 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1907 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1908 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1909 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1911 (SELECT player FROM players WHERE nick='Snofox'),
1914 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1915 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1917 (SELECT player FROM players WHERE nick='Snofox'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1921 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1922 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1925 (SELECT player FROM players WHERE nick='Haggar'),
1928 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1929 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1931 (SELECT player FROM players WHERE nick='Haggar'),
1932 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1935 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1936 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1939 (SELECT player FROM players WHERE nick='Snute'),
1942 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1943 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1945 (SELECT player FROM players WHERE nick='Snute'),
1946 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1949 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1951 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1954 INSERT INTO groups (tournament, round, parallel) VALUES (
1955 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1957 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1960 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1962 UPDATE rounds SET randomsongs=1 WHERE
1963 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1965 UPDATE rounds SET chosensongs=1 WHERE
1966 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1968 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1969 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1970 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1972 (SELECT player FROM players WHERE nick='Snofox'),
1975 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1976 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1978 (SELECT player FROM players WHERE nick='Snofox'),
1979 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1982 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1983 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1984 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1986 (SELECT player FROM players WHERE nick='Haggar'),
1989 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1990 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1992 (SELECT player FROM players WHERE nick='Haggar'),
1993 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1996 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1997 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1998 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2000 (SELECT player FROM players WHERE nick='Nameless'),
2003 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2004 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2006 (SELECT player FROM players WHERE nick='Nameless'),
2007 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2010 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2011 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2012 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2014 (SELECT player FROM players WHERE nick='Snute'),
2017 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2018 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2020 (SELECT player FROM players WHERE nick='Snute'),
2021 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2024 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2026 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2029 INSERT INTO groups (tournament, round, parallel) VALUES (
2030 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2032 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2033 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2035 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2037 UPDATE rounds SET randomsongs=1 WHERE
2038 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2040 UPDATE rounds SET chosensongs=1 WHERE
2041 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2043 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2044 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2045 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2047 (SELECT player FROM players WHERE nick='Nameless'),
2050 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2051 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2053 (SELECT player FROM players WHERE nick='Nameless'),
2054 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2057 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2058 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2059 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2061 (SELECT player FROM players WHERE nick='Haggar'),
2064 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2065 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2067 (SELECT player FROM players WHERE nick='Haggar'),
2068 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2071 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2072 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2073 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2075 (SELECT player FROM players WHERE nick='Snute'),
2078 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2079 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2081 (SELECT player FROM players WHERE nick='Snute'),
2082 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2085 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2090 INSERT INTO groups (tournament, round, parallel) VALUES (
2091 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2093 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2096 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
2098 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2099 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2101 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2103 UPDATE rounds SET randomsongs=2 WHERE
2104 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2106 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2107 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2108 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2110 (SELECT player FROM players WHERE nick='Haggar'),
2113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2116 (SELECT player FROM players WHERE nick='Haggar'),
2117 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2120 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2121 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2123 (SELECT player FROM players WHERE nick='Haggar'),
2124 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2127 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2128 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2129 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2131 (SELECT player FROM players WHERE nick='Snute'),
2134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2137 (SELECT player FROM players WHERE nick='Snute'),
2138 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2144 (SELECT player FROM players WHERE nick='Snute'),
2145 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),