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 'Fredrikstad Mestern 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 6'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' 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 6'),
40 (SELECT player FROM players WHERE nick='Pyro'),
43 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
46 (SELECT player FROM players WHERE nick='Pyro'),
48 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
54 (SELECT player FROM players WHERE nick='Pyro'),
56 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
62 (SELECT player FROM players WHERE nick='Pyro'),
64 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
67 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
68 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
69 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
71 (SELECT player FROM players WHERE nick='Th0rny'),
74 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
75 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
77 (SELECT player FROM players WHERE nick='Th0rny'),
79 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
85 (SELECT player FROM players WHERE nick='Th0rny'),
87 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
93 (SELECT player FROM players WHERE nick='Th0rny'),
95 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
99 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
102 (SELECT player FROM players WHERE nick='Glukko'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
108 (SELECT player FROM players WHERE nick='Glukko'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
116 (SELECT player FROM players WHERE nick='Glukko'),
118 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
124 (SELECT player FROM players WHERE nick='Glukko'),
126 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
133 (SELECT player FROM players WHERE nick='Daniil'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
139 (SELECT player FROM players WHERE nick='Daniil'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
147 (SELECT player FROM players WHERE nick='Daniil'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
155 (SELECT player FROM players WHERE nick='Daniil'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
164 (SELECT player FROM players WHERE nick='Snofox'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
170 (SELECT player FROM players WHERE nick='Snofox'),
172 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
178 (SELECT player FROM players WHERE nick='Snofox'),
180 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
186 (SELECT player FROM players WHERE nick='Snofox'),
188 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
193 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
195 (SELECT player FROM players WHERE nick='Snute'),
198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
199 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
201 (SELECT player FROM players WHERE nick='Snute'),
203 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
207 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
209 (SELECT player FROM players WHERE nick='Snute'),
211 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
215 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
217 (SELECT player FROM players WHERE nick='Snute'),
219 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
222 INSERT INTO groups (tournament, round, parallel) VALUES (
223 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
225 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
226 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
228 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
233 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
235 UPDATE rounds SET randomsongs=2 WHERE
236 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
238 UPDATE rounds SET chosensongs=1 WHERE
239 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
245 (SELECT player FROM players WHERE nick='Glock'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
251 (SELECT player FROM players WHERE nick='Glock'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
259 (SELECT player FROM players WHERE nick='Glock'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
267 (SELECT player FROM players WHERE nick='Glock'),
269 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
276 (SELECT player FROM players WHERE nick='Athena'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
282 (SELECT player FROM players WHERE nick='Athena'),
284 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
290 (SELECT player FROM players WHERE nick='Athena'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
298 (SELECT player FROM players WHERE nick='Athena'),
300 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
307 (SELECT player FROM players WHERE nick='Matsi'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
313 (SELECT player FROM players WHERE nick='Matsi'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
321 (SELECT player FROM players WHERE nick='Matsi'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
329 (SELECT player FROM players WHERE nick='Matsi'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
338 (SELECT player FROM players WHERE nick='Bonzo'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
344 (SELECT player FROM players WHERE nick='Bonzo'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
352 (SELECT player FROM players WHERE nick='Bonzo'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
360 (SELECT player FROM players WHERE nick='Bonzo'),
362 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
365 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
367 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
369 (SELECT player FROM players WHERE nick='Smiph'),
372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
373 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
375 (SELECT player FROM players WHERE nick='Smiph'),
377 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
381 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
383 (SELECT player FROM players WHERE nick='Smiph'),
385 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
389 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
391 (SELECT player FROM players WHERE nick='Smiph'),
393 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
396 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
398 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
400 (SELECT player FROM players WHERE nick='DufF'),
403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
406 (SELECT player FROM players WHERE nick='DufF'),
408 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
414 (SELECT player FROM players WHERE nick='DufF'),
416 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
420 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
422 (SELECT player FROM players WHERE nick='DufF'),
424 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
427 INSERT INTO groups (tournament, round, parallel) VALUES (
428 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
430 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
431 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
435 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
438 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
440 UPDATE rounds SET randomsongs=2 WHERE
441 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
443 UPDATE rounds SET chosensongs=1 WHERE
444 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
448 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
450 (SELECT player FROM players WHERE nick='Ifrit'),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
456 (SELECT player FROM players WHERE nick='Ifrit'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
464 (SELECT player FROM players WHERE nick='Ifrit'),
466 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
472 (SELECT player FROM players WHERE nick='Ifrit'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
481 (SELECT player FROM players WHERE nick='ViD'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
487 (SELECT player FROM players WHERE nick='ViD'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
495 (SELECT player FROM players WHERE nick='ViD'),
497 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
503 (SELECT player FROM players WHERE nick='ViD'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
509 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
510 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
512 (SELECT player FROM players WHERE nick='Hyper'),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
518 (SELECT player FROM players WHERE nick='Hyper'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
526 (SELECT player FROM players WHERE nick='Hyper'),
528 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
534 (SELECT player FROM players WHERE nick='Hyper'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
539 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
540 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
541 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
543 (SELECT player FROM players WHERE nick='Andeplane'),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
549 (SELECT player FROM players WHERE nick='Andeplane'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
557 (SELECT player FROM players WHERE nick='Andeplane'),
559 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
565 (SELECT player FROM players WHERE nick='Andeplane'),
567 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
570 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
571 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
572 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
574 (SELECT player FROM players WHERE nick='Gogo'),
577 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
580 (SELECT player FROM players WHERE nick='Gogo'),
582 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
585 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
586 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
588 (SELECT player FROM players WHERE nick='Gogo'),
590 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
594 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
596 (SELECT player FROM players WHERE nick='Gogo'),
598 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
601 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
605 (SELECT player FROM players WHERE nick='Duckling'),
608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
609 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
611 (SELECT player FROM players WHERE nick='Duckling'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
617 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
619 (SELECT player FROM players WHERE nick='Duckling'),
621 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
625 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
627 (SELECT player FROM players WHERE nick='Duckling'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
632 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
633 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
634 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
636 (SELECT player FROM players WHERE nick='OJK'),
639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
642 (SELECT player FROM players WHERE nick='OJK'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
648 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
650 (SELECT player FROM players WHERE nick='OJK'),
652 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
655 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
656 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
658 (SELECT player FROM players WHERE nick='OJK'),
660 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
663 INSERT INTO groups (tournament, round, parallel) VALUES (
664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
666 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
671 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
672 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
674 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
676 UPDATE rounds SET randomsongs=2 WHERE
677 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
679 UPDATE rounds SET chosensongs=1 WHERE
680 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
682 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
683 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
684 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
686 (SELECT player FROM players WHERE nick='Electron'),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
692 (SELECT player FROM players WHERE nick='Electron'),
694 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
700 (SELECT player FROM players WHERE nick='Electron'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
705 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
708 (SELECT player FROM players WHERE nick='Electron'),
710 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
713 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
717 (SELECT player FROM players WHERE nick='Guru'),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
723 (SELECT player FROM players WHERE nick='Guru'),
725 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
731 (SELECT player FROM players WHERE nick='Guru'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
739 (SELECT player FROM players WHERE nick='Guru'),
741 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
744 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
745 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
746 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
748 (SELECT player FROM players WHERE nick='Annkakri'),
751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
754 (SELECT player FROM players WHERE nick='Annkakri'),
756 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
762 (SELECT player FROM players WHERE nick='Annkakri'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
770 (SELECT player FROM players WHERE nick='Annkakri'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
775 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
776 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
777 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
779 (SELECT player FROM players WHERE nick='Felz'),
782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
783 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
785 (SELECT player FROM players WHERE nick='Felz'),
787 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
791 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
793 (SELECT player FROM players WHERE nick='Felz'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
801 (SELECT player FROM players WHERE nick='Felz'),
803 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
806 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
807 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
808 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
810 (SELECT player FROM players WHERE nick='Draconia'),
813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
814 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
816 (SELECT player FROM players WHERE nick='Draconia'),
818 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
822 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
824 (SELECT player FROM players WHERE nick='Draconia'),
826 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
829 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
830 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
832 (SELECT player FROM players WHERE nick='Draconia'),
834 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
837 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
838 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
841 (SELECT player FROM players WHERE nick='Ylini'),
844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
845 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
847 (SELECT player FROM players WHERE nick='Ylini'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
852 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
855 (SELECT player FROM players WHERE nick='Ylini'),
857 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
861 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
863 (SELECT player FROM players WHERE nick='Ylini'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
868 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' 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 6'),
872 (SELECT player FROM players WHERE nick='Haggar'),
875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
878 (SELECT player FROM players WHERE nick='Haggar'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
886 (SELECT player FROM players WHERE nick='Haggar'),
888 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
892 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
894 (SELECT player FROM players WHERE nick='Haggar'),
896 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
899 INSERT INTO groups (tournament, round, parallel) VALUES (
900 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
902 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
903 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
905 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
907 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
908 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
910 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
912 UPDATE rounds SET randomsongs=2 WHERE
913 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
915 UPDATE rounds SET chosensongs=1 WHERE
916 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
918 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
919 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
920 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
922 (SELECT player FROM players WHERE nick='Goku'),
925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
928 (SELECT player FROM players WHERE nick='Goku'),
930 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
936 (SELECT player FROM players WHERE nick='Goku'),
938 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
942 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
944 (SELECT player FROM players WHERE nick='Goku'),
946 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
949 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
951 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
953 (SELECT player FROM players WHERE nick='Montana'),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
959 (SELECT player FROM players WHERE nick='Montana'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
967 (SELECT player FROM players WHERE nick='Montana'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
975 (SELECT player FROM players WHERE nick='Montana'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
980 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' 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 6'),
984 (SELECT player FROM players WHERE nick='JonAnders'),
987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
988 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
990 (SELECT player FROM players WHERE nick='JonAnders'),
992 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
996 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
998 (SELECT player FROM players WHERE nick='JonAnders'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1004 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1006 (SELECT player FROM players WHERE nick='JonAnders'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1011 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1015 (SELECT player FROM players WHERE nick='Alexxz'),
1018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1021 (SELECT player FROM players WHERE nick='Alexxz'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1027 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1029 (SELECT player FROM players WHERE nick='Alexxz'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1037 (SELECT player FROM players WHERE nick='Alexxz'),
1039 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1042 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1043 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1044 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1046 (SELECT player FROM players WHERE nick='Pingo'),
1049 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1052 (SELECT player FROM players WHERE nick='Pingo'),
1054 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1057 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1058 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1060 (SELECT player FROM players WHERE nick='Pingo'),
1062 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1065 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1068 (SELECT player FROM players WHERE nick='Pingo'),
1070 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1073 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1074 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1075 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1077 (SELECT player FROM players WHERE nick='Nameless'),
1080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1081 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1083 (SELECT player FROM players WHERE nick='Nameless'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1088 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1091 (SELECT player FROM players WHERE nick='Nameless'),
1093 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1096 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1097 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1099 (SELECT player FROM players WHERE nick='Nameless'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1104 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1105 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1108 (SELECT player FROM players WHERE nick='RiChY'),
1111 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1112 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1114 (SELECT player FROM players WHERE nick='RiChY'),
1116 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1119 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1120 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1122 (SELECT player FROM players WHERE nick='RiChY'),
1124 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1130 (SELECT player FROM players WHERE nick='RiChY'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1135 INSERT INTO groups (tournament, round, parallel) VALUES (
1136 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1138 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1139 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1141 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1143 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1144 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1148 UPDATE rounds SET randomsongs=2 WHERE
1149 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1151 UPDATE rounds SET chosensongs=1 WHERE
1152 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1154 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
1155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1158 (SELECT player FROM players WHERE nick='Matti'),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1164 (SELECT player FROM players WHERE nick='Matti'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1172 (SELECT player FROM players WHERE nick='Matti'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1180 (SELECT player FROM players WHERE nick='Matti'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1185 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1187 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1189 (SELECT player FROM players WHERE nick='v|per'),
1192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1193 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1195 (SELECT player FROM players WHERE nick='v|per'),
1197 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1201 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1203 (SELECT player FROM players WHERE nick='v|per'),
1205 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1211 (SELECT player FROM players WHERE nick='v|per'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1216 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
1217 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1218 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1220 (SELECT player FROM players WHERE nick='Zackie'),
1223 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1224 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1226 (SELECT player FROM players WHERE nick='Zackie'),
1228 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1231 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1234 (SELECT player FROM players WHERE nick='Zackie'),
1236 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1239 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1240 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1242 (SELECT player FROM players WHERE nick='Zackie'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1247 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1248 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1251 (SELECT player FROM players WHERE nick='Mync'),
1254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1257 (SELECT player FROM players WHERE nick='Mync'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1263 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1265 (SELECT player FROM players WHERE nick='Mync'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1271 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1273 (SELECT player FROM players WHERE nick='Mync'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1278 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1279 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1282 (SELECT player FROM players WHERE nick='Ozon'),
1285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1286 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1288 (SELECT player FROM players WHERE nick='Ozon'),
1290 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1296 (SELECT player FROM players WHERE nick='Ozon'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1304 (SELECT player FROM players WHERE nick='Ozon'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1309 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1310 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1313 (SELECT player FROM players WHERE nick='T|na'),
1316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1317 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1319 (SELECT player FROM players WHERE nick='T|na'),
1321 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1325 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1327 (SELECT player FROM players WHERE nick='T|na'),
1329 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1333 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1335 (SELECT player FROM players WHERE nick='T|na'),
1337 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1340 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1341 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1344 (SELECT player FROM players WHERE nick='Oliyzia'),
1347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1348 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1350 (SELECT player FROM players WHERE nick='Oliyzia'),
1352 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1358 (SELECT player FROM players WHERE nick='Oliyzia'),
1360 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1364 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1366 (SELECT player FROM players WHERE nick='Oliyzia'),
1368 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1371 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1373 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1376 INSERT INTO groups (tournament, round, parallel) VALUES (
1377 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1379 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1380 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1382 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
1384 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1385 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1389 UPDATE rounds SET randomsongs=2 WHERE
1390 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1392 UPDATE rounds SET chosensongs=1 WHERE
1393 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1395 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1399 (SELECT player FROM players WHERE nick='Daniil'),
1402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1403 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1405 (SELECT player FROM players WHERE nick='Daniil'),
1407 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1411 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1413 (SELECT player FROM players WHERE nick='Daniil'),
1415 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1419 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1421 (SELECT player FROM players WHERE nick='Daniil'),
1423 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1426 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
1427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1428 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1430 (SELECT player FROM players WHERE nick='ViD'),
1433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1434 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1436 (SELECT player FROM players WHERE nick='ViD'),
1438 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1444 (SELECT player FROM players WHERE nick='ViD'),
1446 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1449 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1450 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1452 (SELECT player FROM players WHERE nick='ViD'),
1454 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1457 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1458 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1459 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1461 (SELECT player FROM players WHERE nick='Ylini'),
1464 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1467 (SELECT player FROM players WHERE nick='Ylini'),
1469 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1472 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1473 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1475 (SELECT player FROM players WHERE nick='Ylini'),
1477 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1480 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1483 (SELECT player FROM players WHERE nick='Ylini'),
1485 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1488 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1489 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1490 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1492 (SELECT player FROM players WHERE nick='Bonzo'),
1495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1498 (SELECT player FROM players WHERE nick='Bonzo'),
1500 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1504 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1506 (SELECT player FROM players WHERE nick='Bonzo'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1512 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1514 (SELECT player FROM players WHERE nick='Bonzo'),
1516 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1519 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1520 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1523 (SELECT player FROM players WHERE nick='Snute'),
1526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1527 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1529 (SELECT player FROM players WHERE nick='Snute'),
1531 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1534 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1535 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1537 (SELECT player FROM players WHERE nick='Snute'),
1539 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1545 (SELECT player FROM players WHERE nick='Snute'),
1547 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1554 (SELECT player FROM players WHERE nick='Gogo'),
1557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1560 (SELECT player FROM players WHERE nick='Gogo'),
1562 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1565 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1566 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1568 (SELECT player FROM players WHERE nick='Gogo'),
1570 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1574 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1576 (SELECT player FROM players WHERE nick='Gogo'),
1578 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1581 INSERT INTO groups (tournament, round, parallel) VALUES (
1582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1584 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1585 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1587 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1589 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1590 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1592 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
1594 UPDATE rounds SET randomsongs=2 WHERE
1595 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1597 UPDATE rounds SET chosensongs=1 WHERE
1598 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1600 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
1601 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1602 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1604 (SELECT player FROM players WHERE nick='Felz'),
1607 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1608 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1610 (SELECT player FROM players WHERE nick='Felz'),
1612 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1615 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1616 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1618 (SELECT player FROM players WHERE nick='Felz'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1623 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1626 (SELECT player FROM players WHERE nick='Felz'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1631 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1635 (SELECT player FROM players WHERE nick='Mync'),
1638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1641 (SELECT player FROM players WHERE nick='Mync'),
1643 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1649 (SELECT player FROM players WHERE nick='Mync'),
1651 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1654 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1657 (SELECT player FROM players WHERE nick='Mync'),
1659 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1662 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1663 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1666 (SELECT player FROM players WHERE nick='OJK'),
1669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1670 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1672 (SELECT player FROM players WHERE nick='OJK'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1678 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1680 (SELECT player FROM players WHERE nick='OJK'),
1682 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1688 (SELECT player FROM players WHERE nick='OJK'),
1690 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1693 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1694 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1695 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1697 (SELECT player FROM players WHERE nick='T|na'),
1700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1701 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1703 (SELECT player FROM players WHERE nick='T|na'),
1705 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1709 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1711 (SELECT player FROM players WHERE nick='T|na'),
1713 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1716 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1719 (SELECT player FROM players WHERE nick='T|na'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1724 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1725 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1726 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1728 (SELECT player FROM players WHERE nick='DufF'),
1731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1732 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1734 (SELECT player FROM players WHERE nick='DufF'),
1736 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1739 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1740 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1742 (SELECT player FROM players WHERE nick='DufF'),
1744 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1747 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1750 (SELECT player FROM players WHERE nick='DufF'),
1752 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1755 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1756 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1759 (SELECT player FROM players WHERE nick='Nameless'),
1762 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1763 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1765 (SELECT player FROM players WHERE nick='Nameless'),
1767 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1773 (SELECT player FROM players WHERE nick='Nameless'),
1775 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1779 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1781 (SELECT player FROM players WHERE nick='Nameless'),
1783 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1786 INSERT INTO groups (tournament, round, parallel) VALUES (
1787 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1789 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1790 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1792 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
1794 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1797 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1799 UPDATE rounds SET randomsongs=2 WHERE
1800 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1802 UPDATE rounds SET chosensongs=1 WHERE
1803 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1805 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1806 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1807 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1809 (SELECT player FROM players WHERE nick='Smiph'),
1812 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1813 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1815 (SELECT player FROM players WHERE nick='Smiph'),
1817 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1820 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1821 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1823 (SELECT player FROM players WHERE nick='Smiph'),
1825 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1828 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1829 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1831 (SELECT player FROM players WHERE nick='Smiph'),
1833 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1836 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1838 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1840 (SELECT player FROM players WHERE nick='RiChY'),
1843 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1844 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1846 (SELECT player FROM players WHERE nick='RiChY'),
1848 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1851 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1852 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1854 (SELECT player FROM players WHERE nick='RiChY'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1860 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1862 (SELECT player FROM players WHERE nick='RiChY'),
1864 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1867 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1868 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1869 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1871 (SELECT player FROM players WHERE nick='Snofox'),
1874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1875 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1877 (SELECT player FROM players WHERE nick='Snofox'),
1879 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1885 (SELECT player FROM players WHERE nick='Snofox'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1893 (SELECT player FROM players WHERE nick='Snofox'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1898 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1899 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1900 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1902 (SELECT player FROM players WHERE nick='Pingo'),
1905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1906 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1908 (SELECT player FROM players WHERE nick='Pingo'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1916 (SELECT player FROM players WHERE nick='Pingo'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1921 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1922 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1924 (SELECT player FROM players WHERE nick='Pingo'),
1926 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1929 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1930 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1931 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1933 (SELECT player FROM players WHERE nick='Haggar'),
1936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1939 (SELECT player FROM players WHERE nick='Haggar'),
1941 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1945 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1947 (SELECT player FROM players WHERE nick='Haggar'),
1949 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1952 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1953 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1955 (SELECT player FROM players WHERE nick='Haggar'),
1957 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1960 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1961 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1962 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1964 (SELECT player FROM players WHERE nick='Oliyzia'),
1967 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1968 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1970 (SELECT player FROM players WHERE nick='Oliyzia'),
1972 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1975 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1976 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1978 (SELECT player FROM players WHERE nick='Oliyzia'),
1980 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1983 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1984 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1986 (SELECT player FROM players WHERE nick='Oliyzia'),
1988 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1991 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1993 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1996 INSERT INTO groups (tournament, round, parallel) VALUES (
1997 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1999 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2000 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2002 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
2004 UPDATE rounds SET randomsongs=1 WHERE
2005 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2007 UPDATE rounds SET chosensongs=1 WHERE
2008 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2010 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2011 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2012 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2014 (SELECT player FROM players WHERE nick='Nameless'),
2017 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2018 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2020 (SELECT player FROM players WHERE nick='Nameless'),
2022 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2026 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2028 (SELECT player FROM players WHERE nick='Nameless'),
2030 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2033 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2034 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2035 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2037 (SELECT player FROM players WHERE nick='Oliyzia'),
2040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2041 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2043 (SELECT player FROM players WHERE nick='Oliyzia'),
2045 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2049 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2051 (SELECT player FROM players WHERE nick='Oliyzia'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2057 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2058 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2060 (SELECT player FROM players WHERE nick='Bonzo'),
2063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2064 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2066 (SELECT player FROM players WHERE nick='Bonzo'),
2068 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2071 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2072 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2074 (SELECT player FROM players WHERE nick='Bonzo'),
2076 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2079 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' 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 6'),
2083 (SELECT player FROM players WHERE nick='Ylini'),
2086 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2089 (SELECT player FROM players WHERE nick='Ylini'),
2091 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2094 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2095 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2097 (SELECT player FROM players WHERE nick='Ylini'),
2099 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2103 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2104 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2106 (SELECT player FROM players WHERE nick='OJK'),
2109 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2110 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2112 (SELECT player FROM players WHERE nick='OJK'),
2114 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2118 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2120 (SELECT player FROM players WHERE nick='OJK'),
2122 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2125 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2127 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2129 (SELECT player FROM players WHERE nick='Snofox'),
2132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2133 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2135 (SELECT player FROM players WHERE nick='Snofox'),
2137 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2143 (SELECT player FROM players WHERE nick='Snofox'),
2145 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2152 (SELECT player FROM players WHERE nick='DufF'),
2155 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2158 (SELECT player FROM players WHERE nick='DufF'),
2160 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2163 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2164 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2166 (SELECT player FROM players WHERE nick='DufF'),
2168 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2171 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2172 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2173 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2175 (SELECT player FROM players WHERE nick='Snute'),
2178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2179 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2181 (SELECT player FROM players WHERE nick='Snute'),
2183 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2187 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2189 (SELECT player FROM players WHERE nick='Snute'),
2191 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2194 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2195 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2198 (SELECT player FROM players WHERE nick='Haggar'),
2201 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2202 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2204 (SELECT player FROM players WHERE nick='Haggar'),
2206 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2209 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2212 (SELECT player FROM players WHERE nick='Haggar'),
2214 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2217 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2219 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2222 INSERT INTO groups (tournament, round, parallel) VALUES (
2223 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2225 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2226 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2228 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
2230 UPDATE rounds SET randomsongs=1 WHERE
2231 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2233 UPDATE rounds SET chosensongs=1 WHERE
2234 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2236 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2237 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2240 (SELECT player FROM players WHERE nick='Nameless'),
2243 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2244 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2246 (SELECT player FROM players WHERE nick='Nameless'),
2248 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2251 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2254 (SELECT player FROM players WHERE nick='Nameless'),
2256 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2259 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2260 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2261 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2263 (SELECT player FROM players WHERE nick='Oliyzia'),
2266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2269 (SELECT player FROM players WHERE nick='Oliyzia'),
2271 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2275 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2277 (SELECT player FROM players WHERE nick='Oliyzia'),
2279 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2282 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2283 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2284 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2286 (SELECT player FROM players WHERE nick='Haggar'),
2289 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2290 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2292 (SELECT player FROM players WHERE nick='Haggar'),
2294 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2297 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2298 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2300 (SELECT player FROM players WHERE nick='Haggar'),
2302 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2305 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2307 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2309 (SELECT player FROM players WHERE nick='Snofox'),
2312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2315 (SELECT player FROM players WHERE nick='Snofox'),
2317 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2321 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2323 (SELECT player FROM players WHERE nick='Snofox'),
2325 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2328 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2329 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2330 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2332 (SELECT player FROM players WHERE nick='DufF'),
2335 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2338 (SELECT player FROM players WHERE nick='DufF'),
2340 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2346 (SELECT player FROM players WHERE nick='DufF'),
2348 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2351 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2352 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2353 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2355 (SELECT player FROM players WHERE nick='OJK'),
2358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2359 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2361 (SELECT player FROM players WHERE nick='OJK'),
2363 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2366 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2367 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2369 (SELECT player FROM players WHERE nick='OJK'),
2371 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2374 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2375 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2378 (SELECT player FROM players WHERE nick='Snute'),
2381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2382 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2384 (SELECT player FROM players WHERE nick='Snute'),
2386 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2392 (SELECT player FROM players WHERE nick='Snute'),
2394 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2397 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2399 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2402 INSERT INTO groups (tournament, round, parallel) VALUES (
2403 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2405 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2406 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2408 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2410 UPDATE rounds SET randomsongs=1 WHERE
2411 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2413 UPDATE rounds SET chosensongs=1 WHERE
2414 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2416 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2417 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2420 (SELECT player FROM players WHERE nick='Snofox'),
2423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2424 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2426 (SELECT player FROM players WHERE nick='Snofox'),
2428 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2434 (SELECT player FROM players WHERE nick='Snofox'),
2436 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2439 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2440 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2441 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2443 (SELECT player FROM players WHERE nick='DufF'),
2446 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2447 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2449 (SELECT player FROM players WHERE nick='DufF'),
2451 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2455 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2457 (SELECT player FROM players WHERE nick='DufF'),
2459 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2462 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2464 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2466 (SELECT player FROM players WHERE nick='OJK'),
2469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2470 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2472 (SELECT player FROM players WHERE nick='OJK'),
2474 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2477 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2478 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2480 (SELECT player FROM players WHERE nick='OJK'),
2482 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2485 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2486 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2487 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2489 (SELECT player FROM players WHERE nick='Oliyzia'),
2492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2493 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2495 (SELECT player FROM players WHERE nick='Oliyzia'),
2497 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2501 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2503 (SELECT player FROM players WHERE nick='Oliyzia'),
2505 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2509 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2510 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2512 (SELECT player FROM players WHERE nick='Snute'),
2515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2518 (SELECT player FROM players WHERE nick='Snute'),
2520 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2526 (SELECT player FROM players WHERE nick='Snute'),
2528 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2531 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2533 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2536 INSERT INTO groups (tournament, round, parallel) VALUES (
2537 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2539 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2542 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
2544 UPDATE rounds SET randomsongs=1 WHERE
2545 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2547 UPDATE rounds SET chosensongs=1 WHERE
2548 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2554 (SELECT player FROM players WHERE nick='OJK'),
2557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2560 (SELECT player FROM players WHERE nick='OJK'),
2562 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2565 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2566 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2568 (SELECT player FROM players WHERE nick='OJK'),
2570 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2573 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2575 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2577 (SELECT player FROM players WHERE nick='Snofox'),
2580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2581 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2583 (SELECT player FROM players WHERE nick='Snofox'),
2585 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2591 (SELECT player FROM players WHERE nick='Snofox'),
2593 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2596 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2597 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2598 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2600 (SELECT player FROM players WHERE nick='DufF'),
2603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2604 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2606 (SELECT player FROM players WHERE nick='DufF'),
2608 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2611 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2614 (SELECT player FROM players WHERE nick='DufF'),
2616 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2619 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' 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 6'),
2623 (SELECT player FROM players WHERE nick='Snute'),
2626 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2629 (SELECT player FROM players WHERE nick='Snute'),
2631 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2634 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2635 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2637 (SELECT player FROM players WHERE nick='Snute'),
2639 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2642 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2644 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2647 INSERT INTO groups (tournament, round, parallel) VALUES (
2648 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2650 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2651 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2653 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2655 UPDATE rounds SET randomsongs=1 WHERE
2656 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2658 UPDATE rounds SET chosensongs=1 WHERE
2659 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2661 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2662 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2663 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2665 (SELECT player FROM players WHERE nick='OJK'),
2668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2669 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2671 (SELECT player FROM players WHERE nick='OJK'),
2673 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2676 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2677 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2679 (SELECT player FROM players WHERE nick='OJK'),
2681 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2684 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2685 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2686 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2688 (SELECT player FROM players WHERE nick='DufF'),
2691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2694 (SELECT player FROM players WHERE nick='DufF'),
2696 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2700 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2702 (SELECT player FROM players WHERE nick='DufF'),
2704 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2707 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2708 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2709 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2711 (SELECT player FROM players WHERE nick='Snute'),
2714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2717 (SELECT player FROM players WHERE nick='Snute'),
2719 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2723 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2725 (SELECT player FROM players WHERE nick='Snute'),
2727 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2730 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2732 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2735 INSERT INTO groups (tournament, round, parallel) VALUES (
2736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2738 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2741 (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
2743 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2744 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2746 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2748 UPDATE rounds SET randomsongs=2 WHERE
2749 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2751 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2752 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2753 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2755 (SELECT player FROM players WHERE nick='DufF'),
2758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2759 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2761 (SELECT player FROM players WHERE nick='DufF'),
2763 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
2766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2769 (SELECT player FROM players WHERE nick='DufF'),
2771 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2774 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2775 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2778 (SELECT player FROM players WHERE nick='Snute'),
2781 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2782 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2784 (SELECT player FROM players WHERE nick='Snute'),
2786 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
2789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2790 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2792 (SELECT player FROM players WHERE nick='Snute'),
2794 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),