2 INSERT INTO tournaments
3 (season, name, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE name='Norway'),
7 'Tønsberg - Sjøsenteret bowling',
9 (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
28 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Crienexzy' AS nick WHERE 'Crienexzy' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
40 (SELECT player FROM players WHERE nick='Crienexzy'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
46 (SELECT player FROM players WHERE nick='Crienexzy'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
53 (SELECT player FROM players WHERE nick='Crienexzy'),
54 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
57 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
60 (SELECT player FROM players WHERE nick='Crienexzy'),
61 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
64 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tove' AS nick WHERE 'Tove' NOT IN ( SELECT nick FROM players );
65 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
66 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
68 (SELECT player FROM players WHERE nick='Tove'),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
74 (SELECT player FROM players WHERE nick='Tove'),
75 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
81 (SELECT player FROM players WHERE nick='Tove'),
82 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
88 (SELECT player FROM players WHERE nick='Tove'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
93 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
94 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
96 (SELECT player FROM players WHERE nick='JonAnders'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
102 (SELECT player FROM players WHERE nick='JonAnders'),
103 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
109 (SELECT player FROM players WHERE nick='JonAnders'),
110 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
116 (SELECT player FROM players WHERE nick='JonAnders'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
124 (SELECT player FROM players WHERE nick='Andeplane'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
130 (SELECT player FROM players WHERE nick='Andeplane'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
137 (SELECT player FROM players WHERE nick='Andeplane'),
138 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
144 (SELECT player FROM players WHERE nick='Andeplane'),
145 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
152 (SELECT player FROM players WHERE nick='Matsi'),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
158 (SELECT player FROM players WHERE nick='Matsi'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
165 (SELECT player FROM players WHERE nick='Matsi'),
166 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
172 (SELECT player FROM players WHERE nick='Matsi'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
176 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
180 (SELECT player FROM players WHERE nick='Snofox'),
183 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
186 (SELECT player FROM players WHERE nick='Snofox'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
190 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
191 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
193 (SELECT player FROM players WHERE nick='Snofox'),
194 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
197 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
198 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
200 (SELECT player FROM players WHERE nick='Snofox'),
201 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
205 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
206 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
208 (SELECT player FROM players WHERE nick='T|na'),
211 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
212 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
214 (SELECT player FROM players WHERE nick='T|na'),
215 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
218 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
219 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
221 (SELECT player FROM players WHERE nick='T|na'),
222 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
225 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
228 (SELECT player FROM players WHERE nick='T|na'),
229 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
232 INSERT INTO groups (tournament, round, parallel) VALUES (
233 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
235 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
236 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
238 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
240 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
241 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
243 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
245 UPDATE rounds SET randomsongs=2 WHERE
246 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
248 UPDATE rounds SET chosensongs=1 WHERE
249 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'uSimen' AS nick WHERE 'uSimen' NOT IN ( SELECT nick FROM players );
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
255 (SELECT player FROM players WHERE nick='uSimen'),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
261 (SELECT player FROM players WHERE nick='uSimen'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
268 (SELECT player FROM players WHERE nick='uSimen'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
275 (SELECT player FROM players WHERE nick='uSimen'),
276 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
283 (SELECT player FROM players WHERE nick='Pfxp'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
289 (SELECT player FROM players WHERE nick='Pfxp'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
296 (SELECT player FROM players WHERE nick='Pfxp'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
303 (SELECT player FROM players WHERE nick='Pfxp'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
311 (SELECT player FROM players WHERE nick='Glock'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
317 (SELECT player FROM players WHERE nick='Glock'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
324 (SELECT player FROM players WHERE nick='Glock'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
331 (SELECT player FROM players WHERE nick='Glock'),
332 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
335 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
339 (SELECT player FROM players WHERE nick='Eruanna'),
342 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
345 (SELECT player FROM players WHERE nick='Eruanna'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
349 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
352 (SELECT player FROM players WHERE nick='Eruanna'),
353 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
356 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
357 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
359 (SELECT player FROM players WHERE nick='Eruanna'),
360 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
363 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
367 (SELECT player FROM players WHERE nick='v|per'),
370 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
373 (SELECT player FROM players WHERE nick='v|per'),
374 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
377 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
378 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
380 (SELECT player FROM players WHERE nick='v|per'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
384 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
387 (SELECT player FROM players WHERE nick='v|per'),
388 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
391 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
392 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
393 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
395 (SELECT player FROM players WHERE nick='Daniil'),
398 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
399 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
401 (SELECT player FROM players WHERE nick='Daniil'),
402 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
405 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
406 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
408 (SELECT player FROM players WHERE nick='Daniil'),
409 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
412 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
413 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
415 (SELECT player FROM players WHERE nick='Daniil'),
416 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
419 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
420 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
421 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
423 (SELECT player FROM players WHERE nick='Nameless'),
426 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
427 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
429 (SELECT player FROM players WHERE nick='Nameless'),
430 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
433 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
434 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
436 (SELECT player FROM players WHERE nick='Nameless'),
437 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
440 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
443 (SELECT player FROM players WHERE nick='Nameless'),
444 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
447 INSERT INTO groups (tournament, round, parallel) VALUES (
448 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
450 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
451 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
453 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
455 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
456 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
460 UPDATE rounds SET randomsongs=2 WHERE
461 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
463 UPDATE rounds SET chosensongs=1 WHERE
464 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick WHERE 'Benny' NOT IN ( SELECT nick FROM players );
467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
470 (SELECT player FROM players WHERE nick='Benny'),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
476 (SELECT player FROM players WHERE nick='Benny'),
477 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
483 (SELECT player FROM players WHERE nick='Benny'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
490 (SELECT player FROM players WHERE nick='Benny'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Volstad' AS nick WHERE 'Volstad' NOT IN ( SELECT nick FROM players );
495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
498 (SELECT player FROM players WHERE nick='Volstad'),
501 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
504 (SELECT player FROM players WHERE nick='Volstad'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
508 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
511 (SELECT player FROM players WHERE nick='Volstad'),
512 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
515 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
518 (SELECT player FROM players WHERE nick='Volstad'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
522 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
526 (SELECT player FROM players WHERE nick='Annkakri'),
529 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
532 (SELECT player FROM players WHERE nick='Annkakri'),
533 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
536 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
537 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
539 (SELECT player FROM players WHERE nick='Annkakri'),
540 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
543 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
544 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
546 (SELECT player FROM players WHERE nick='Annkakri'),
547 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
554 (SELECT player FROM players WHERE nick='Athena'),
557 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
560 (SELECT player FROM players WHERE nick='Athena'),
561 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
564 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
565 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
567 (SELECT player FROM players WHERE nick='Athena'),
568 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
571 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
574 (SELECT player FROM players WHERE nick='Athena'),
575 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
578 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
579 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
580 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
582 (SELECT player FROM players WHERE nick='Felz'),
585 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
586 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
588 (SELECT player FROM players WHERE nick='Felz'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
592 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
593 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
595 (SELECT player FROM players WHERE nick='Felz'),
596 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
599 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
600 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
602 (SELECT player FROM players WHERE nick='Felz'),
603 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
606 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
607 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
608 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
610 (SELECT player FROM players WHERE nick='Ylini'),
613 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
614 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
616 (SELECT player FROM players WHERE nick='Ylini'),
617 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
620 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
621 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
623 (SELECT player FROM players WHERE nick='Ylini'),
624 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
627 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
630 (SELECT player FROM players WHERE nick='Ylini'),
631 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
634 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
635 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
636 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
638 (SELECT player FROM players WHERE nick='Oliyzia'),
641 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
642 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
644 (SELECT player FROM players WHERE nick='Oliyzia'),
645 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
648 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
649 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
651 (SELECT player FROM players WHERE nick='Oliyzia'),
652 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
655 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
656 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
658 (SELECT player FROM players WHERE nick='Oliyzia'),
659 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
662 INSERT INTO groups (tournament, round, parallel) VALUES (
663 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
665 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
668 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
670 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
671 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
673 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
675 UPDATE rounds SET randomsongs=2 WHERE
676 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
678 UPDATE rounds SET chosensongs=1 WHERE
679 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Voffen' AS nick WHERE 'Voffen' NOT IN ( SELECT nick FROM players );
682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
685 (SELECT player FROM players WHERE nick='Voffen'),
688 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
691 (SELECT player FROM players WHERE nick='Voffen'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
695 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
698 (SELECT player FROM players WHERE nick='Voffen'),
699 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
702 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
703 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
705 (SELECT player FROM players WHERE nick='Voffen'),
706 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
709 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
710 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
711 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
713 (SELECT player FROM players WHERE nick='Zackie'),
716 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
719 (SELECT player FROM players WHERE nick='Zackie'),
720 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
723 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
726 (SELECT player FROM players WHERE nick='Zackie'),
727 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
730 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
731 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
733 (SELECT player FROM players WHERE nick='Zackie'),
734 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
737 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
738 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
741 (SELECT player FROM players WHERE nick='Zeila'),
744 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
747 (SELECT player FROM players WHERE nick='Zeila'),
748 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
751 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
754 (SELECT player FROM players WHERE nick='Zeila'),
755 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
758 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
759 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
761 (SELECT player FROM players WHERE nick='Zeila'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
765 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
766 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
769 (SELECT player FROM players WHERE nick='Alexxz'),
772 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
773 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
775 (SELECT player FROM players WHERE nick='Alexxz'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
779 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
782 (SELECT player FROM players WHERE nick='Alexxz'),
783 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
786 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
787 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
789 (SELECT player FROM players WHERE nick='Alexxz'),
790 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
793 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
797 (SELECT player FROM players WHERE nick='Olemann'),
800 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
801 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
803 (SELECT player FROM players WHERE nick='Olemann'),
804 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
807 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
808 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
810 (SELECT player FROM players WHERE nick='Olemann'),
811 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
814 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
815 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
817 (SELECT player FROM players WHERE nick='Olemann'),
818 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
821 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
822 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
823 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
825 (SELECT player FROM players WHERE nick='RiChY'),
828 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
829 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
831 (SELECT player FROM players WHERE nick='RiChY'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
835 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
836 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
838 (SELECT player FROM players WHERE nick='RiChY'),
839 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
842 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
843 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
845 (SELECT player FROM players WHERE nick='RiChY'),
846 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
849 INSERT INTO groups (tournament, round, parallel) VALUES (
850 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
852 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
853 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
855 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
857 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
858 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
860 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
862 UPDATE rounds SET randomsongs=2 WHERE
863 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
865 UPDATE rounds SET chosensongs=1 WHERE
866 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
868 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'SLC' AS nick WHERE 'SLC' NOT IN ( SELECT nick FROM players );
869 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
872 (SELECT player FROM players WHERE nick='SLC'),
875 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
878 (SELECT player FROM players WHERE nick='SLC'),
879 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
882 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
885 (SELECT player FROM players WHERE nick='SLC'),
886 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
889 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
890 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
892 (SELECT player FROM players WHERE nick='SLC'),
893 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
896 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
900 (SELECT player FROM players WHERE nick='Matti'),
903 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
904 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
906 (SELECT player FROM players WHERE nick='Matti'),
907 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
910 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
913 (SELECT player FROM players WHERE nick='Matti'),
914 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
917 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
918 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
920 (SELECT player FROM players WHERE nick='Matti'),
921 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
924 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
925 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
928 (SELECT player FROM players WHERE nick='Hyper'),
931 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
932 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
934 (SELECT player FROM players WHERE nick='Hyper'),
935 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
938 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
939 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
941 (SELECT player FROM players WHERE nick='Hyper'),
942 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
945 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
946 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
948 (SELECT player FROM players WHERE nick='Hyper'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
952 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
953 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
956 (SELECT player FROM players WHERE nick='Mync'),
959 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
960 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
962 (SELECT player FROM players WHERE nick='Mync'),
963 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
966 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
969 (SELECT player FROM players WHERE nick='Mync'),
970 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
973 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
974 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
976 (SELECT player FROM players WHERE nick='Mync'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
980 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
982 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
984 (SELECT player FROM players WHERE nick='Duckling'),
987 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
988 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
990 (SELECT player FROM players WHERE nick='Duckling'),
991 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
994 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
997 (SELECT player FROM players WHERE nick='Duckling'),
998 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1001 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1002 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1004 (SELECT player FROM players WHERE nick='Duckling'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1008 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1009 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1010 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1012 (SELECT player FROM players WHERE nick='Haggar'),
1015 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1016 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1018 (SELECT player FROM players WHERE nick='Haggar'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1022 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1023 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1025 (SELECT player FROM players WHERE nick='Haggar'),
1026 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1029 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1030 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1032 (SELECT player FROM players WHERE nick='Haggar'),
1033 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1036 INSERT INTO groups (tournament, round, parallel) VALUES (
1037 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1039 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1040 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
1044 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1045 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1049 UPDATE rounds SET randomsongs=2 WHERE
1050 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1052 UPDATE rounds SET chosensongs=1 WHERE
1053 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1055 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dritago' AS nick WHERE 'Dritago' NOT IN ( SELECT nick FROM players );
1056 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1059 (SELECT player FROM players WHERE nick='Dritago'),
1062 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1063 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1065 (SELECT player FROM players WHERE nick='Dritago'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1069 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1070 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1072 (SELECT player FROM players WHERE nick='Dritago'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1076 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1079 (SELECT player FROM players WHERE nick='Dritago'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1083 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
1084 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1087 (SELECT player FROM players WHERE nick='Pyro'),
1090 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1091 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1093 (SELECT player FROM players WHERE nick='Pyro'),
1094 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1097 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1098 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1100 (SELECT player FROM players WHERE nick='Pyro'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1104 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1107 (SELECT player FROM players WHERE nick='Pyro'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1111 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
1112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1115 (SELECT player FROM players WHERE nick='Marilla'),
1118 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1121 (SELECT player FROM players WHERE nick='Marilla'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1125 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1128 (SELECT player FROM players WHERE nick='Marilla'),
1129 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1132 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1133 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1135 (SELECT player FROM players WHERE nick='Marilla'),
1136 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1139 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1140 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1143 (SELECT player FROM players WHERE nick='Pingo'),
1146 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1149 (SELECT player FROM players WHERE nick='Pingo'),
1150 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1153 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1156 (SELECT player FROM players WHERE nick='Pingo'),
1157 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1160 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1161 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1163 (SELECT player FROM players WHERE nick='Pingo'),
1164 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1167 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1171 (SELECT player FROM players WHERE nick='Bonzo'),
1174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1177 (SELECT player FROM players WHERE nick='Bonzo'),
1178 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1181 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1184 (SELECT player FROM players WHERE nick='Bonzo'),
1185 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1191 (SELECT player FROM players WHERE nick='Bonzo'),
1192 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1195 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1199 (SELECT player FROM players WHERE nick='OJK'),
1202 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1205 (SELECT player FROM players WHERE nick='OJK'),
1206 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1212 (SELECT player FROM players WHERE nick='OJK'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1219 (SELECT player FROM players WHERE nick='OJK'),
1220 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1223 INSERT INTO groups (tournament, round, parallel) VALUES (
1224 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1226 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1227 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1231 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1232 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1234 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1236 UPDATE rounds SET randomsongs=2 WHERE
1237 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1239 UPDATE rounds SET chosensongs=1 WHERE
1240 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1242 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
1243 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1244 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1246 (SELECT player FROM players WHERE nick='Indy'),
1249 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1250 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1252 (SELECT player FROM players WHERE nick='Indy'),
1253 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1256 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1257 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1259 (SELECT player FROM players WHERE nick='Indy'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1263 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1264 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1266 (SELECT player FROM players WHERE nick='Indy'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1270 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
1271 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1272 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1274 (SELECT player FROM players WHERE nick='Electron'),
1277 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1278 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1280 (SELECT player FROM players WHERE nick='Electron'),
1281 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1284 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1285 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1287 (SELECT player FROM players WHERE nick='Electron'),
1288 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1291 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1294 (SELECT player FROM players WHERE nick='Electron'),
1295 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1298 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
1299 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1300 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1302 (SELECT player FROM players WHERE nick='Bush'),
1305 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1306 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1308 (SELECT player FROM players WHERE nick='Bush'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1312 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1315 (SELECT player FROM players WHERE nick='Bush'),
1316 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1319 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1322 (SELECT player FROM players WHERE nick='Bush'),
1323 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1327 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1328 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1330 (SELECT player FROM players WHERE nick='Gogo'),
1333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1336 (SELECT player FROM players WHERE nick='Gogo'),
1337 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1343 (SELECT player FROM players WHERE nick='Gogo'),
1344 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1347 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1348 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1350 (SELECT player FROM players WHERE nick='Gogo'),
1351 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1354 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1358 (SELECT player FROM players WHERE nick='Smiph'),
1361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1364 (SELECT player FROM players WHERE nick='Smiph'),
1365 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1368 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1371 (SELECT player FROM players WHERE nick='Smiph'),
1372 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1378 (SELECT player FROM players WHERE nick='Smiph'),
1379 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1382 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1386 (SELECT player FROM players WHERE nick='Snute'),
1389 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1392 (SELECT player FROM players WHERE nick='Snute'),
1393 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1399 (SELECT player FROM players WHERE nick='Snute'),
1400 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1406 (SELECT player FROM players WHERE nick='Snute'),
1407 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1410 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1415 INSERT INTO groups (tournament, round, parallel) VALUES (
1416 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1418 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1419 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1421 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
1423 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1424 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1428 UPDATE rounds SET randomsongs=2 WHERE
1429 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1431 UPDATE rounds SET chosensongs=1 WHERE
1432 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1434 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1435 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1438 (SELECT player FROM players WHERE nick='v|per'),
1441 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1444 (SELECT player FROM players WHERE nick='v|per'),
1445 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1448 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1449 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1451 (SELECT player FROM players WHERE nick='v|per'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1455 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1458 (SELECT player FROM players WHERE nick='v|per'),
1459 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1462 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1464 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1466 (SELECT player FROM players WHERE nick='Mync'),
1469 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1470 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1472 (SELECT player FROM players WHERE nick='Mync'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1476 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1477 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1479 (SELECT player FROM players WHERE nick='Mync'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1483 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1486 (SELECT player FROM players WHERE nick='Mync'),
1487 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1490 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1491 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1494 (SELECT player FROM players WHERE nick='Duckling'),
1497 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1498 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1500 (SELECT player FROM players WHERE nick='Duckling'),
1501 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1504 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1505 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1507 (SELECT player FROM players WHERE nick='Duckling'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1511 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1512 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1514 (SELECT player FROM players WHERE nick='Duckling'),
1515 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1518 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1519 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1520 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1522 (SELECT player FROM players WHERE nick='T|na'),
1525 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1526 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1528 (SELECT player FROM players WHERE nick='T|na'),
1529 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1532 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1535 (SELECT player FROM players WHERE nick='T|na'),
1536 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1539 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1542 (SELECT player FROM players WHERE nick='T|na'),
1543 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1546 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1547 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1548 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1550 (SELECT player FROM players WHERE nick='Pingo'),
1553 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1556 (SELECT player FROM players WHERE nick='Pingo'),
1557 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1560 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1563 (SELECT player FROM players WHERE nick='Pingo'),
1564 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1567 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1570 (SELECT player FROM players WHERE nick='Pingo'),
1571 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1574 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1575 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1576 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1578 (SELECT player FROM players WHERE nick='Haggar'),
1581 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1584 (SELECT player FROM players WHERE nick='Haggar'),
1585 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1588 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1591 (SELECT player FROM players WHERE nick='Haggar'),
1592 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1595 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1596 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1598 (SELECT player FROM players WHERE nick='Haggar'),
1599 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1602 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1603 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1604 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1606 (SELECT player FROM players WHERE nick='OJK'),
1609 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1612 (SELECT player FROM players WHERE nick='OJK'),
1613 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1616 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1617 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1619 (SELECT player FROM players WHERE nick='OJK'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1623 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1626 (SELECT player FROM players WHERE nick='OJK'),
1627 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1630 INSERT INTO groups (tournament, round, parallel) VALUES (
1631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1633 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1634 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1636 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1638 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1641 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
1643 UPDATE rounds SET randomsongs=2 WHERE
1644 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1646 UPDATE rounds SET chosensongs=1 WHERE
1647 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1649 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
1650 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1651 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1653 (SELECT player FROM players WHERE nick='Alexxz'),
1656 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1657 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1659 (SELECT player FROM players WHERE nick='Alexxz'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1663 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1666 (SELECT player FROM players WHERE nick='Alexxz'),
1667 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1670 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1671 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1673 (SELECT player FROM players WHERE nick='Alexxz'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1677 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1678 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1679 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1681 (SELECT player FROM players WHERE nick='Smiph'),
1684 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1685 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1687 (SELECT player FROM players WHERE nick='Smiph'),
1688 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1691 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1694 (SELECT player FROM players WHERE nick='Smiph'),
1695 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1698 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1699 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1701 (SELECT player FROM players WHERE nick='Smiph'),
1702 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1705 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1706 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1707 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1709 (SELECT player FROM players WHERE nick='Ylini'),
1712 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1715 (SELECT player FROM players WHERE nick='Ylini'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1719 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1722 (SELECT player FROM players WHERE nick='Ylini'),
1723 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1726 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1727 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1729 (SELECT player FROM players WHERE nick='Ylini'),
1730 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1733 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1735 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1737 (SELECT player FROM players WHERE nick='Gogo'),
1740 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1741 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1743 (SELECT player FROM players WHERE nick='Gogo'),
1744 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1747 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1750 (SELECT player FROM players WHERE nick='Gogo'),
1751 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1754 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1757 (SELECT player FROM players WHERE nick='Gogo'),
1758 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1761 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1762 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1763 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1765 (SELECT player FROM players WHERE nick='Oliyzia'),
1768 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1771 (SELECT player FROM players WHERE nick='Oliyzia'),
1772 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1775 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1778 (SELECT player FROM players WHERE nick='Oliyzia'),
1779 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1782 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1783 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1785 (SELECT player FROM players WHERE nick='Oliyzia'),
1786 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1789 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1790 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1791 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1793 (SELECT player FROM players WHERE nick='RiChY'),
1796 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1799 (SELECT player FROM players WHERE nick='RiChY'),
1800 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1803 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1804 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1806 (SELECT player FROM players WHERE nick='RiChY'),
1807 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1810 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1811 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1813 (SELECT player FROM players WHERE nick='RiChY'),
1814 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1817 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1818 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1819 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1821 (SELECT player FROM players WHERE nick='Snute'),
1824 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1825 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1827 (SELECT player FROM players WHERE nick='Snute'),
1828 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1831 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1832 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1834 (SELECT player FROM players WHERE nick='Snute'),
1835 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1838 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1841 (SELECT player FROM players WHERE nick='Snute'),
1842 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1845 INSERT INTO groups (tournament, round, parallel) VALUES (
1846 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1848 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1849 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1851 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1853 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1854 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
1858 UPDATE rounds SET randomsongs=2 WHERE
1859 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1861 UPDATE rounds SET chosensongs=1 WHERE
1862 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
1864 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
1865 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1866 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1868 (SELECT player FROM players WHERE nick='Felz'),
1871 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1872 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1874 (SELECT player FROM players WHERE nick='Felz'),
1875 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1878 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1879 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1881 (SELECT player FROM players WHERE nick='Felz'),
1882 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1885 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1886 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1888 (SELECT player FROM players WHERE nick='Felz'),
1889 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1892 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
1893 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1894 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1896 (SELECT player FROM players WHERE nick='Andeplane'),
1899 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1900 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1902 (SELECT player FROM players WHERE nick='Andeplane'),
1903 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1906 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1907 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1909 (SELECT player FROM players WHERE nick='Andeplane'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1913 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1916 (SELECT player FROM players WHERE nick='Andeplane'),
1917 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1920 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1921 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1922 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1924 (SELECT player FROM players WHERE nick='Bonzo'),
1927 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1928 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1930 (SELECT player FROM players WHERE nick='Bonzo'),
1931 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1934 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1937 (SELECT player FROM players WHERE nick='Bonzo'),
1938 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1941 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1942 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1944 (SELECT player FROM players WHERE nick='Bonzo'),
1945 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1948 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1949 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1950 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1952 (SELECT player FROM players WHERE nick='Daniil'),
1955 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1956 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1958 (SELECT player FROM players WHERE nick='Daniil'),
1959 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1962 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1963 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1965 (SELECT player FROM players WHERE nick='Daniil'),
1966 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1969 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1970 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1972 (SELECT player FROM players WHERE nick='Daniil'),
1973 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1976 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1977 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1978 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1980 (SELECT player FROM players WHERE nick='Olemann'),
1983 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1984 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1986 (SELECT player FROM players WHERE nick='Olemann'),
1987 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1990 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1991 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
1993 (SELECT player FROM players WHERE nick='Olemann'),
1994 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1997 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1998 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2000 (SELECT player FROM players WHERE nick='Olemann'),
2001 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2004 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2005 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2006 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2008 (SELECT player FROM players WHERE nick='Snofox'),
2011 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2012 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2014 (SELECT player FROM players WHERE nick='Snofox'),
2015 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2018 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2019 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2021 (SELECT player FROM players WHERE nick='Snofox'),
2022 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2025 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2026 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2028 (SELECT player FROM players WHERE nick='Snofox'),
2029 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2032 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2033 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2034 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2036 (SELECT player FROM players WHERE nick='Nameless'),
2039 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2040 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2042 (SELECT player FROM players WHERE nick='Nameless'),
2043 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2046 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2047 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2049 (SELECT player FROM players WHERE nick='Nameless'),
2050 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2053 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2054 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2056 (SELECT player FROM players WHERE nick='Nameless'),
2057 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2060 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2062 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2065 INSERT INTO groups (tournament, round, parallel) VALUES (
2066 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2068 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2069 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2071 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2073 UPDATE rounds SET randomsongs=1 WHERE
2074 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2076 UPDATE rounds SET chosensongs=1 WHERE
2077 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2079 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2080 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2081 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2083 (SELECT player FROM players WHERE nick='RiChY'),
2086 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2089 (SELECT player FROM players WHERE nick='RiChY'),
2090 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2093 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2096 (SELECT player FROM players WHERE nick='RiChY'),
2097 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2100 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2101 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2102 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2104 (SELECT player FROM players WHERE nick='Snofox'),
2107 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2108 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2110 (SELECT player FROM players WHERE nick='Snofox'),
2111 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2114 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2115 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2117 (SELECT player FROM players WHERE nick='Snofox'),
2118 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2121 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
2122 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2123 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2125 (SELECT player FROM players WHERE nick='Pingo'),
2128 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2129 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2131 (SELECT player FROM players WHERE nick='Pingo'),
2132 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2135 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2136 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2138 (SELECT player FROM players WHERE nick='Pingo'),
2139 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2142 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2143 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2144 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2146 (SELECT player FROM players WHERE nick='OJK'),
2149 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2152 (SELECT player FROM players WHERE nick='OJK'),
2153 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2156 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2157 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2159 (SELECT player FROM players WHERE nick='OJK'),
2160 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2163 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2164 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2165 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2167 (SELECT player FROM players WHERE nick='Oliyzia'),
2170 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2173 (SELECT player FROM players WHERE nick='Oliyzia'),
2174 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2177 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2180 (SELECT player FROM players WHERE nick='Oliyzia'),
2181 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2184 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2185 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2186 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2188 (SELECT player FROM players WHERE nick='Bonzo'),
2191 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2192 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2194 (SELECT player FROM players WHERE nick='Bonzo'),
2195 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2198 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2199 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2201 (SELECT player FROM players WHERE nick='Bonzo'),
2202 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2205 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2206 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2207 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2209 (SELECT player FROM players WHERE nick='Snute'),
2212 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2213 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2215 (SELECT player FROM players WHERE nick='Snute'),
2216 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2219 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2220 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2222 (SELECT player FROM players WHERE nick='Snute'),
2223 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2226 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2227 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2228 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2230 (SELECT player FROM players WHERE nick='Nameless'),
2233 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2234 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2236 (SELECT player FROM players WHERE nick='Nameless'),
2237 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2240 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2241 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2243 (SELECT player FROM players WHERE nick='Nameless'),
2244 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2247 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2248 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2251 (SELECT player FROM players WHERE nick='Haggar'),
2254 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2255 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2257 (SELECT player FROM players WHERE nick='Haggar'),
2258 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2261 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2262 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2264 (SELECT player FROM players WHERE nick='Haggar'),
2265 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2268 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2273 INSERT INTO groups (tournament, round, parallel) VALUES (
2274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2276 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2277 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2279 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
2281 UPDATE rounds SET randomsongs=1 WHERE
2282 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2284 UPDATE rounds SET chosensongs=1 WHERE
2285 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2287 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2288 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2289 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2291 (SELECT player FROM players WHERE nick='Nameless'),
2294 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2295 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2297 (SELECT player FROM players WHERE nick='Nameless'),
2298 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2301 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2302 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2304 (SELECT player FROM players WHERE nick='Nameless'),
2305 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2308 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2309 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2310 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2312 (SELECT player FROM players WHERE nick='RiChY'),
2315 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2316 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2318 (SELECT player FROM players WHERE nick='RiChY'),
2319 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2322 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2323 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2325 (SELECT player FROM players WHERE nick='RiChY'),
2326 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2329 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2330 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2331 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2333 (SELECT player FROM players WHERE nick='Oliyzia'),
2336 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2339 (SELECT player FROM players WHERE nick='Oliyzia'),
2340 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2343 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2346 (SELECT player FROM players WHERE nick='Oliyzia'),
2347 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2350 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2351 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2352 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2354 (SELECT player FROM players WHERE nick='Snofox'),
2357 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2360 (SELECT player FROM players WHERE nick='Snofox'),
2361 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2364 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2367 (SELECT player FROM players WHERE nick='Snofox'),
2368 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2371 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2372 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2373 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2375 (SELECT player FROM players WHERE nick='Snute'),
2378 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2379 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2381 (SELECT player FROM players WHERE nick='Snute'),
2382 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2385 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2386 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2388 (SELECT player FROM players WHERE nick='Snute'),
2389 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2392 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2393 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2394 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2396 (SELECT player FROM players WHERE nick='Haggar'),
2399 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2402 (SELECT player FROM players WHERE nick='Haggar'),
2403 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2406 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2407 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2409 (SELECT player FROM players WHERE nick='Haggar'),
2410 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2413 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2414 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2415 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2417 (SELECT player FROM players WHERE nick='Bonzo'),
2420 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2421 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2423 (SELECT player FROM players WHERE nick='Bonzo'),
2424 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2427 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2428 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2430 (SELECT player FROM players WHERE nick='Bonzo'),
2431 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2434 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2439 INSERT INTO groups (tournament, round, parallel) VALUES (
2440 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2442 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2443 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2445 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
2447 UPDATE rounds SET randomsongs=1 WHERE
2448 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2450 UPDATE rounds SET chosensongs=1 WHERE
2451 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2453 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2454 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2455 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2457 (SELECT player FROM players WHERE nick='Bonzo'),
2460 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2461 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2463 (SELECT player FROM players WHERE nick='Bonzo'),
2464 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2467 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2470 (SELECT player FROM players WHERE nick='Bonzo'),
2471 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2474 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2476 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2478 (SELECT player FROM players WHERE nick='Nameless'),
2481 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2482 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2484 (SELECT player FROM players WHERE nick='Nameless'),
2485 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2488 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2489 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2491 (SELECT player FROM players WHERE nick='Nameless'),
2492 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2495 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2496 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2497 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2499 (SELECT player FROM players WHERE nick='Snofox'),
2502 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2503 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2505 (SELECT player FROM players WHERE nick='Snofox'),
2506 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2509 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2510 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2512 (SELECT player FROM players WHERE nick='Snofox'),
2513 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2516 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2517 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2518 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2520 (SELECT player FROM players WHERE nick='Haggar'),
2523 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2526 (SELECT player FROM players WHERE nick='Haggar'),
2527 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2530 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2531 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2533 (SELECT player FROM players WHERE nick='Haggar'),
2534 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2537 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2538 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2539 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2541 (SELECT player FROM players WHERE nick='Snute'),
2544 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2545 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2547 (SELECT player FROM players WHERE nick='Snute'),
2548 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2551 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2554 (SELECT player FROM players WHERE nick='Snute'),
2555 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2558 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2560 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2563 INSERT INTO groups (tournament, round, parallel) VALUES (
2564 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2566 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2567 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2569 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
2571 UPDATE rounds SET randomsongs=1 WHERE
2572 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2574 UPDATE rounds SET chosensongs=1 WHERE
2575 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2577 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2579 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2581 (SELECT player FROM players WHERE nick='Snofox'),
2584 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2585 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2587 (SELECT player FROM players WHERE nick='Snofox'),
2588 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2591 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2592 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2594 (SELECT player FROM players WHERE nick='Snofox'),
2595 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2598 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2599 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2600 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2602 (SELECT player FROM players WHERE nick='Haggar'),
2605 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2606 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2608 (SELECT player FROM players WHERE nick='Haggar'),
2609 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2612 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2613 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2615 (SELECT player FROM players WHERE nick='Haggar'),
2616 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2619 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2620 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2621 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2623 (SELECT player FROM players WHERE nick='Nameless'),
2626 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2629 (SELECT player FROM players WHERE nick='Nameless'),
2630 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2633 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2634 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2636 (SELECT player FROM players WHERE nick='Nameless'),
2637 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2640 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2641 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2642 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2644 (SELECT player FROM players WHERE nick='Snute'),
2647 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2648 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2650 (SELECT player FROM players WHERE nick='Snute'),
2651 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2654 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2657 (SELECT player FROM players WHERE nick='Snute'),
2658 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2661 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2663 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2666 INSERT INTO groups (tournament, round, parallel) VALUES (
2667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2669 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2670 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2672 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2674 UPDATE rounds SET randomsongs=1 WHERE
2675 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2677 UPDATE rounds SET chosensongs=1 WHERE
2678 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2680 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2681 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2682 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2684 (SELECT player FROM players WHERE nick='Nameless'),
2687 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2688 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2690 (SELECT player FROM players WHERE nick='Nameless'),
2691 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2694 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2695 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2697 (SELECT player FROM players WHERE nick='Nameless'),
2698 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2701 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2702 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2703 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2705 (SELECT player FROM players WHERE nick='Haggar'),
2708 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2709 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2711 (SELECT player FROM players WHERE nick='Haggar'),
2712 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2715 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2716 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2718 (SELECT player FROM players WHERE nick='Haggar'),
2719 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2722 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2723 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2724 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2726 (SELECT player FROM players WHERE nick='Snute'),
2729 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2730 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2732 (SELECT player FROM players WHERE nick='Snute'),
2733 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2736 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2737 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2739 (SELECT player FROM players WHERE nick='Snute'),
2740 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2743 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2748 INSERT INTO groups (tournament, round, parallel) VALUES (
2749 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2751 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2754 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
2756 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2759 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2761 UPDATE rounds SET randomsongs=2 WHERE
2762 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 7') AND
2764 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2765 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2766 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2768 (SELECT player FROM players WHERE nick='Haggar'),
2771 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2772 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2774 (SELECT player FROM players WHERE nick='Haggar'),
2775 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2778 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2779 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2781 (SELECT player FROM players WHERE nick='Haggar'),
2782 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2785 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2786 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2787 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2789 (SELECT player FROM players WHERE nick='Snute'),
2792 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2793 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2795 (SELECT player FROM players WHERE nick='Snute'),
2796 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2799 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2800 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 7'),
2802 (SELECT player FROM players WHERE nick='Snute'),
2803 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),