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 tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
57 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
58 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
60 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
61 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
63 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
66 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
69 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
70 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
72 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
75 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
76 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
78 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
79 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
81 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
82 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
84 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
85 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
87 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
88 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
90 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
93 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
96 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
99 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
102 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
105 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
108 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
111 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
114 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
116 35, 'Crienexzy', 21);
117 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
120 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
123 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
126 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
129 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
130 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
131 40, 'JonAnders', 16);
132 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
135 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
138 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
141 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
142 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
144 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
147 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
152 INSERT INTO groups (tournament, round, parallel) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
155 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
158 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
160 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
163 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
165 UPDATE rounds SET randomsongs=2 WHERE
166 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
168 UPDATE rounds SET chosensongs=1 WHERE
169 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
171 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Crienexzy' AS nick WHERE 'Crienexzy' NOT IN ( SELECT nick FROM players );
172 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
173 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
175 (SELECT player FROM players WHERE nick='Crienexzy'),
178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
181 (SELECT player FROM players WHERE nick='Crienexzy'),
183 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
189 (SELECT player FROM players WHERE nick='Crienexzy'),
191 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
197 (SELECT player FROM players WHERE nick='Crienexzy'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tove' AS nick WHERE 'Tove' NOT IN ( SELECT nick FROM players );
203 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
204 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
206 (SELECT player FROM players WHERE nick='Tove'),
209 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
212 (SELECT player FROM players WHERE nick='Tove'),
214 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
220 (SELECT player FROM players WHERE nick='Tove'),
222 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
228 (SELECT player FROM players WHERE nick='Tove'),
230 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
233 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
234 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
237 (SELECT player FROM players WHERE nick='JonAnders'),
240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
243 (SELECT player FROM players WHERE nick='JonAnders'),
245 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
251 (SELECT player FROM players WHERE nick='JonAnders'),
253 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
259 (SELECT player FROM players WHERE nick='JonAnders'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
264 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
265 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
268 (SELECT player FROM players WHERE nick='Andeplane'),
271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
274 (SELECT player FROM players WHERE nick='Andeplane'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
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='Andeplane'),
284 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='Andeplane'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
295 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
296 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
299 (SELECT player FROM players WHERE nick='Matsi'),
302 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
305 (SELECT player FROM players WHERE nick='Matsi'),
307 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
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='Matsi'),
315 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='Matsi'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
327 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
330 (SELECT player FROM players WHERE nick='Snofox'),
333 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
336 (SELECT player FROM players WHERE nick='Snofox'),
338 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
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='Snofox'),
346 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='Snofox'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
357 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
358 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
361 (SELECT player FROM players WHERE nick='T|na'),
364 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
367 (SELECT player FROM players WHERE nick='T|na'),
369 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
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='T|na'),
377 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='T|na'),
385 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
388 INSERT INTO groups (tournament, round, parallel) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
391 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
394 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
396 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
399 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
401 UPDATE rounds SET randomsongs=2 WHERE
402 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
404 UPDATE rounds SET chosensongs=1 WHERE
405 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
407 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'uSimen' AS nick WHERE 'uSimen' NOT IN ( SELECT nick FROM players );
408 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
409 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
411 (SELECT player FROM players WHERE nick='uSimen'),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
417 (SELECT player FROM players WHERE nick='uSimen'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
425 (SELECT player FROM players WHERE nick='uSimen'),
427 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
433 (SELECT player FROM players WHERE nick='uSimen'),
435 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
442 (SELECT player FROM players WHERE nick='Pfxp'),
445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
448 (SELECT player FROM players WHERE nick='Pfxp'),
450 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
456 (SELECT player FROM players WHERE nick='Pfxp'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
464 (SELECT player FROM players WHERE nick='Pfxp'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
469 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
470 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
473 (SELECT player FROM players WHERE nick='Glock'),
476 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
479 (SELECT player FROM players WHERE nick='Glock'),
481 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
487 (SELECT player FROM players WHERE nick='Glock'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
495 (SELECT player FROM players WHERE nick='Glock'),
497 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
500 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
501 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
504 (SELECT player FROM players WHERE nick='Eruanna'),
507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
510 (SELECT player FROM players WHERE nick='Eruanna'),
512 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
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='Eruanna'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
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='Eruanna'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
531 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
532 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
535 (SELECT player FROM players WHERE nick='v|per'),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
541 (SELECT player FROM players WHERE nick='v|per'),
543 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
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='v|per'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
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='v|per'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
562 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
563 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
564 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
566 (SELECT player FROM players WHERE nick='Daniil'),
569 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
572 (SELECT player FROM players WHERE nick='Daniil'),
574 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
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='Daniil'),
582 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
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='Daniil'),
590 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
593 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
594 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
597 (SELECT player FROM players WHERE nick='Nameless'),
600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
603 (SELECT player FROM players WHERE nick='Nameless'),
605 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
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='Nameless'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
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='Nameless'),
621 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
624 INSERT INTO groups (tournament, round, parallel) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
627 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
630 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
632 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
635 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
637 UPDATE rounds SET randomsongs=2 WHERE
638 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
640 UPDATE rounds SET chosensongs=1 WHERE
641 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
643 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick WHERE 'Benny' NOT IN ( SELECT nick FROM players );
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
647 (SELECT player FROM players WHERE nick='Benny'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
653 (SELECT player FROM players WHERE nick='Benny'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
661 (SELECT player FROM players WHERE nick='Benny'),
663 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
669 (SELECT player FROM players WHERE nick='Benny'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
674 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Volstad' AS nick WHERE 'Volstad' NOT IN ( SELECT nick FROM players );
675 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
678 (SELECT player FROM players WHERE nick='Volstad'),
681 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
684 (SELECT player FROM players WHERE nick='Volstad'),
686 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
692 (SELECT player FROM players WHERE nick='Volstad'),
694 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
700 (SELECT player FROM players WHERE nick='Volstad'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
705 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
706 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
709 (SELECT player FROM players WHERE nick='Annkakri'),
712 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
713 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
715 (SELECT player FROM players WHERE nick='Annkakri'),
717 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
723 (SELECT player FROM players WHERE nick='Annkakri'),
725 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
731 (SELECT player FROM players WHERE nick='Annkakri'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
736 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
737 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
740 (SELECT player FROM players WHERE nick='Athena'),
743 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
746 (SELECT player FROM players WHERE nick='Athena'),
748 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
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='Athena'),
756 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
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='Athena'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
767 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
768 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
769 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
771 (SELECT player FROM players WHERE nick='Felz'),
774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
777 (SELECT player FROM players WHERE nick='Felz'),
779 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
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='Felz'),
787 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
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='Felz'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
798 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
799 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
802 (SELECT player FROM players WHERE nick='Ylini'),
805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
808 (SELECT player FROM players WHERE nick='Ylini'),
810 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
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='Ylini'),
818 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
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='Ylini'),
826 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
829 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
830 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
833 (SELECT player FROM players WHERE nick='Oliyzia'),
836 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
837 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
839 (SELECT player FROM players WHERE nick='Oliyzia'),
841 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
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='Oliyzia'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
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='Oliyzia'),
857 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
860 INSERT INTO groups (tournament, round, parallel) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
863 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
866 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
868 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
871 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
873 UPDATE rounds SET randomsongs=2 WHERE
874 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
876 UPDATE rounds SET chosensongs=1 WHERE
877 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
879 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Voffen' AS nick WHERE 'Voffen' NOT IN ( SELECT nick FROM players );
880 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
881 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
883 (SELECT player FROM players WHERE nick='Voffen'),
886 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
887 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
889 (SELECT player FROM players WHERE nick='Voffen'),
891 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
897 (SELECT player FROM players WHERE nick='Voffen'),
899 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
905 (SELECT player FROM players WHERE nick='Voffen'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
910 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
911 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
914 (SELECT player FROM players WHERE nick='Zackie'),
917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
918 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
920 (SELECT player FROM players WHERE nick='Zackie'),
922 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
928 (SELECT player FROM players WHERE nick='Zackie'),
930 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
936 (SELECT player FROM players WHERE nick='Zackie'),
938 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
941 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
942 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
945 (SELECT player FROM players WHERE nick='Zeila'),
948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
951 (SELECT player FROM players WHERE nick='Zeila'),
953 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='Zeila'),
961 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
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='Zeila'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
972 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
973 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
976 (SELECT player FROM players WHERE nick='Alexxz'),
979 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
980 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
982 (SELECT player FROM players WHERE nick='Alexxz'),
984 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='Alexxz'),
992 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
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='Alexxz'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1003 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1004 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1007 (SELECT player FROM players WHERE nick='Olemann'),
1010 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1013 (SELECT player FROM players WHERE nick='Olemann'),
1015 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='Olemann'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
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='Olemann'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1034 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1035 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1036 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1038 (SELECT player FROM players WHERE nick='RiChY'),
1041 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1044 (SELECT player FROM players WHERE nick='RiChY'),
1046 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='RiChY'),
1054 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
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='RiChY'),
1062 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1065 INSERT INTO groups (tournament, round, parallel) VALUES (
1066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1068 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
1073 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1076 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1078 UPDATE rounds SET randomsongs=2 WHERE
1079 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1081 UPDATE rounds SET chosensongs=1 WHERE
1082 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1084 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'SLC' AS nick WHERE 'SLC' NOT IN ( SELECT nick FROM players );
1085 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1088 (SELECT player FROM players WHERE nick='SLC'),
1091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1092 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1094 (SELECT player FROM players WHERE nick='SLC'),
1096 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1102 (SELECT player FROM players WHERE nick='SLC'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1110 (SELECT player FROM players WHERE nick='SLC'),
1112 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1115 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
1116 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1119 (SELECT player FROM players WHERE nick='Matti'),
1122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1125 (SELECT player FROM players WHERE nick='Matti'),
1127 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1133 (SELECT player FROM players WHERE nick='Matti'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1141 (SELECT player FROM players WHERE nick='Matti'),
1143 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1146 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
1147 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1150 (SELECT player FROM players WHERE nick='Hyper'),
1153 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1156 (SELECT player FROM players WHERE nick='Hyper'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
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='Hyper'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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='Hyper'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1177 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1178 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1181 (SELECT player FROM players WHERE nick='Mync'),
1184 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1185 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1187 (SELECT player FROM players WHERE nick='Mync'),
1189 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
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='Mync'),
1197 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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='Mync'),
1205 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1208 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1209 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1212 (SELECT player FROM players WHERE nick='Duckling'),
1215 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1218 (SELECT player FROM players WHERE nick='Duckling'),
1220 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
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='Duckling'),
1228 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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='Duckling'),
1236 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1239 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1243 (SELECT player FROM players WHERE nick='Haggar'),
1246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1249 (SELECT player FROM players WHERE nick='Haggar'),
1251 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
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='Haggar'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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='Haggar'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1270 INSERT INTO groups (tournament, round, parallel) VALUES (
1271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
1278 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1281 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1283 UPDATE rounds SET randomsongs=2 WHERE
1284 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1286 UPDATE rounds SET chosensongs=1 WHERE
1287 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1289 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dritago' AS nick WHERE 'Dritago' NOT IN ( SELECT nick FROM players );
1290 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1293 (SELECT player FROM players WHERE nick='Dritago'),
1296 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1299 (SELECT player FROM players WHERE nick='Dritago'),
1301 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1307 (SELECT player FROM players WHERE nick='Dritago'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1315 (SELECT player FROM players WHERE nick='Dritago'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1320 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
1321 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1324 (SELECT player FROM players WHERE nick='Pyro'),
1327 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1330 (SELECT player FROM players WHERE nick='Pyro'),
1332 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1335 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1338 (SELECT player FROM players WHERE nick='Pyro'),
1340 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1346 (SELECT player FROM players WHERE nick='Pyro'),
1348 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1351 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
1352 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1353 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1355 (SELECT player FROM players WHERE nick='Marilla'),
1358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1361 (SELECT player FROM players WHERE nick='Marilla'),
1363 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
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='Marilla'),
1371 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
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='Marilla'),
1379 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1382 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1384 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1386 (SELECT player FROM players WHERE nick='Pingo'),
1389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1392 (SELECT player FROM players WHERE nick='Pingo'),
1394 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
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='Pingo'),
1402 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
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='Pingo'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1413 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1414 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1417 (SELECT player FROM players WHERE nick='Bonzo'),
1420 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1421 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1423 (SELECT player FROM players WHERE nick='Bonzo'),
1425 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
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='Bonzo'),
1433 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
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='Bonzo'),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1444 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1448 (SELECT player FROM players WHERE nick='OJK'),
1451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1454 (SELECT player FROM players WHERE nick='OJK'),
1456 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
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='OJK'),
1464 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
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='OJK'),
1472 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1475 INSERT INTO groups (tournament, round, parallel) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1478 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1481 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1483 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1486 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1488 UPDATE rounds SET randomsongs=2 WHERE
1489 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1491 UPDATE rounds SET chosensongs=1 WHERE
1492 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
1495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1498 (SELECT player FROM players WHERE nick='Indy'),
1501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1504 (SELECT player FROM players WHERE nick='Indy'),
1506 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1512 (SELECT player FROM players WHERE nick='Indy'),
1514 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1517 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1520 (SELECT player FROM players WHERE nick='Indy'),
1522 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1525 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
1526 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1527 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1529 (SELECT player FROM players WHERE nick='Electron'),
1532 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1535 (SELECT player FROM players WHERE nick='Electron'),
1537 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1543 (SELECT player FROM players WHERE nick='Electron'),
1545 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1548 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1551 (SELECT player FROM players WHERE nick='Electron'),
1553 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1556 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
1557 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1558 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1560 (SELECT player FROM players WHERE nick='Bush'),
1563 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1564 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1566 (SELECT player FROM players WHERE nick='Bush'),
1568 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1574 (SELECT player FROM players WHERE nick='Bush'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1582 (SELECT player FROM players WHERE nick='Bush'),
1584 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1587 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1588 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1591 (SELECT player FROM players WHERE nick='Gogo'),
1594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1597 (SELECT player FROM players WHERE nick='Gogo'),
1599 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1605 (SELECT player FROM players WHERE nick='Gogo'),
1607 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1613 (SELECT player FROM players WHERE nick='Gogo'),
1615 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1618 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1619 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1622 (SELECT player FROM players WHERE nick='Smiph'),
1625 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1626 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1628 (SELECT player FROM players WHERE nick='Smiph'),
1630 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1633 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1636 (SELECT player FROM players WHERE nick='Smiph'),
1638 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1641 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1644 (SELECT player FROM players WHERE nick='Smiph'),
1646 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1649 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1650 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1653 (SELECT player FROM players WHERE nick='Snute'),
1656 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1659 (SELECT player FROM players WHERE nick='Snute'),
1661 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1665 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1667 (SELECT player FROM players WHERE nick='Snute'),
1669 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1672 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1675 (SELECT player FROM players WHERE nick='Snute'),
1677 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1680 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1685 INSERT INTO groups (tournament, round, parallel) VALUES (
1686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1688 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1691 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
1693 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1694 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1696 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1698 UPDATE rounds SET randomsongs=2 WHERE
1699 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1701 UPDATE rounds SET chosensongs=1 WHERE
1702 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1704 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1705 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1708 (SELECT player FROM players WHERE nick='v|per'),
1711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1714 (SELECT player FROM players WHERE nick='v|per'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1722 (SELECT player FROM players WHERE nick='v|per'),
1724 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1730 (SELECT player FROM players WHERE nick='v|per'),
1732 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1735 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1736 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1739 (SELECT player FROM players WHERE nick='Mync'),
1742 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1745 (SELECT player FROM players WHERE nick='Mync'),
1747 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1751 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1753 (SELECT player FROM players WHERE nick='Mync'),
1755 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1761 (SELECT player FROM players WHERE nick='Mync'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1766 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1767 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1770 (SELECT player FROM players WHERE nick='Duckling'),
1773 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1774 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1776 (SELECT player FROM players WHERE nick='Duckling'),
1778 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1781 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1782 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1784 (SELECT player FROM players WHERE nick='Duckling'),
1786 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1792 (SELECT player FROM players WHERE nick='Duckling'),
1794 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1797 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1798 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1799 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1801 (SELECT player FROM players WHERE nick='T|na'),
1804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1807 (SELECT player FROM players WHERE nick='T|na'),
1809 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
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='T|na'),
1817 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
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='T|na'),
1825 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1828 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1829 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1832 (SELECT player FROM players WHERE nick='Pingo'),
1835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1836 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1838 (SELECT player FROM players WHERE nick='Pingo'),
1840 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
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='Pingo'),
1848 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
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='Pingo'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1859 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1860 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1863 (SELECT player FROM players WHERE nick='Haggar'),
1866 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1867 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1869 (SELECT player FROM players WHERE nick='Haggar'),
1871 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
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='Haggar'),
1879 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
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='Haggar'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1890 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1894 (SELECT player FROM players WHERE nick='OJK'),
1897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1900 (SELECT player FROM players WHERE nick='OJK'),
1902 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
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='OJK'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
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='OJK'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1921 INSERT INTO groups (tournament, round, parallel) VALUES (
1922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1924 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1925 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1927 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1929 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1930 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1932 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
1934 UPDATE rounds SET randomsongs=2 WHERE
1935 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1937 UPDATE rounds SET chosensongs=1 WHERE
1938 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1940 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
1941 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1944 (SELECT player FROM players WHERE nick='Alexxz'),
1947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1948 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1950 (SELECT player FROM players WHERE nick='Alexxz'),
1952 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1955 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1956 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1958 (SELECT player FROM players WHERE nick='Alexxz'),
1960 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1963 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1964 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1966 (SELECT player FROM players WHERE nick='Alexxz'),
1968 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1971 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1972 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1975 (SELECT player FROM players WHERE nick='Smiph'),
1978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1981 (SELECT player FROM players WHERE nick='Smiph'),
1983 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1989 (SELECT player FROM players WHERE nick='Smiph'),
1991 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1997 (SELECT player FROM players WHERE nick='Smiph'),
1999 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2002 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
2003 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2006 (SELECT player FROM players WHERE nick='Ylini'),
2009 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2010 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2012 (SELECT player FROM players WHERE nick='Ylini'),
2014 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2017 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2018 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2020 (SELECT player FROM players WHERE nick='Ylini'),
2022 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2028 (SELECT player FROM players WHERE nick='Ylini'),
2030 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2033 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
2034 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2037 (SELECT player FROM players WHERE nick='Gogo'),
2040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2041 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2043 (SELECT player FROM players WHERE nick='Gogo'),
2045 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
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='Gogo'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
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='Gogo'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2064 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2065 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2068 (SELECT player FROM players WHERE nick='Oliyzia'),
2071 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2072 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2074 (SELECT player FROM players WHERE nick='Oliyzia'),
2076 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
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='Oliyzia'),
2084 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
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='Oliyzia'),
2092 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2095 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2096 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2099 (SELECT player FROM players WHERE nick='RiChY'),
2102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2105 (SELECT player FROM players WHERE nick='RiChY'),
2107 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
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='RiChY'),
2115 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
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='RiChY'),
2123 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2127 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2130 (SELECT player FROM players WHERE nick='Snute'),
2133 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2136 (SELECT player FROM players WHERE nick='Snute'),
2138 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
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='Snute'),
2146 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
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='Snute'),
2154 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2157 INSERT INTO groups (tournament, round, parallel) VALUES (
2158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2160 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2163 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2165 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2168 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
2170 UPDATE rounds SET randomsongs=2 WHERE
2171 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2173 UPDATE rounds SET chosensongs=1 WHERE
2174 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2176 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
2177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2180 (SELECT player FROM players WHERE nick='Felz'),
2183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2186 (SELECT player FROM players WHERE nick='Felz'),
2188 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2191 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2194 (SELECT player FROM players WHERE nick='Felz'),
2196 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2199 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2202 (SELECT player FROM players WHERE nick='Felz'),
2204 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2207 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
2208 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2211 (SELECT player FROM players WHERE nick='Andeplane'),
2214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2217 (SELECT player FROM players WHERE nick='Andeplane'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2225 (SELECT player FROM players WHERE nick='Andeplane'),
2227 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2233 (SELECT player FROM players WHERE nick='Andeplane'),
2235 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2238 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2239 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2242 (SELECT player FROM players WHERE nick='Bonzo'),
2245 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2248 (SELECT player FROM players WHERE nick='Bonzo'),
2250 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2253 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2256 (SELECT player FROM players WHERE nick='Bonzo'),
2258 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2261 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2264 (SELECT player FROM players WHERE nick='Bonzo'),
2266 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2269 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
2270 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2273 (SELECT player FROM players WHERE nick='Daniil'),
2276 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2279 (SELECT player FROM players WHERE nick='Daniil'),
2281 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
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='Daniil'),
2289 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere 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='Daniil'),
2297 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2300 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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='Olemann'),
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='Olemann'),
2312 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
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='Olemann'),
2320 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2323 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2324 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2326 (SELECT player FROM players WHERE nick='Olemann'),
2328 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2331 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2332 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2335 (SELECT player FROM players WHERE nick='Snofox'),
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='Snofox'),
2343 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2347 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2349 (SELECT player FROM players WHERE nick='Snofox'),
2351 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2355 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2357 (SELECT player FROM players WHERE nick='Snofox'),
2359 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2362 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2363 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2366 (SELECT player FROM players WHERE nick='Nameless'),
2369 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2372 (SELECT player FROM players WHERE nick='Nameless'),
2374 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2377 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2378 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2380 (SELECT player FROM players WHERE nick='Nameless'),
2382 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2388 (SELECT player FROM players WHERE nick='Nameless'),
2390 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2393 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2398 INSERT INTO groups (tournament, round, parallel) VALUES (
2399 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2401 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2404 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2406 UPDATE rounds SET randomsongs=1 WHERE
2407 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2409 UPDATE rounds SET chosensongs=1 WHERE
2410 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2412 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2413 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2416 (SELECT player FROM players WHERE nick='RiChY'),
2419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2422 (SELECT player FROM players WHERE nick='RiChY'),
2424 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2427 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2430 (SELECT player FROM players WHERE nick='RiChY'),
2432 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2435 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2436 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2439 (SELECT player FROM players WHERE nick='Snofox'),
2442 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2443 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2445 (SELECT player FROM players WHERE nick='Snofox'),
2447 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2450 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2451 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2453 (SELECT player FROM players WHERE nick='Snofox'),
2455 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2458 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
2459 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2462 (SELECT player FROM players WHERE nick='Pingo'),
2465 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2466 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2468 (SELECT player FROM players WHERE nick='Pingo'),
2470 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2474 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2476 (SELECT player FROM players WHERE nick='Pingo'),
2478 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2481 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2485 (SELECT player FROM players WHERE nick='OJK'),
2488 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2489 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2491 (SELECT player FROM players WHERE nick='OJK'),
2493 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2499 (SELECT player FROM players WHERE nick='OJK'),
2501 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2504 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2505 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2508 (SELECT player FROM players WHERE nick='Oliyzia'),
2511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2512 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2514 (SELECT player FROM players WHERE nick='Oliyzia'),
2516 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2522 (SELECT player FROM players WHERE nick='Oliyzia'),
2524 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2527 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2528 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2531 (SELECT player FROM players WHERE nick='Bonzo'),
2534 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2535 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2537 (SELECT player FROM players WHERE nick='Bonzo'),
2539 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2545 (SELECT player FROM players WHERE nick='Bonzo'),
2547 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2554 (SELECT player FROM players WHERE nick='Snute'),
2557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2558 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2560 (SELECT player FROM players WHERE nick='Snute'),
2562 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2565 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2566 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2568 (SELECT player FROM players WHERE nick='Snute'),
2570 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2573 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2575 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2577 (SELECT player FROM players WHERE nick='Nameless'),
2580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2583 (SELECT player FROM players WHERE nick='Nameless'),
2585 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2591 (SELECT player FROM players WHERE nick='Nameless'),
2593 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2596 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2597 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2600 (SELECT player FROM players WHERE nick='Haggar'),
2603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2604 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2606 (SELECT player FROM players WHERE nick='Haggar'),
2608 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2611 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2612 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2614 (SELECT player FROM players WHERE nick='Haggar'),
2616 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2619 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2624 INSERT INTO groups (tournament, round, parallel) VALUES (
2625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2627 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2630 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
2632 UPDATE rounds SET randomsongs=1 WHERE
2633 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2635 UPDATE rounds SET chosensongs=1 WHERE
2636 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2638 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2639 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2640 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2642 (SELECT player FROM players WHERE nick='Nameless'),
2645 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2646 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2648 (SELECT player FROM players WHERE nick='Nameless'),
2650 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2653 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2654 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2656 (SELECT player FROM players WHERE nick='Nameless'),
2658 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2661 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2662 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2665 (SELECT player FROM players WHERE nick='RiChY'),
2668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2671 (SELECT player FROM players WHERE nick='RiChY'),
2673 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2676 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2679 (SELECT player FROM players WHERE nick='RiChY'),
2681 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2684 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2685 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2688 (SELECT player FROM players WHERE nick='Oliyzia'),
2691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2692 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2694 (SELECT player FROM players WHERE nick='Oliyzia'),
2696 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2702 (SELECT player FROM players WHERE nick='Oliyzia'),
2704 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2707 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2708 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2711 (SELECT player FROM players WHERE nick='Snofox'),
2714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2717 (SELECT player FROM players WHERE nick='Snofox'),
2719 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2725 (SELECT player FROM players WHERE nick='Snofox'),
2727 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2730 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2731 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2732 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2734 (SELECT player FROM players WHERE nick='Snute'),
2737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2740 (SELECT player FROM players WHERE nick='Snute'),
2742 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2748 (SELECT player FROM players WHERE nick='Snute'),
2750 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2753 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2754 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2757 (SELECT player FROM players WHERE nick='Haggar'),
2760 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2761 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2763 (SELECT player FROM players WHERE nick='Haggar'),
2765 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2768 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2769 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2771 (SELECT player FROM players WHERE nick='Haggar'),
2773 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2776 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2777 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2780 (SELECT player FROM players WHERE nick='Bonzo'),
2783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2786 (SELECT player FROM players WHERE nick='Bonzo'),
2788 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2794 (SELECT player FROM players WHERE nick='Bonzo'),
2796 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2799 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2801 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2804 INSERT INTO groups (tournament, round, parallel) VALUES (
2805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2807 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2810 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
2812 UPDATE rounds SET randomsongs=1 WHERE
2813 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2815 UPDATE rounds SET chosensongs=1 WHERE
2816 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2818 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2819 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2822 (SELECT player FROM players WHERE nick='Bonzo'),
2825 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2828 (SELECT player FROM players WHERE nick='Bonzo'),
2830 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2833 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2834 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2836 (SELECT player FROM players WHERE nick='Bonzo'),
2838 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2841 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2842 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2843 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2845 (SELECT player FROM players WHERE nick='Nameless'),
2848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2851 (SELECT player FROM players WHERE nick='Nameless'),
2853 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2857 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2859 (SELECT player FROM players WHERE nick='Nameless'),
2861 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2864 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2865 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2866 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2868 (SELECT player FROM players WHERE nick='Snofox'),
2871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2874 (SELECT player FROM players WHERE nick='Snofox'),
2876 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2880 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2882 (SELECT player FROM players WHERE nick='Snofox'),
2884 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2889 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2891 (SELECT player FROM players WHERE nick='Haggar'),
2894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2897 (SELECT player FROM players WHERE nick='Haggar'),
2899 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2905 (SELECT player FROM players WHERE nick='Haggar'),
2907 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2910 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2911 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2914 (SELECT player FROM players WHERE nick='Snute'),
2917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2918 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2920 (SELECT player FROM players WHERE nick='Snute'),
2922 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2926 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2928 (SELECT player FROM players WHERE nick='Snute'),
2930 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2933 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2938 INSERT INTO groups (tournament, round, parallel) VALUES (
2939 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2941 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2944 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
2946 UPDATE rounds SET randomsongs=1 WHERE
2947 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2949 UPDATE rounds SET chosensongs=1 WHERE
2950 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2952 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2953 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2954 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2956 (SELECT player FROM players WHERE nick='Snofox'),
2959 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2962 (SELECT player FROM players WHERE nick='Snofox'),
2964 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2967 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2968 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2970 (SELECT player FROM players WHERE nick='Snofox'),
2972 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2975 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2976 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2979 (SELECT player FROM players WHERE nick='Haggar'),
2982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2985 (SELECT player FROM players WHERE nick='Haggar'),
2987 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2990 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2991 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2993 (SELECT player FROM players WHERE nick='Haggar'),
2995 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2998 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2999 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3000 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3002 (SELECT player FROM players WHERE nick='Nameless'),
3005 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3006 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3008 (SELECT player FROM players WHERE nick='Nameless'),
3010 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3013 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3014 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3016 (SELECT player FROM players WHERE nick='Nameless'),
3018 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
3021 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
3022 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3025 (SELECT player FROM players WHERE nick='Snute'),
3028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3029 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3031 (SELECT player FROM players WHERE nick='Snute'),
3033 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3036 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3039 (SELECT player FROM players WHERE nick='Snute'),
3041 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
3044 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
3046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3049 INSERT INTO groups (tournament, round, parallel) VALUES (
3050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3052 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3053 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3055 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
3057 UPDATE rounds SET randomsongs=1 WHERE
3058 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3060 UPDATE rounds SET chosensongs=1 WHERE
3061 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3063 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
3064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3067 (SELECT player FROM players WHERE nick='Nameless'),
3070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3071 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3073 (SELECT player FROM players WHERE nick='Nameless'),
3075 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
3078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3079 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3081 (SELECT player FROM players WHERE nick='Nameless'),
3083 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
3086 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
3087 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3090 (SELECT player FROM players WHERE nick='Haggar'),
3093 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3096 (SELECT player FROM players WHERE nick='Haggar'),
3098 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
3101 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3102 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3104 (SELECT player FROM players WHERE nick='Haggar'),
3106 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
3109 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
3110 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3113 (SELECT player FROM players WHERE nick='Snute'),
3116 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3119 (SELECT player FROM players WHERE nick='Snute'),
3121 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
3124 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3125 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3127 (SELECT player FROM players WHERE nick='Snute'),
3129 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3132 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
3134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3137 INSERT INTO groups (tournament, round, parallel) VALUES (
3138 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3140 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3143 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
3145 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3148 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
3150 UPDATE rounds SET randomsongs=2 WHERE
3151 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3153 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
3154 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3155 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3157 (SELECT player FROM players WHERE nick='Haggar'),
3160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3163 (SELECT player FROM players WHERE nick='Haggar'),
3165 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
3168 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3169 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3171 (SELECT player FROM players WHERE nick='Haggar'),
3173 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
3176 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
3177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3180 (SELECT player FROM players WHERE nick='Snute'),
3183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3186 (SELECT player FROM players WHERE nick='Snute'),
3188 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
3191 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3194 (SELECT player FROM players WHERE nick='Snute'),
3196 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),