2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE countryname='Norway'),
7 'Tønsberg - Sjøsenteret bowling',
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE tournamentname='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 tournamentname='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 tournamentname='Challenge Cup 7') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='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 tournamentname='Challenge Cup 7'),
40 (SELECT player FROM players WHERE nick='Crienexzy'),
43 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
46 (SELECT player FROM players WHERE nick='Crienexzy'),
48 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
54 (SELECT player FROM players WHERE nick='Crienexzy'),
56 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
62 (SELECT player FROM players WHERE nick='Crienexzy'),
64 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
67 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tove' AS nick WHERE 'Tove' NOT IN ( SELECT nick FROM players );
68 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
69 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
71 (SELECT player FROM players WHERE nick='Tove'),
74 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
75 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
77 (SELECT player FROM players WHERE nick='Tove'),
79 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
85 (SELECT player FROM players WHERE nick='Tove'),
87 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
93 (SELECT player FROM players WHERE nick='Tove'),
95 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
99 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
102 (SELECT player FROM players WHERE nick='JonAnders'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
108 (SELECT player FROM players WHERE nick='JonAnders'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
116 (SELECT player FROM players WHERE nick='JonAnders'),
118 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
124 (SELECT player FROM players WHERE nick='JonAnders'),
126 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
133 (SELECT player FROM players WHERE nick='Andeplane'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
139 (SELECT player FROM players WHERE nick='Andeplane'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
147 (SELECT player FROM players WHERE nick='Andeplane'),
149 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
155 (SELECT player FROM players WHERE nick='Andeplane'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
164 (SELECT player FROM players WHERE nick='Matsi'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
170 (SELECT player FROM players WHERE nick='Matsi'),
172 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
178 (SELECT player FROM players WHERE nick='Matsi'),
180 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
186 (SELECT player FROM players WHERE nick='Matsi'),
188 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
195 (SELECT player FROM players WHERE nick='Snofox'),
198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
201 (SELECT player FROM players WHERE nick='Snofox'),
203 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
209 (SELECT player FROM players WHERE nick='Snofox'),
211 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
217 (SELECT player FROM players WHERE nick='Snofox'),
219 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
226 (SELECT player FROM players WHERE nick='T|na'),
229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
232 (SELECT player FROM players WHERE nick='T|na'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
240 (SELECT player FROM players WHERE nick='T|na'),
242 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
245 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
248 (SELECT player FROM players WHERE nick='T|na'),
250 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
253 INSERT INTO groups (tournament, round, parallel) VALUES (
254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
256 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
259 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
261 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
264 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
266 UPDATE rounds SET randomsongs=2 WHERE
267 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
269 UPDATE rounds SET chosensongs=1 WHERE
270 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'uSimen' AS nick WHERE 'uSimen' NOT IN ( SELECT nick FROM players );
273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
276 (SELECT player FROM players WHERE nick='uSimen'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
282 (SELECT player FROM players WHERE nick='uSimen'),
284 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
290 (SELECT player FROM players WHERE nick='uSimen'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
298 (SELECT player FROM players WHERE nick='uSimen'),
300 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
307 (SELECT player FROM players WHERE nick='Pfxp'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
313 (SELECT player FROM players WHERE nick='Pfxp'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
321 (SELECT player FROM players WHERE nick='Pfxp'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
329 (SELECT player FROM players WHERE nick='Pfxp'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
338 (SELECT player FROM players WHERE nick='Glock'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
344 (SELECT player FROM players WHERE nick='Glock'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
352 (SELECT player FROM players WHERE nick='Glock'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
360 (SELECT player FROM players WHERE nick='Glock'),
362 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
365 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
369 (SELECT player FROM players WHERE nick='Eruanna'),
372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
375 (SELECT player FROM players WHERE nick='Eruanna'),
377 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
383 (SELECT player FROM players WHERE nick='Eruanna'),
385 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
391 (SELECT player FROM players WHERE nick='Eruanna'),
393 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
396 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
400 (SELECT player FROM players WHERE nick='v|per'),
403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
406 (SELECT player FROM players WHERE nick='v|per'),
408 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
414 (SELECT player FROM players WHERE nick='v|per'),
416 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
422 (SELECT player FROM players WHERE nick='v|per'),
424 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
427 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
428 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
431 (SELECT player FROM players WHERE nick='Daniil'),
434 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
435 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
437 (SELECT player FROM players WHERE nick='Daniil'),
439 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
442 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
443 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
445 (SELECT player FROM players WHERE nick='Daniil'),
447 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
450 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
451 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
453 (SELECT player FROM players WHERE nick='Daniil'),
455 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
458 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
459 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
462 (SELECT player FROM players WHERE nick='Nameless'),
465 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
466 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
468 (SELECT player FROM players WHERE nick='Nameless'),
470 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
476 (SELECT player FROM players WHERE nick='Nameless'),
478 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
484 (SELECT player FROM players WHERE nick='Nameless'),
486 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
489 INSERT INTO groups (tournament, round, parallel) VALUES (
490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
492 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
495 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
497 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
500 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
502 UPDATE rounds SET randomsongs=2 WHERE
503 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
505 UPDATE rounds SET chosensongs=1 WHERE
506 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick WHERE 'Benny' NOT IN ( SELECT nick FROM players );
509 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
512 (SELECT player FROM players WHERE nick='Benny'),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
518 (SELECT player FROM players WHERE nick='Benny'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
526 (SELECT player FROM players WHERE nick='Benny'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
534 (SELECT player FROM players WHERE nick='Benny'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
539 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Volstad' AS nick WHERE 'Volstad' NOT IN ( SELECT nick FROM players );
540 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
543 (SELECT player FROM players WHERE nick='Volstad'),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
549 (SELECT player FROM players WHERE nick='Volstad'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
557 (SELECT player FROM players WHERE nick='Volstad'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
565 (SELECT player FROM players WHERE nick='Volstad'),
567 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
570 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
571 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
574 (SELECT player FROM players WHERE nick='Annkakri'),
577 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
578 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
580 (SELECT player FROM players WHERE nick='Annkakri'),
582 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
585 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
586 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
588 (SELECT player FROM players WHERE nick='Annkakri'),
590 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
594 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
596 (SELECT player FROM players WHERE nick='Annkakri'),
598 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
601 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
605 (SELECT player FROM players WHERE nick='Athena'),
608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
611 (SELECT player FROM players WHERE nick='Athena'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
619 (SELECT player FROM players WHERE nick='Athena'),
621 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
627 (SELECT player FROM players WHERE nick='Athena'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
632 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
633 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
636 (SELECT player FROM players WHERE nick='Felz'),
639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
642 (SELECT player FROM players WHERE nick='Felz'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
650 (SELECT player FROM players WHERE nick='Felz'),
652 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
655 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
658 (SELECT player FROM players WHERE nick='Felz'),
660 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
663 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
664 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
665 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
667 (SELECT player FROM players WHERE nick='Ylini'),
670 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
671 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
673 (SELECT player FROM players WHERE nick='Ylini'),
675 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
681 (SELECT player FROM players WHERE nick='Ylini'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
686 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
689 (SELECT player FROM players WHERE nick='Ylini'),
691 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
694 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
695 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
698 (SELECT player FROM players WHERE nick='Oliyzia'),
701 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
702 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
704 (SELECT player FROM players WHERE nick='Oliyzia'),
706 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
709 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
710 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
712 (SELECT player FROM players WHERE nick='Oliyzia'),
714 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
717 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
718 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
720 (SELECT player FROM players WHERE nick='Oliyzia'),
722 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
725 INSERT INTO groups (tournament, round, parallel) VALUES (
726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
728 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
731 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
733 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
734 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
736 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
738 UPDATE rounds SET randomsongs=2 WHERE
739 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
741 UPDATE rounds SET chosensongs=1 WHERE
742 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
744 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Voffen' AS nick WHERE 'Voffen' NOT IN ( SELECT nick FROM players );
745 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
748 (SELECT player FROM players WHERE nick='Voffen'),
751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
754 (SELECT player FROM players WHERE nick='Voffen'),
756 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
762 (SELECT player FROM players WHERE nick='Voffen'),
764 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
770 (SELECT player FROM players WHERE nick='Voffen'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
775 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
776 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
779 (SELECT player FROM players WHERE nick='Zackie'),
782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
785 (SELECT player FROM players WHERE nick='Zackie'),
787 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
793 (SELECT player FROM players WHERE nick='Zackie'),
795 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
801 (SELECT player FROM players WHERE nick='Zackie'),
803 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
806 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
807 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
810 (SELECT player FROM players WHERE nick='Zeila'),
813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
816 (SELECT player FROM players WHERE nick='Zeila'),
818 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
824 (SELECT player FROM players WHERE nick='Zeila'),
826 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
829 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
832 (SELECT player FROM players WHERE nick='Zeila'),
834 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
837 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
838 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
841 (SELECT player FROM players WHERE nick='Alexxz'),
844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
845 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
847 (SELECT player FROM players WHERE nick='Alexxz'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
852 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
855 (SELECT player FROM players WHERE nick='Alexxz'),
857 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
863 (SELECT player FROM players WHERE nick='Alexxz'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
868 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
869 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
872 (SELECT player FROM players WHERE nick='Olemann'),
875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
878 (SELECT player FROM players WHERE nick='Olemann'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
886 (SELECT player FROM players WHERE nick='Olemann'),
888 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
894 (SELECT player FROM players WHERE nick='Olemann'),
896 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
899 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
900 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
901 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
903 (SELECT player FROM players WHERE nick='RiChY'),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
909 (SELECT player FROM players WHERE nick='RiChY'),
911 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
914 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
917 (SELECT player FROM players WHERE nick='RiChY'),
919 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
922 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
925 (SELECT player FROM players WHERE nick='RiChY'),
927 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
930 INSERT INTO groups (tournament, round, parallel) VALUES (
931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
933 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
936 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
938 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
939 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
941 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
943 UPDATE rounds SET randomsongs=2 WHERE
944 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
946 UPDATE rounds SET chosensongs=1 WHERE
947 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
949 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'SLC' AS nick WHERE 'SLC' NOT IN ( SELECT nick FROM players );
950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
953 (SELECT player FROM players WHERE nick='SLC'),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
959 (SELECT player FROM players WHERE nick='SLC'),
961 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
967 (SELECT player FROM players WHERE nick='SLC'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
975 (SELECT player FROM players WHERE nick='SLC'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
980 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
984 (SELECT player FROM players WHERE nick='Matti'),
987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
990 (SELECT player FROM players WHERE nick='Matti'),
992 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
998 (SELECT player FROM players WHERE nick='Matti'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1006 (SELECT player FROM players WHERE nick='Matti'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1011 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1015 (SELECT player FROM players WHERE nick='Hyper'),
1018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1021 (SELECT player FROM players WHERE nick='Hyper'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1027 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1029 (SELECT player FROM players WHERE nick='Hyper'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1037 (SELECT player FROM players WHERE nick='Hyper'),
1039 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1042 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1043 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1044 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1046 (SELECT player FROM players WHERE nick='Mync'),
1049 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1052 (SELECT player FROM players WHERE nick='Mync'),
1054 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1057 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1058 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1060 (SELECT player FROM players WHERE nick='Mync'),
1062 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1065 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1068 (SELECT player FROM players WHERE nick='Mync'),
1070 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1073 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1074 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1077 (SELECT player FROM players WHERE nick='Duckling'),
1080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1083 (SELECT player FROM players WHERE nick='Duckling'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1088 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1091 (SELECT player FROM players WHERE nick='Duckling'),
1093 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1096 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1099 (SELECT player FROM players WHERE nick='Duckling'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1104 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1105 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1108 (SELECT player FROM players WHERE nick='Haggar'),
1111 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1114 (SELECT player FROM players WHERE nick='Haggar'),
1116 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1119 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1122 (SELECT player FROM players WHERE nick='Haggar'),
1124 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1130 (SELECT player FROM players WHERE nick='Haggar'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1135 INSERT INTO groups (tournament, round, parallel) VALUES (
1136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1138 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1141 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
1143 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1148 UPDATE rounds SET randomsongs=2 WHERE
1149 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1151 UPDATE rounds SET chosensongs=1 WHERE
1152 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1154 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dritago' AS nick WHERE 'Dritago' NOT IN ( SELECT nick FROM players );
1155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1158 (SELECT player FROM players WHERE nick='Dritago'),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1164 (SELECT player FROM players WHERE nick='Dritago'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1172 (SELECT player FROM players WHERE nick='Dritago'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1180 (SELECT player FROM players WHERE nick='Dritago'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1185 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
1186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1189 (SELECT player FROM players WHERE nick='Pyro'),
1192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1195 (SELECT player FROM players WHERE nick='Pyro'),
1197 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1203 (SELECT player FROM players WHERE nick='Pyro'),
1205 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1211 (SELECT player FROM players WHERE nick='Pyro'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1216 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
1217 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1220 (SELECT player FROM players WHERE nick='Marilla'),
1223 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1226 (SELECT player FROM players WHERE nick='Marilla'),
1228 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1231 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1234 (SELECT player FROM players WHERE nick='Marilla'),
1236 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1239 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1242 (SELECT player FROM players WHERE nick='Marilla'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1247 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1248 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1251 (SELECT player FROM players WHERE nick='Pingo'),
1254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1257 (SELECT player FROM players WHERE nick='Pingo'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1265 (SELECT player FROM players WHERE nick='Pingo'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1273 (SELECT player FROM players WHERE nick='Pingo'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1278 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1279 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1282 (SELECT player FROM players WHERE nick='Bonzo'),
1285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1286 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1288 (SELECT player FROM players WHERE nick='Bonzo'),
1290 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1294 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1296 (SELECT player FROM players WHERE nick='Bonzo'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1304 (SELECT player FROM players WHERE nick='Bonzo'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1309 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1310 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1313 (SELECT player FROM players WHERE nick='OJK'),
1316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1319 (SELECT player FROM players WHERE nick='OJK'),
1321 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1327 (SELECT player FROM players WHERE nick='OJK'),
1329 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1335 (SELECT player FROM players WHERE nick='OJK'),
1337 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1340 INSERT INTO groups (tournament, round, parallel) VALUES (
1341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1343 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1346 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1348 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1351 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1353 UPDATE rounds SET randomsongs=2 WHERE
1354 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1356 UPDATE rounds SET chosensongs=1 WHERE
1357 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1359 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
1360 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1363 (SELECT player FROM players WHERE nick='Indy'),
1366 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1369 (SELECT player FROM players WHERE nick='Indy'),
1371 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1377 (SELECT player FROM players WHERE nick='Indy'),
1379 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1382 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1383 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1385 (SELECT player FROM players WHERE nick='Indy'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1390 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
1391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1394 (SELECT player FROM players WHERE nick='Electron'),
1397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1400 (SELECT player FROM players WHERE nick='Electron'),
1402 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1408 (SELECT player FROM players WHERE nick='Electron'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1413 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1416 (SELECT player FROM players WHERE nick='Electron'),
1418 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1421 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
1422 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1425 (SELECT player FROM players WHERE nick='Bush'),
1428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1429 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1431 (SELECT player FROM players WHERE nick='Bush'),
1433 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1439 (SELECT player FROM players WHERE nick='Bush'),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1445 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1447 (SELECT player FROM players WHERE nick='Bush'),
1449 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1452 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1453 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1456 (SELECT player FROM players WHERE nick='Gogo'),
1459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1462 (SELECT player FROM players WHERE nick='Gogo'),
1464 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1470 (SELECT player FROM players WHERE nick='Gogo'),
1472 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1478 (SELECT player FROM players WHERE nick='Gogo'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1483 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1484 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1487 (SELECT player FROM players WHERE nick='Smiph'),
1490 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1493 (SELECT player FROM players WHERE nick='Smiph'),
1495 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1498 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1501 (SELECT player FROM players WHERE nick='Smiph'),
1503 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1506 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1509 (SELECT player FROM players WHERE nick='Smiph'),
1511 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1514 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1515 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1518 (SELECT player FROM players WHERE nick='Snute'),
1521 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1524 (SELECT player FROM players WHERE nick='Snute'),
1526 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1532 (SELECT player FROM players WHERE nick='Snute'),
1534 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1540 (SELECT player FROM players WHERE nick='Snute'),
1542 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1545 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1550 INSERT INTO groups (tournament, round, parallel) VALUES (
1551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1553 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1556 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
1558 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1561 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1563 UPDATE rounds SET randomsongs=2 WHERE
1564 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1566 UPDATE rounds SET chosensongs=1 WHERE
1567 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1569 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1570 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1573 (SELECT player FROM players WHERE nick='v|per'),
1576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1579 (SELECT player FROM players WHERE nick='v|per'),
1581 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1587 (SELECT player FROM players WHERE nick='v|per'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1595 (SELECT player FROM players WHERE nick='v|per'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1600 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1601 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1604 (SELECT player FROM players WHERE nick='Mync'),
1607 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1608 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1610 (SELECT player FROM players WHERE nick='Mync'),
1612 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1615 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1618 (SELECT player FROM players WHERE nick='Mync'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1623 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1626 (SELECT player FROM players WHERE nick='Mync'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1631 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1635 (SELECT player FROM players WHERE nick='Duckling'),
1638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1641 (SELECT player FROM players WHERE nick='Duckling'),
1643 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1649 (SELECT player FROM players WHERE nick='Duckling'),
1651 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1654 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1657 (SELECT player FROM players WHERE nick='Duckling'),
1659 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1662 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1663 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1666 (SELECT player FROM players WHERE nick='T|na'),
1669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1672 (SELECT player FROM players WHERE nick='T|na'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1680 (SELECT player FROM players WHERE nick='T|na'),
1682 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1688 (SELECT player FROM players WHERE nick='T|na'),
1690 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1693 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1694 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1697 (SELECT player FROM players WHERE nick='Pingo'),
1700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1701 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1703 (SELECT player FROM players WHERE nick='Pingo'),
1705 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1711 (SELECT player FROM players WHERE nick='Pingo'),
1713 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1716 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1717 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1719 (SELECT player FROM players WHERE nick='Pingo'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1724 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1725 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1728 (SELECT player FROM players WHERE nick='Haggar'),
1731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1732 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1734 (SELECT player FROM players WHERE nick='Haggar'),
1736 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1739 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1740 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1742 (SELECT player FROM players WHERE nick='Haggar'),
1744 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1747 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1748 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1750 (SELECT player FROM players WHERE nick='Haggar'),
1752 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1755 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1756 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1757 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1759 (SELECT player FROM players WHERE nick='OJK'),
1762 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1763 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1765 (SELECT player FROM players WHERE nick='OJK'),
1767 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1773 (SELECT player FROM players WHERE nick='OJK'),
1775 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1781 (SELECT player FROM players WHERE nick='OJK'),
1783 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1786 INSERT INTO groups (tournament, round, parallel) VALUES (
1787 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1789 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1792 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1794 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1795 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1797 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
1799 UPDATE rounds SET randomsongs=2 WHERE
1800 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1802 UPDATE rounds SET chosensongs=1 WHERE
1803 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1805 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
1806 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1807 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1809 (SELECT player FROM players WHERE nick='Alexxz'),
1812 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1813 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1815 (SELECT player FROM players WHERE nick='Alexxz'),
1817 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1820 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1821 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1823 (SELECT player FROM players WHERE nick='Alexxz'),
1825 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1828 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1829 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1831 (SELECT player FROM players WHERE nick='Alexxz'),
1833 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1836 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1840 (SELECT player FROM players WHERE nick='Smiph'),
1843 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1846 (SELECT player FROM players WHERE nick='Smiph'),
1848 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1851 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1854 (SELECT player FROM players WHERE nick='Smiph'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1862 (SELECT player FROM players WHERE nick='Smiph'),
1864 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1867 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1868 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1871 (SELECT player FROM players WHERE nick='Ylini'),
1874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1875 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1877 (SELECT player FROM players WHERE nick='Ylini'),
1879 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1885 (SELECT player FROM players WHERE nick='Ylini'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1893 (SELECT player FROM players WHERE nick='Ylini'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1898 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1899 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1902 (SELECT player FROM players WHERE nick='Gogo'),
1905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1908 (SELECT player FROM players WHERE nick='Gogo'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1916 (SELECT player FROM players WHERE nick='Gogo'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1921 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1924 (SELECT player FROM players WHERE nick='Gogo'),
1926 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1929 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1930 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1933 (SELECT player FROM players WHERE nick='Oliyzia'),
1936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1939 (SELECT player FROM players WHERE nick='Oliyzia'),
1941 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1947 (SELECT player FROM players WHERE nick='Oliyzia'),
1949 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1952 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1955 (SELECT player FROM players WHERE nick='Oliyzia'),
1957 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1960 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1961 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1962 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1964 (SELECT player FROM players WHERE nick='RiChY'),
1967 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1968 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1970 (SELECT player FROM players WHERE nick='RiChY'),
1972 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1975 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1976 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1978 (SELECT player FROM players WHERE nick='RiChY'),
1980 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1983 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1984 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1986 (SELECT player FROM players WHERE nick='RiChY'),
1988 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1991 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1992 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1995 (SELECT player FROM players WHERE nick='Snute'),
1998 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2001 (SELECT player FROM players WHERE nick='Snute'),
2003 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2009 (SELECT player FROM players WHERE nick='Snute'),
2011 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2017 (SELECT player FROM players WHERE nick='Snute'),
2019 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2022 INSERT INTO groups (tournament, round, parallel) VALUES (
2023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2025 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2028 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2030 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2031 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2033 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
2035 UPDATE rounds SET randomsongs=2 WHERE
2036 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2038 UPDATE rounds SET chosensongs=1 WHERE
2039 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2041 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
2042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2045 (SELECT player FROM players WHERE nick='Felz'),
2048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2051 (SELECT player FROM players WHERE nick='Felz'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2059 (SELECT player FROM players WHERE nick='Felz'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2064 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2067 (SELECT player FROM players WHERE nick='Felz'),
2069 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2072 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
2073 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2074 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2076 (SELECT player FROM players WHERE nick='Andeplane'),
2079 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2080 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2082 (SELECT player FROM players WHERE nick='Andeplane'),
2084 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2087 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2090 (SELECT player FROM players WHERE nick='Andeplane'),
2092 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2096 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2098 (SELECT player FROM players WHERE nick='Andeplane'),
2100 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2103 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2104 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2105 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2107 (SELECT player FROM players WHERE nick='Bonzo'),
2110 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2113 (SELECT player FROM players WHERE nick='Bonzo'),
2115 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2119 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2121 (SELECT player FROM players WHERE nick='Bonzo'),
2123 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2129 (SELECT player FROM players WHERE nick='Bonzo'),
2131 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2134 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
2135 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2138 (SELECT player FROM players WHERE nick='Daniil'),
2141 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2142 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2144 (SELECT player FROM players WHERE nick='Daniil'),
2146 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2149 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2150 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2152 (SELECT player FROM players WHERE nick='Daniil'),
2154 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2160 (SELECT player FROM players WHERE nick='Daniil'),
2162 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2165 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
2166 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2167 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2169 (SELECT player FROM players WHERE nick='Olemann'),
2172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2173 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2175 (SELECT player FROM players WHERE nick='Olemann'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2180 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2181 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2183 (SELECT player FROM players WHERE nick='Olemann'),
2185 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2189 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2191 (SELECT player FROM players WHERE nick='Olemann'),
2193 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2196 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2200 (SELECT player FROM players WHERE nick='Snofox'),
2203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2204 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2206 (SELECT player FROM players WHERE nick='Snofox'),
2208 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2214 (SELECT player FROM players WHERE nick='Snofox'),
2216 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2222 (SELECT player FROM players WHERE nick='Snofox'),
2224 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2227 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2231 (SELECT player FROM players WHERE nick='Nameless'),
2234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2237 (SELECT player FROM players WHERE nick='Nameless'),
2239 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2245 (SELECT player FROM players WHERE nick='Nameless'),
2247 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2253 (SELECT player FROM players WHERE nick='Nameless'),
2255 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2258 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2263 INSERT INTO groups (tournament, round, parallel) VALUES (
2264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2266 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2269 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2271 UPDATE rounds SET randomsongs=1 WHERE
2272 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2274 UPDATE rounds SET chosensongs=1 WHERE
2275 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2277 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2278 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2281 (SELECT player FROM players WHERE nick='RiChY'),
2284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2287 (SELECT player FROM players WHERE nick='RiChY'),
2289 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2292 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2295 (SELECT player FROM players WHERE nick='RiChY'),
2297 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2300 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2301 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2304 (SELECT player FROM players WHERE nick='Snofox'),
2307 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2308 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2310 (SELECT player FROM players WHERE nick='Snofox'),
2312 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2315 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2316 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2318 (SELECT player FROM players WHERE nick='Snofox'),
2320 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2323 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
2324 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2327 (SELECT player FROM players WHERE nick='Pingo'),
2330 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2333 (SELECT player FROM players WHERE nick='Pingo'),
2335 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2338 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2339 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2341 (SELECT player FROM players WHERE nick='Pingo'),
2343 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2346 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2347 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2350 (SELECT player FROM players WHERE nick='OJK'),
2353 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2354 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2356 (SELECT player FROM players WHERE nick='OJK'),
2358 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2364 (SELECT player FROM players WHERE nick='OJK'),
2366 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2369 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2370 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2371 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2373 (SELECT player FROM players WHERE nick='Oliyzia'),
2376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2379 (SELECT player FROM players WHERE nick='Oliyzia'),
2381 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2385 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2387 (SELECT player FROM players WHERE nick='Oliyzia'),
2389 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2392 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2393 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2396 (SELECT player FROM players WHERE nick='Bonzo'),
2399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2402 (SELECT player FROM players WHERE nick='Bonzo'),
2404 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2410 (SELECT player FROM players WHERE nick='Bonzo'),
2412 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2415 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2416 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2419 (SELECT player FROM players WHERE nick='Snute'),
2422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2425 (SELECT player FROM players WHERE nick='Snute'),
2427 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2433 (SELECT player FROM players WHERE nick='Snute'),
2435 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2442 (SELECT player FROM players WHERE nick='Nameless'),
2445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2448 (SELECT player FROM players WHERE nick='Nameless'),
2450 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2456 (SELECT player FROM players WHERE nick='Nameless'),
2458 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2461 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2462 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2463 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2465 (SELECT player FROM players WHERE nick='Haggar'),
2468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2471 (SELECT player FROM players WHERE nick='Haggar'),
2473 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2476 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2479 (SELECT player FROM players WHERE nick='Haggar'),
2481 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2484 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2489 INSERT INTO groups (tournament, round, parallel) VALUES (
2490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2492 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2495 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
2497 UPDATE rounds SET randomsongs=1 WHERE
2498 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2500 UPDATE rounds SET chosensongs=1 WHERE
2501 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2503 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2504 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2507 (SELECT player FROM players WHERE nick='Nameless'),
2510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2511 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2513 (SELECT player FROM players WHERE nick='Nameless'),
2515 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2521 (SELECT player FROM players WHERE nick='Nameless'),
2523 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2526 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2527 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2528 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2530 (SELECT player FROM players WHERE nick='RiChY'),
2533 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2534 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2536 (SELECT player FROM players WHERE nick='RiChY'),
2538 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2544 (SELECT player FROM players WHERE nick='RiChY'),
2546 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2549 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2550 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2553 (SELECT player FROM players WHERE nick='Oliyzia'),
2556 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2557 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2559 (SELECT player FROM players WHERE nick='Oliyzia'),
2561 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2564 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2565 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2567 (SELECT player FROM players WHERE nick='Oliyzia'),
2569 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2572 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2573 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2576 (SELECT player FROM players WHERE nick='Snofox'),
2579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2582 (SELECT player FROM players WHERE nick='Snofox'),
2584 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2588 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2590 (SELECT player FROM players WHERE nick='Snofox'),
2592 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2595 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2599 (SELECT player FROM players WHERE nick='Snute'),
2602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2605 (SELECT player FROM players WHERE nick='Snute'),
2607 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2613 (SELECT player FROM players WHERE nick='Snute'),
2615 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2618 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2619 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2622 (SELECT player FROM players WHERE nick='Haggar'),
2625 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2626 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2628 (SELECT player FROM players WHERE nick='Haggar'),
2630 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2633 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2636 (SELECT player FROM players WHERE nick='Haggar'),
2638 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2641 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2642 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2643 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2645 (SELECT player FROM players WHERE nick='Bonzo'),
2648 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2649 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2651 (SELECT player FROM players WHERE nick='Bonzo'),
2653 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2656 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2659 (SELECT player FROM players WHERE nick='Bonzo'),
2661 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2664 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2669 INSERT INTO groups (tournament, round, parallel) VALUES (
2670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2672 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2675 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
2677 UPDATE rounds SET randomsongs=1 WHERE
2678 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2680 UPDATE rounds SET chosensongs=1 WHERE
2681 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2683 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2684 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2687 (SELECT player FROM players WHERE nick='Bonzo'),
2690 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2691 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2693 (SELECT player FROM players WHERE nick='Bonzo'),
2695 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2698 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2701 (SELECT player FROM players WHERE nick='Bonzo'),
2703 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2706 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2707 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2708 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2710 (SELECT player FROM players WHERE nick='Nameless'),
2713 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2714 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2716 (SELECT player FROM players WHERE nick='Nameless'),
2718 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2721 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2722 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2724 (SELECT player FROM players WHERE nick='Nameless'),
2726 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2729 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2730 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2731 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2733 (SELECT player FROM players WHERE nick='Snofox'),
2736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2739 (SELECT player FROM players WHERE nick='Snofox'),
2741 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2744 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2747 (SELECT player FROM players WHERE nick='Snofox'),
2749 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2752 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2756 (SELECT player FROM players WHERE nick='Haggar'),
2759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2762 (SELECT player FROM players WHERE nick='Haggar'),
2764 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2770 (SELECT player FROM players WHERE nick='Haggar'),
2772 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2775 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2776 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2777 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2779 (SELECT player FROM players WHERE nick='Snute'),
2782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2785 (SELECT player FROM players WHERE nick='Snute'),
2787 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2793 (SELECT player FROM players WHERE nick='Snute'),
2795 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2798 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2803 INSERT INTO groups (tournament, round, parallel) VALUES (
2804 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2806 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2807 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2809 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
2811 UPDATE rounds SET randomsongs=1 WHERE
2812 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2814 UPDATE rounds SET chosensongs=1 WHERE
2815 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2817 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2818 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2821 (SELECT player FROM players WHERE nick='Snofox'),
2824 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2825 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2827 (SELECT player FROM players WHERE nick='Snofox'),
2829 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2835 (SELECT player FROM players WHERE nick='Snofox'),
2837 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2840 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2841 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2842 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2844 (SELECT player FROM players WHERE nick='Haggar'),
2847 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2850 (SELECT player FROM players WHERE nick='Haggar'),
2852 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2855 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2858 (SELECT player FROM players WHERE nick='Haggar'),
2860 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2863 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2864 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2865 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2867 (SELECT player FROM players WHERE nick='Nameless'),
2870 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2871 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2873 (SELECT player FROM players WHERE nick='Nameless'),
2875 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2878 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2879 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2881 (SELECT player FROM players WHERE nick='Nameless'),
2883 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2886 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2887 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2888 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2890 (SELECT player FROM players WHERE nick='Snute'),
2893 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2896 (SELECT player FROM players WHERE nick='Snute'),
2898 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2901 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2902 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2904 (SELECT player FROM players WHERE nick='Snute'),
2906 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2909 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2914 INSERT INTO groups (tournament, round, parallel) VALUES (
2915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2917 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2918 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2920 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2922 UPDATE rounds SET randomsongs=1 WHERE
2923 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2925 UPDATE rounds SET chosensongs=1 WHERE
2926 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2928 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2929 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2930 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2932 (SELECT player FROM players WHERE nick='Nameless'),
2935 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2936 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2938 (SELECT player FROM players WHERE nick='Nameless'),
2940 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2946 (SELECT player FROM players WHERE nick='Nameless'),
2948 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2951 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2952 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2955 (SELECT player FROM players WHERE nick='Haggar'),
2958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2961 (SELECT player FROM players WHERE nick='Haggar'),
2963 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2969 (SELECT player FROM players WHERE nick='Haggar'),
2971 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2974 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2975 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2976 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2978 (SELECT player FROM players WHERE nick='Snute'),
2981 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2984 (SELECT player FROM players WHERE nick='Snute'),
2986 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2989 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2990 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2992 (SELECT player FROM players WHERE nick='Snute'),
2994 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2997 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3002 INSERT INTO groups (tournament, round, parallel) VALUES (
3003 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3005 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3006 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3008 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
3010 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3013 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
3015 UPDATE rounds SET randomsongs=2 WHERE
3016 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3018 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
3019 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3020 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3022 (SELECT player FROM players WHERE nick='Haggar'),
3025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3028 (SELECT player FROM players WHERE nick='Haggar'),
3030 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
3033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3036 (SELECT player FROM players WHERE nick='Haggar'),
3038 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
3041 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
3042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3045 (SELECT player FROM players WHERE nick='Snute'),
3048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3051 (SELECT player FROM players WHERE nick='Snute'),
3053 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
3056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3059 (SELECT player FROM players WHERE nick='Snute'),
3061 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),