2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
23 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
40 (SELECT player FROM players WHERE nick='Ted Kristian'),
43 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
46 (SELECT player FROM players WHERE nick='Ted Kristian'),
48 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
54 (SELECT player FROM players WHERE nick='Ted Kristian'),
56 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
62 (SELECT player FROM players WHERE nick='Ted Kristian'),
64 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
67 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' NOT IN ( SELECT nick FROM players );
68 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
69 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
71 (SELECT player FROM players WHERE nick='Pål Andre'),
74 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
75 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
77 (SELECT player FROM players WHERE nick='Pål Andre'),
79 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
85 (SELECT player FROM players WHERE nick='Pål Andre'),
87 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
93 (SELECT player FROM players WHERE nick='Pål Andre'),
95 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
99 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
102 (SELECT player FROM players WHERE nick='Mulefisk'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
108 (SELECT player FROM players WHERE nick='Mulefisk'),
110 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
116 (SELECT player FROM players WHERE nick='Mulefisk'),
118 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
124 (SELECT player FROM players WHERE nick='Mulefisk'),
126 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
133 (SELECT player FROM players WHERE nick='Haggar'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
139 (SELECT player FROM players WHERE nick='Haggar'),
141 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
147 (SELECT player FROM players WHERE nick='Haggar'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
155 (SELECT player FROM players WHERE nick='Haggar'),
157 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
164 (SELECT player FROM players WHERE nick='Snute'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
170 (SELECT player FROM players WHERE nick='Snute'),
172 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
178 (SELECT player FROM players WHERE nick='Snute'),
180 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
186 (SELECT player FROM players WHERE nick='Snute'),
188 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
191 INSERT INTO groups (tournament, round, parallel) VALUES (
192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
194 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
197 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
199 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
202 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
204 UPDATE rounds SET randomsongs=2 WHERE
205 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
207 UPDATE rounds SET chosensongs=1 WHERE
208 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
214 (SELECT player FROM players WHERE nick='Jim Andre'),
217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
220 (SELECT player FROM players WHERE nick='Jim Andre'),
222 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
228 (SELECT player FROM players WHERE nick='Jim Andre'),
230 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
236 (SELECT player FROM players WHERE nick='Jim Andre'),
238 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
245 (SELECT player FROM players WHERE nick='Andre'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
251 (SELECT player FROM players WHERE nick='Andre'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
259 (SELECT player FROM players WHERE nick='Andre'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
267 (SELECT player FROM players WHERE nick='Andre'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
276 (SELECT player FROM players WHERE nick='Dabi'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
282 (SELECT player FROM players WHERE nick='Dabi'),
284 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
290 (SELECT player FROM players WHERE nick='Dabi'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
298 (SELECT player FROM players WHERE nick='Dabi'),
300 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
307 (SELECT player FROM players WHERE nick='Oliyzia'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
313 (SELECT player FROM players WHERE nick='Oliyzia'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
321 (SELECT player FROM players WHERE nick='Oliyzia'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
329 (SELECT player FROM players WHERE nick='Oliyzia'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
338 (SELECT player FROM players WHERE nick='OJK'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
344 (SELECT player FROM players WHERE nick='OJK'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
352 (SELECT player FROM players WHERE nick='OJK'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
360 (SELECT player FROM players WHERE nick='OJK'),
362 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
365 INSERT INTO groups (tournament, round, parallel) VALUES (
366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
368 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
371 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
373 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
376 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
378 UPDATE rounds SET randomsongs=2 WHERE
379 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
381 UPDATE rounds SET chosensongs=1 WHERE
382 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
384 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
388 (SELECT player FROM players WHERE nick='Glukko'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
394 (SELECT player FROM players WHERE nick='Glukko'),
396 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
402 (SELECT player FROM players WHERE nick='Glukko'),
404 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
410 (SELECT player FROM players WHERE nick='Glukko'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
415 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players );
416 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
419 (SELECT player FROM players WHERE nick='Ole-Christian'),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
425 (SELECT player FROM players WHERE nick='Ole-Christian'),
427 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
433 (SELECT player FROM players WHERE nick='Ole-Christian'),
435 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
442 (SELECT player FROM players WHERE nick='Zyc'),
445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
448 (SELECT player FROM players WHERE nick='Zyc'),
450 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
456 (SELECT player FROM players WHERE nick='Zyc'),
458 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
464 (SELECT player FROM players WHERE nick='Zyc'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
469 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
470 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
473 (SELECT player FROM players WHERE nick='Ylini'),
476 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
479 (SELECT player FROM players WHERE nick='Ylini'),
481 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
487 (SELECT player FROM players WHERE nick='Ylini'),
489 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
495 (SELECT player FROM players WHERE nick='Ylini'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
500 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
501 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
504 (SELECT player FROM players WHERE nick='DufF'),
507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
510 (SELECT player FROM players WHERE nick='DufF'),
512 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
518 (SELECT player FROM players WHERE nick='DufF'),
520 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
526 (SELECT player FROM players WHERE nick='DufF'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
531 INSERT INTO groups (tournament, round, parallel) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
534 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
535 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
537 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
539 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
542 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
544 UPDATE rounds SET randomsongs=2 WHERE
545 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
547 UPDATE rounds SET chosensongs=1 WHERE
548 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
554 (SELECT player FROM players WHERE nick='Th0rny'),
557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
558 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
560 (SELECT player FROM players WHERE nick='Th0rny'),
562 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
565 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
566 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
568 (SELECT player FROM players WHERE nick='Th0rny'),
570 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
576 (SELECT player FROM players WHERE nick='Th0rny'),
578 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
581 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
582 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
583 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
585 (SELECT player FROM players WHERE nick='Nameless'),
588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
591 (SELECT player FROM players WHERE nick='Nameless'),
593 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
599 (SELECT player FROM players WHERE nick='Nameless'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
607 (SELECT player FROM players WHERE nick='Nameless'),
609 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
612 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
613 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
614 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
616 (SELECT player FROM players WHERE nick='Matsi'),
619 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
622 (SELECT player FROM players WHERE nick='Matsi'),
624 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
630 (SELECT player FROM players WHERE nick='Matsi'),
632 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
638 (SELECT player FROM players WHERE nick='Matsi'),
640 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
643 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
647 (SELECT player FROM players WHERE nick='Draconia'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
653 (SELECT player FROM players WHERE nick='Draconia'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
661 (SELECT player FROM players WHERE nick='Draconia'),
663 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
669 (SELECT player FROM players WHERE nick='Draconia'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
674 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
675 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
678 (SELECT player FROM players WHERE nick='RiChY'),
681 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
684 (SELECT player FROM players WHERE nick='RiChY'),
686 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
692 (SELECT player FROM players WHERE nick='RiChY'),
694 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
700 (SELECT player FROM players WHERE nick='RiChY'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
705 INSERT INTO groups (tournament, round, parallel) VALUES (
706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
708 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
713 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
714 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
716 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
718 UPDATE rounds SET randomsongs=2 WHERE
719 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
721 UPDATE rounds SET chosensongs=1 WHERE
722 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
724 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
725 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
728 (SELECT player FROM players WHERE nick='Eruanna'),
731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
732 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
734 (SELECT player FROM players WHERE nick='Eruanna'),
736 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
739 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
740 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
742 (SELECT player FROM players WHERE nick='Eruanna'),
744 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
747 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
748 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
750 (SELECT player FROM players WHERE nick='Eruanna'),
752 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
755 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
756 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
757 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
759 (SELECT player FROM players WHERE nick='Advena'),
762 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
763 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
765 (SELECT player FROM players WHERE nick='Advena'),
767 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
773 (SELECT player FROM players WHERE nick='Advena'),
775 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
781 (SELECT player FROM players WHERE nick='Advena'),
783 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
786 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
787 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
790 (SELECT player FROM players WHERE nick='Tassen'),
793 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
794 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
796 (SELECT player FROM players WHERE nick='Tassen'),
798 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
804 (SELECT player FROM players WHERE nick='Tassen'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
812 (SELECT player FROM players WHERE nick='Tassen'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
817 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
818 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
821 (SELECT player FROM players WHERE nick='Duckling'),
824 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
825 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
827 (SELECT player FROM players WHERE nick='Duckling'),
829 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
835 (SELECT player FROM players WHERE nick='Duckling'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
843 (SELECT player FROM players WHERE nick='Duckling'),
845 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
848 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
849 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
850 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
852 (SELECT player FROM players WHERE nick='Olemann'),
855 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
858 (SELECT player FROM players WHERE nick='Olemann'),
860 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
863 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
866 (SELECT player FROM players WHERE nick='Olemann'),
868 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
874 (SELECT player FROM players WHERE nick='Olemann'),
876 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
879 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
880 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
881 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
883 (SELECT player FROM players WHERE nick='T|na'),
886 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
887 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
889 (SELECT player FROM players WHERE nick='T|na'),
891 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
897 (SELECT player FROM players WHERE nick='T|na'),
899 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
905 (SELECT player FROM players WHERE nick='T|na'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
910 INSERT INTO groups (tournament, round, parallel) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
913 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
916 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
918 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
919 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
921 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
923 UPDATE rounds SET randomsongs=2 WHERE
924 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
926 UPDATE rounds SET chosensongs=1 WHERE
927 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
929 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
930 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
933 (SELECT player FROM players WHERE nick='Bonzo'),
936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
939 (SELECT player FROM players WHERE nick='Bonzo'),
941 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
947 (SELECT player FROM players WHERE nick='Bonzo'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
952 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
955 (SELECT player FROM players WHERE nick='Bonzo'),
957 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
960 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
961 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
962 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
964 (SELECT player FROM players WHERE nick='Gollum'),
967 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
968 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
970 (SELECT player FROM players WHERE nick='Gollum'),
972 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
975 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
976 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
978 (SELECT player FROM players WHERE nick='Gollum'),
980 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
983 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
984 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
986 (SELECT player FROM players WHERE nick='Gollum'),
988 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
991 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
992 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
995 (SELECT player FROM players WHERE nick='Hugo'),
998 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1001 (SELECT player FROM players WHERE nick='Hugo'),
1003 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1009 (SELECT player FROM players WHERE nick='Hugo'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1017 (SELECT player FROM players WHERE nick='Hugo'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1022 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
1023 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1024 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1026 (SELECT player FROM players WHERE nick='Auran'),
1029 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1032 (SELECT player FROM players WHERE nick='Auran'),
1034 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1038 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1040 (SELECT player FROM players WHERE nick='Auran'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1048 (SELECT player FROM players WHERE nick='Auran'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1053 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1055 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1057 (SELECT player FROM players WHERE nick='Smiph'),
1060 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1063 (SELECT player FROM players WHERE nick='Smiph'),
1065 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1071 (SELECT player FROM players WHERE nick='Smiph'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1079 (SELECT player FROM players WHERE nick='Smiph'),
1081 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1084 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1085 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1088 (SELECT player FROM players WHERE nick='Stream'),
1091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1092 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1094 (SELECT player FROM players WHERE nick='Stream'),
1096 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1102 (SELECT player FROM players WHERE nick='Stream'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1110 (SELECT player FROM players WHERE nick='Stream'),
1112 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1115 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1120 INSERT INTO groups (tournament, round, parallel) VALUES (
1121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1123 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1126 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1128 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1129 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
1133 UPDATE rounds SET randomsongs=2 WHERE
1134 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1136 UPDATE rounds SET chosensongs=1 WHERE
1137 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1139 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1140 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1143 (SELECT player FROM players WHERE nick='Smiph'),
1146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1149 (SELECT player FROM players WHERE nick='Smiph'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1154 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1155 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1157 (SELECT player FROM players WHERE nick='Smiph'),
1159 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1163 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1165 (SELECT player FROM players WHERE nick='Smiph'),
1167 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1170 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1171 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1172 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1174 (SELECT player FROM players WHERE nick='Mulefisk'),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1180 (SELECT player FROM players WHERE nick='Mulefisk'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1186 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1188 (SELECT player FROM players WHERE nick='Mulefisk'),
1190 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1193 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1196 (SELECT player FROM players WHERE nick='Mulefisk'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1201 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1202 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1203 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1205 (SELECT player FROM players WHERE nick='Oliyzia'),
1208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1211 (SELECT player FROM players WHERE nick='Oliyzia'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1219 (SELECT player FROM players WHERE nick='Oliyzia'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1227 (SELECT player FROM players WHERE nick='Oliyzia'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1232 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
1233 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1236 (SELECT player FROM players WHERE nick='Th0rny'),
1239 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1242 (SELECT player FROM players WHERE nick='Th0rny'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1250 (SELECT player FROM players WHERE nick='Th0rny'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1258 (SELECT player FROM players WHERE nick='Th0rny'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1263 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1264 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1267 (SELECT player FROM players WHERE nick='OJK'),
1270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1273 (SELECT player FROM players WHERE nick='OJK'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1281 (SELECT player FROM players WHERE nick='OJK'),
1283 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1289 (SELECT player FROM players WHERE nick='OJK'),
1291 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1294 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1298 (SELECT player FROM players WHERE nick='T|na'),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1304 (SELECT player FROM players WHERE nick='T|na'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1312 (SELECT player FROM players WHERE nick='T|na'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1320 (SELECT player FROM players WHERE nick='T|na'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1325 INSERT INTO groups (tournament, round, parallel) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1328 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1331 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1333 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
1338 UPDATE rounds SET randomsongs=2 WHERE
1339 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1341 UPDATE rounds SET chosensongs=1 WHERE
1342 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1344 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
1345 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1346 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1348 (SELECT player FROM players WHERE nick='Dabi'),
1351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1354 (SELECT player FROM players WHERE nick='Dabi'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1359 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1362 (SELECT player FROM players WHERE nick='Dabi'),
1364 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1367 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1368 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1370 (SELECT player FROM players WHERE nick='Dabi'),
1372 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1375 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1376 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1379 (SELECT player FROM players WHERE nick='Duckling'),
1382 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1383 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1385 (SELECT player FROM players WHERE nick='Duckling'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1390 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1391 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1393 (SELECT player FROM players WHERE nick='Duckling'),
1395 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1399 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1401 (SELECT player FROM players WHERE nick='Duckling'),
1403 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1406 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1407 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1410 (SELECT player FROM players WHERE nick='Ylini'),
1413 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1416 (SELECT player FROM players WHERE nick='Ylini'),
1418 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1424 (SELECT player FROM players WHERE nick='Ylini'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1432 (SELECT player FROM players WHERE nick='Ylini'),
1434 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1437 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1438 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1441 (SELECT player FROM players WHERE nick='Stream'),
1444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1445 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1447 (SELECT player FROM players WHERE nick='Stream'),
1449 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1455 (SELECT player FROM players WHERE nick='Stream'),
1457 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1463 (SELECT player FROM players WHERE nick='Stream'),
1465 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1468 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1469 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1472 (SELECT player FROM players WHERE nick='Snute'),
1475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1478 (SELECT player FROM players WHERE nick='Snute'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1486 (SELECT player FROM players WHERE nick='Snute'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1491 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1492 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1494 (SELECT player FROM players WHERE nick='Snute'),
1496 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1499 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1500 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1503 (SELECT player FROM players WHERE nick='Hugo'),
1506 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1509 (SELECT player FROM players WHERE nick='Hugo'),
1511 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1514 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1515 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1517 (SELECT player FROM players WHERE nick='Hugo'),
1519 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1522 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1523 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1525 (SELECT player FROM players WHERE nick='Hugo'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1530 INSERT INTO groups (tournament, round, parallel) VALUES (
1531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1533 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1534 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1536 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1538 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1541 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1543 UPDATE rounds SET randomsongs=2 WHERE
1544 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1546 UPDATE rounds SET chosensongs=1 WHERE
1547 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1549 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
1550 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1553 (SELECT player FROM players WHERE nick='Zyc'),
1556 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1557 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1559 (SELECT player FROM players WHERE nick='Zyc'),
1561 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1564 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1565 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1567 (SELECT player FROM players WHERE nick='Zyc'),
1569 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1575 (SELECT player FROM players WHERE nick='Zyc'),
1577 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1580 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1581 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1582 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1584 (SELECT player FROM players WHERE nick='Nameless'),
1587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1588 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1590 (SELECT player FROM players WHERE nick='Nameless'),
1592 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1595 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1596 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1598 (SELECT player FROM players WHERE nick='Nameless'),
1600 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1604 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1606 (SELECT player FROM players WHERE nick='Nameless'),
1608 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1611 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1612 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1613 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1615 (SELECT player FROM players WHERE nick='Haggar'),
1618 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1619 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1621 (SELECT player FROM players WHERE nick='Haggar'),
1623 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1626 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1629 (SELECT player FROM players WHERE nick='Haggar'),
1631 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1634 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1635 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1637 (SELECT player FROM players WHERE nick='Haggar'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1642 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1643 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1646 (SELECT player FROM players WHERE nick='Olemann'),
1649 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1650 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1652 (SELECT player FROM players WHERE nick='Olemann'),
1654 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1660 (SELECT player FROM players WHERE nick='Olemann'),
1662 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1668 (SELECT player FROM players WHERE nick='Olemann'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1673 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1677 (SELECT player FROM players WHERE nick='RiChY'),
1680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1683 (SELECT player FROM players WHERE nick='RiChY'),
1685 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1691 (SELECT player FROM players WHERE nick='RiChY'),
1693 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1699 (SELECT player FROM players WHERE nick='RiChY'),
1701 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1704 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1705 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1708 (SELECT player FROM players WHERE nick='DufF'),
1711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1714 (SELECT player FROM players WHERE nick='DufF'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1722 (SELECT player FROM players WHERE nick='DufF'),
1724 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1730 (SELECT player FROM players WHERE nick='DufF'),
1732 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1735 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1740 INSERT INTO groups (tournament, round, parallel) VALUES (
1741 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1743 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1746 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1748 UPDATE rounds SET randomsongs=1 WHERE
1749 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1751 UPDATE rounds SET chosensongs=1 WHERE
1752 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1754 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1755 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1756 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1758 (SELECT player FROM players WHERE nick='Stream'),
1761 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1762 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1764 (SELECT player FROM players WHERE nick='Stream'),
1766 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1769 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1770 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1772 (SELECT player FROM players WHERE nick='Stream'),
1774 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1777 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1778 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1781 (SELECT player FROM players WHERE nick='T|na'),
1784 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1785 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1787 (SELECT player FROM players WHERE nick='T|na'),
1789 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1792 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1793 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1795 (SELECT player FROM players WHERE nick='T|na'),
1797 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1800 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1801 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1804 (SELECT player FROM players WHERE nick='DufF'),
1807 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1810 (SELECT player FROM players WHERE nick='DufF'),
1812 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1815 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1818 (SELECT player FROM players WHERE nick='DufF'),
1820 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1823 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1824 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1825 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1827 (SELECT player FROM players WHERE nick='OJK'),
1830 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1833 (SELECT player FROM players WHERE nick='OJK'),
1835 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1841 (SELECT player FROM players WHERE nick='OJK'),
1843 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
1846 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1847 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1850 (SELECT player FROM players WHERE nick='Hugo'),
1853 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1856 (SELECT player FROM players WHERE nick='Hugo'),
1858 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1861 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1864 (SELECT player FROM players WHERE nick='Hugo'),
1866 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1869 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1870 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1871 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1873 (SELECT player FROM players WHERE nick='RiChY'),
1876 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1879 (SELECT player FROM players WHERE nick='RiChY'),
1881 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1884 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1885 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1887 (SELECT player FROM players WHERE nick='RiChY'),
1889 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1892 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1893 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1896 (SELECT player FROM players WHERE nick='Snute'),
1899 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1902 (SELECT player FROM players WHERE nick='Snute'),
1904 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1907 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1908 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1910 (SELECT player FROM players WHERE nick='Snute'),
1912 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1915 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1916 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1917 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1919 (SELECT player FROM players WHERE nick='Oliyzia'),
1922 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1925 (SELECT player FROM players WHERE nick='Oliyzia'),
1927 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1933 (SELECT player FROM players WHERE nick='Oliyzia'),
1935 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1938 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1939 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1940 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1942 (SELECT player FROM players WHERE nick='Haggar'),
1945 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1946 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1948 (SELECT player FROM players WHERE nick='Haggar'),
1950 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1953 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1954 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1956 (SELECT player FROM players WHERE nick='Haggar'),
1958 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1961 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1966 INSERT INTO groups (tournament, round, parallel) VALUES (
1967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1969 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1970 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1972 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
1974 UPDATE rounds SET randomsongs=1 WHERE
1975 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1977 UPDATE rounds SET chosensongs=1 WHERE
1978 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1980 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1984 (SELECT player FROM players WHERE nick='Haggar'),
1987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1990 (SELECT player FROM players WHERE nick='Haggar'),
1992 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1998 (SELECT player FROM players WHERE nick='Haggar'),
2000 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2003 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2004 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2007 (SELECT player FROM players WHERE nick='Hugo'),
2010 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2013 (SELECT player FROM players WHERE nick='Hugo'),
2015 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2021 (SELECT player FROM players WHERE nick='Hugo'),
2023 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2026 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2027 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2028 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2030 (SELECT player FROM players WHERE nick='RiChY'),
2033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2036 (SELECT player FROM players WHERE nick='RiChY'),
2038 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2041 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2044 (SELECT player FROM players WHERE nick='RiChY'),
2046 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2049 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2050 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2053 (SELECT player FROM players WHERE nick='OJK'),
2056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2059 (SELECT player FROM players WHERE nick='OJK'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2064 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2067 (SELECT player FROM players WHERE nick='OJK'),
2069 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2072 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2073 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2074 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2076 (SELECT player FROM players WHERE nick='Oliyzia'),
2079 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2080 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2082 (SELECT player FROM players WHERE nick='Oliyzia'),
2084 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2087 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2090 (SELECT player FROM players WHERE nick='Oliyzia'),
2092 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2095 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2096 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2099 (SELECT player FROM players WHERE nick='Snute'),
2102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2105 (SELECT player FROM players WHERE nick='Snute'),
2107 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2110 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2113 (SELECT player FROM players WHERE nick='Snute'),
2115 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2118 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2119 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2122 (SELECT player FROM players WHERE nick='DufF'),
2125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2128 (SELECT player FROM players WHERE nick='DufF'),
2130 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2133 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2136 (SELECT player FROM players WHERE nick='DufF'),
2138 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2141 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2146 INSERT INTO groups (tournament, round, parallel) VALUES (
2147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2149 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2150 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2152 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
2154 UPDATE rounds SET randomsongs=1 WHERE
2155 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2157 UPDATE rounds SET chosensongs=1 WHERE
2158 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2164 (SELECT player FROM players WHERE nick='Hugo'),
2167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2170 (SELECT player FROM players WHERE nick='Hugo'),
2172 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2178 (SELECT player FROM players WHERE nick='Hugo'),
2180 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2183 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2184 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2185 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2187 (SELECT player FROM players WHERE nick='RiChY'),
2190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2193 (SELECT player FROM players WHERE nick='RiChY'),
2195 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2201 (SELECT player FROM players WHERE nick='RiChY'),
2203 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2206 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2207 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2210 (SELECT player FROM players WHERE nick='DufF'),
2213 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2216 (SELECT player FROM players WHERE nick='DufF'),
2218 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2221 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2224 (SELECT player FROM players WHERE nick='DufF'),
2226 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2229 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2230 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2233 (SELECT player FROM players WHERE nick='Oliyzia'),
2236 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2239 (SELECT player FROM players WHERE nick='Oliyzia'),
2241 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2244 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2247 (SELECT player FROM players WHERE nick='Oliyzia'),
2249 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2252 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2253 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2256 (SELECT player FROM players WHERE nick='Snute'),
2259 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2262 (SELECT player FROM players WHERE nick='Snute'),
2264 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2267 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2268 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2270 (SELECT player FROM players WHERE nick='Snute'),
2272 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2275 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2280 INSERT INTO groups (tournament, round, parallel) VALUES (
2281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2283 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2286 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
2288 UPDATE rounds SET randomsongs=1 WHERE
2289 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2291 UPDATE rounds SET chosensongs=1 WHERE
2292 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2294 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2298 (SELECT player FROM players WHERE nick='Hugo'),
2301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2304 (SELECT player FROM players WHERE nick='Hugo'),
2306 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2312 (SELECT player FROM players WHERE nick='Hugo'),
2314 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2317 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2318 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2321 (SELECT player FROM players WHERE nick='Oliyzia'),
2324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2327 (SELECT player FROM players WHERE nick='Oliyzia'),
2329 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2335 (SELECT player FROM players WHERE nick='Oliyzia'),
2337 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2340 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2341 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2344 (SELECT player FROM players WHERE nick='Snute'),
2347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2350 (SELECT player FROM players WHERE nick='Snute'),
2352 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2358 (SELECT player FROM players WHERE nick='Snute'),
2360 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2363 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2367 (SELECT player FROM players WHERE nick='DufF'),
2370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2371 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2373 (SELECT player FROM players WHERE nick='DufF'),
2375 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2378 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2381 (SELECT player FROM players WHERE nick='DufF'),
2383 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2386 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2391 INSERT INTO groups (tournament, round, parallel) VALUES (
2392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2394 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2397 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
2399 UPDATE rounds SET randomsongs=1 WHERE
2400 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2402 UPDATE rounds SET chosensongs=1 WHERE
2403 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2405 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2406 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2407 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2409 (SELECT player FROM players WHERE nick='Hugo'),
2412 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2413 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2415 (SELECT player FROM players WHERE nick='Hugo'),
2417 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2420 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2421 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2423 (SELECT player FROM players WHERE nick='Hugo'),
2425 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2428 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2429 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2432 (SELECT player FROM players WHERE nick='DufF'),
2435 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2436 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2438 (SELECT player FROM players WHERE nick='DufF'),
2440 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2443 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2444 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2446 (SELECT player FROM players WHERE nick='DufF'),
2448 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2451 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2452 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2455 (SELECT player FROM players WHERE nick='Snute'),
2458 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2459 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2461 (SELECT player FROM players WHERE nick='Snute'),
2463 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2466 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2467 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2469 (SELECT player FROM players WHERE nick='Snute'),
2471 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2474 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2479 INSERT INTO groups (tournament, round, parallel) VALUES (
2480 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2482 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2485 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
2487 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2490 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2492 UPDATE rounds SET randomsongs=2 WHERE
2493 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2495 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2496 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2499 (SELECT player FROM players WHERE nick='DufF'),
2502 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2503 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2505 (SELECT player FROM players WHERE nick='DufF'),
2507 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2511 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2513 (SELECT player FROM players WHERE nick='DufF'),
2515 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2518 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2519 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2522 (SELECT player FROM players WHERE nick='Snute'),
2525 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2528 (SELECT player FROM players WHERE nick='Snute'),
2530 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2533 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2534 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2536 (SELECT player FROM players WHERE nick='Snute'),
2538 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),