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 tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
57 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
58 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
60 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
61 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
63 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
66 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
69 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
70 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
72 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
75 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
76 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
77 22, 'Ted Kristian', 34);
78 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
79 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
81 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
82 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
84 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
85 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
87 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
88 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
90 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
93 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
96 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
99 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
102 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
105 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
107 32, 'Ole-Christian', 24);
108 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
113 INSERT INTO groups (tournament, round, parallel) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
116 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
119 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
121 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
124 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
126 UPDATE rounds SET randomsongs=2 WHERE
127 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
129 UPDATE rounds SET chosensongs=1 WHERE
130 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
133 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
136 (SELECT player FROM players WHERE nick='Ted Kristian'),
139 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
142 (SELECT player FROM players WHERE nick='Ted Kristian'),
144 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
147 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
150 (SELECT player FROM players WHERE nick='Ted Kristian'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
155 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
158 (SELECT player FROM players WHERE nick='Ted Kristian'),
160 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
163 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 );
164 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
167 (SELECT player FROM players WHERE nick='Pål Andre'),
170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
173 (SELECT player FROM players WHERE nick='Pål Andre'),
175 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
181 (SELECT player FROM players WHERE nick='Pål Andre'),
183 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
189 (SELECT player FROM players WHERE nick='Pål Andre'),
191 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
194 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
195 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
198 (SELECT player FROM players WHERE nick='Mulefisk'),
201 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
202 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
204 (SELECT player FROM players WHERE nick='Mulefisk'),
206 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
209 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
212 (SELECT player FROM players WHERE nick='Mulefisk'),
214 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='Mulefisk'),
222 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
225 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
226 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
227 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
229 (SELECT player FROM players WHERE nick='Haggar'),
232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
235 (SELECT player FROM players WHERE nick='Haggar'),
237 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
243 (SELECT player FROM players WHERE nick='Haggar'),
245 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='Haggar'),
253 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
256 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
257 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
260 (SELECT player FROM players WHERE nick='Snute'),
263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
266 (SELECT player FROM players WHERE nick='Snute'),
268 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
274 (SELECT player FROM players WHERE nick='Snute'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
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='Snute'),
284 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
287 INSERT INTO groups (tournament, round, parallel) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
290 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
293 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
295 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
298 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
300 UPDATE rounds SET randomsongs=2 WHERE
301 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
303 UPDATE rounds SET chosensongs=1 WHERE
304 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
306 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
308 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
310 (SELECT player FROM players WHERE nick='Jim Andre'),
313 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
316 (SELECT player FROM players WHERE nick='Jim Andre'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
321 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
324 (SELECT player FROM players WHERE nick='Jim Andre'),
326 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
329 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
332 (SELECT player FROM players WHERE nick='Jim Andre'),
334 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
337 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
338 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
341 (SELECT player FROM players WHERE nick='Andre'),
344 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
347 (SELECT player FROM players WHERE nick='Andre'),
349 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
352 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
353 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
355 (SELECT player FROM players WHERE nick='Andre'),
357 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
360 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
363 (SELECT player FROM players WHERE nick='Andre'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
368 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
369 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
372 (SELECT player FROM players WHERE nick='Dabi'),
375 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
378 (SELECT player FROM players WHERE nick='Dabi'),
380 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
383 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
384 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
386 (SELECT player FROM players WHERE nick='Dabi'),
388 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
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='Dabi'),
396 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
399 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
400 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
401 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
403 (SELECT player FROM players WHERE nick='Oliyzia'),
406 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
409 (SELECT player FROM players WHERE nick='Oliyzia'),
411 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
417 (SELECT player FROM players WHERE nick='Oliyzia'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
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='Oliyzia'),
427 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
430 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
431 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
434 (SELECT player FROM players WHERE nick='OJK'),
437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
440 (SELECT player FROM players WHERE nick='OJK'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
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='OJK'),
450 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
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='OJK'),
458 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
461 INSERT INTO groups (tournament, round, parallel) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
464 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
467 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
469 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
472 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
474 UPDATE rounds SET randomsongs=2 WHERE
475 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
477 UPDATE rounds SET chosensongs=1 WHERE
478 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
480 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
481 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
484 (SELECT player FROM players WHERE nick='Glukko'),
487 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
490 (SELECT player FROM players WHERE nick='Glukko'),
492 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
498 (SELECT player FROM players WHERE nick='Glukko'),
500 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
506 (SELECT player FROM players WHERE nick='Glukko'),
508 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
511 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players );
512 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
515 (SELECT player FROM players WHERE nick='Ole-Christian'),
518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
521 (SELECT player FROM players WHERE nick='Ole-Christian'),
523 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
527 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
529 (SELECT player FROM players WHERE nick='Ole-Christian'),
531 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
538 (SELECT player FROM players WHERE nick='Zyc'),
541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
544 (SELECT player FROM players WHERE nick='Zyc'),
546 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
552 (SELECT player FROM players WHERE nick='Zyc'),
554 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
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='Zyc'),
562 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
565 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
569 (SELECT player FROM players WHERE nick='Ylini'),
572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
575 (SELECT player FROM players WHERE nick='Ylini'),
577 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
583 (SELECT player FROM players WHERE nick='Ylini'),
585 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
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='Ylini'),
593 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
596 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
597 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
600 (SELECT player FROM players WHERE nick='DufF'),
603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
604 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
606 (SELECT player FROM players WHERE nick='DufF'),
608 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
611 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
614 (SELECT player FROM players WHERE nick='DufF'),
616 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
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='DufF'),
624 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
627 INSERT INTO groups (tournament, round, parallel) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
630 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
633 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
635 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
638 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
640 UPDATE rounds SET randomsongs=2 WHERE
641 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
643 UPDATE rounds SET chosensongs=1 WHERE
644 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
646 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
647 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
650 (SELECT player FROM players WHERE nick='Th0rny'),
653 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
654 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
656 (SELECT player FROM players WHERE nick='Th0rny'),
658 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
661 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
662 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
664 (SELECT player FROM players WHERE nick='Th0rny'),
666 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
672 (SELECT player FROM players WHERE nick='Th0rny'),
674 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
677 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
678 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
681 (SELECT player FROM players WHERE nick='Nameless'),
684 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
687 (SELECT player FROM players WHERE nick='Nameless'),
689 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
692 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
695 (SELECT player FROM players WHERE nick='Nameless'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
701 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
703 (SELECT player FROM players WHERE nick='Nameless'),
705 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
708 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
709 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
710 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
712 (SELECT player FROM players WHERE nick='Matsi'),
715 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
716 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
718 (SELECT player FROM players WHERE nick='Matsi'),
720 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
726 (SELECT player FROM players WHERE nick='Matsi'),
728 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
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='Matsi'),
736 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
739 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
740 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
741 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
743 (SELECT player FROM players WHERE nick='Draconia'),
746 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
749 (SELECT player FROM players WHERE nick='Draconia'),
751 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
754 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
757 (SELECT player FROM players WHERE nick='Draconia'),
759 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
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='Draconia'),
767 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
770 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
771 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
774 (SELECT player FROM players WHERE nick='RiChY'),
777 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
780 (SELECT player FROM players WHERE nick='RiChY'),
782 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
785 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
786 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
788 (SELECT player FROM players WHERE nick='RiChY'),
790 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
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='RiChY'),
798 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
801 INSERT INTO groups (tournament, round, parallel) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
804 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
807 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
809 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
812 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
814 UPDATE rounds SET randomsongs=2 WHERE
815 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
817 UPDATE rounds SET chosensongs=1 WHERE
818 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
820 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
821 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
824 (SELECT player FROM players WHERE nick='Eruanna'),
827 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
828 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
830 (SELECT player FROM players WHERE nick='Eruanna'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
836 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
838 (SELECT player FROM players WHERE nick='Eruanna'),
840 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
843 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
846 (SELECT player FROM players WHERE nick='Eruanna'),
848 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
851 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
852 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
853 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
855 (SELECT player FROM players WHERE nick='Advena'),
858 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
859 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
861 (SELECT player FROM players WHERE nick='Advena'),
863 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
866 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
867 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
869 (SELECT player FROM players WHERE nick='Advena'),
871 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
875 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
877 (SELECT player FROM players WHERE nick='Advena'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
882 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
883 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
886 (SELECT player FROM players WHERE nick='Tassen'),
889 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
890 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
892 (SELECT player FROM players WHERE nick='Tassen'),
894 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
900 (SELECT player FROM players WHERE nick='Tassen'),
902 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
908 (SELECT player FROM players WHERE nick='Tassen'),
910 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
913 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
914 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
917 (SELECT player FROM players WHERE nick='Duckling'),
920 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
923 (SELECT player FROM players WHERE nick='Duckling'),
925 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
931 (SELECT player FROM players WHERE nick='Duckling'),
933 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
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='Duckling'),
941 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
944 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
945 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
946 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
948 (SELECT player FROM players WHERE nick='Olemann'),
951 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
954 (SELECT player FROM players WHERE nick='Olemann'),
956 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
959 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
962 (SELECT player FROM players WHERE nick='Olemann'),
964 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
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='Olemann'),
972 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
975 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
976 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
979 (SELECT player FROM players WHERE nick='T|na'),
982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
985 (SELECT player FROM players WHERE nick='T|na'),
987 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
990 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
991 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
993 (SELECT player FROM players WHERE nick='T|na'),
995 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
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='T|na'),
1003 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1006 INSERT INTO groups (tournament, round, parallel) VALUES (
1007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1009 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1010 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1012 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
1014 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1019 UPDATE rounds SET randomsongs=2 WHERE
1020 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1022 UPDATE rounds SET chosensongs=1 WHERE
1023 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1025 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1026 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1027 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1029 (SELECT player FROM players WHERE nick='Bonzo'),
1032 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1033 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1035 (SELECT player FROM players WHERE nick='Bonzo'),
1037 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1041 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1043 (SELECT player FROM players WHERE nick='Bonzo'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1051 (SELECT player FROM players WHERE nick='Bonzo'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
1057 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1058 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1060 (SELECT player FROM players WHERE nick='Gollum'),
1063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1064 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1066 (SELECT player FROM players WHERE nick='Gollum'),
1068 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1071 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1072 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1074 (SELECT player FROM players WHERE nick='Gollum'),
1076 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1079 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1080 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1082 (SELECT player FROM players WHERE nick='Gollum'),
1084 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1087 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1088 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1089 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1091 (SELECT player FROM players WHERE nick='Hugo'),
1094 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1095 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1097 (SELECT player FROM players WHERE nick='Hugo'),
1099 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1105 (SELECT player FROM players WHERE nick='Hugo'),
1107 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1110 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1113 (SELECT player FROM players WHERE nick='Hugo'),
1115 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1118 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
1119 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1122 (SELECT player FROM players WHERE nick='Auran'),
1125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1128 (SELECT player FROM players WHERE nick='Auran'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1133 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1136 (SELECT player FROM players WHERE nick='Auran'),
1138 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1141 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1142 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1144 (SELECT player FROM players WHERE nick='Auran'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1149 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1150 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1153 (SELECT player FROM players WHERE nick='Smiph'),
1156 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1159 (SELECT player FROM players WHERE nick='Smiph'),
1161 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1164 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1167 (SELECT player FROM players WHERE nick='Smiph'),
1169 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1173 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1175 (SELECT player FROM players WHERE nick='Smiph'),
1177 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1184 (SELECT player FROM players WHERE nick='Stream'),
1187 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1190 (SELECT player FROM players WHERE nick='Stream'),
1192 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1195 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1198 (SELECT player FROM players WHERE nick='Stream'),
1200 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1204 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1206 (SELECT player FROM players WHERE nick='Stream'),
1208 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1211 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1216 INSERT INTO groups (tournament, round, parallel) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1219 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1222 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1224 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1227 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
1229 UPDATE rounds SET randomsongs=2 WHERE
1230 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1232 UPDATE rounds SET chosensongs=1 WHERE
1233 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1235 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1236 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1239 (SELECT player FROM players WHERE nick='Smiph'),
1242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1245 (SELECT player FROM players WHERE nick='Smiph'),
1247 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1253 (SELECT player FROM players WHERE nick='Smiph'),
1255 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1261 (SELECT player FROM players WHERE nick='Smiph'),
1263 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1266 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1267 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1268 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1270 (SELECT player FROM players WHERE nick='Mulefisk'),
1273 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1276 (SELECT player FROM players WHERE nick='Mulefisk'),
1278 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1284 (SELECT player FROM players WHERE nick='Mulefisk'),
1286 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1289 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1292 (SELECT player FROM players WHERE nick='Mulefisk'),
1294 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1297 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1298 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1301 (SELECT player FROM players WHERE nick='Oliyzia'),
1304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1307 (SELECT player FROM players WHERE nick='Oliyzia'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1315 (SELECT player FROM players WHERE nick='Oliyzia'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1323 (SELECT player FROM players WHERE nick='Oliyzia'),
1325 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1328 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
1329 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1332 (SELECT player FROM players WHERE nick='Th0rny'),
1335 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1338 (SELECT player FROM players WHERE nick='Th0rny'),
1340 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1346 (SELECT player FROM players WHERE nick='Th0rny'),
1348 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='Th0rny'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1359 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1360 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1363 (SELECT player FROM players WHERE nick='OJK'),
1366 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1369 (SELECT player FROM players WHERE nick='OJK'),
1371 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1377 (SELECT player FROM players WHERE nick='OJK'),
1379 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='OJK'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1390 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1394 (SELECT player FROM players WHERE nick='T|na'),
1397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1400 (SELECT player FROM players WHERE nick='T|na'),
1402 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1408 (SELECT player FROM players WHERE nick='T|na'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
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='T|na'),
1418 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1421 INSERT INTO groups (tournament, round, parallel) VALUES (
1422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1424 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1427 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1429 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1432 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
1434 UPDATE rounds SET randomsongs=2 WHERE
1435 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1437 UPDATE rounds SET chosensongs=1 WHERE
1438 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1440 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
1441 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1444 (SELECT player FROM players WHERE nick='Dabi'),
1447 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1450 (SELECT player FROM players WHERE nick='Dabi'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1458 (SELECT player FROM players WHERE nick='Dabi'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1466 (SELECT player FROM players WHERE nick='Dabi'),
1468 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1471 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1472 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1473 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1475 (SELECT player FROM players WHERE nick='Duckling'),
1478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1481 (SELECT player FROM players WHERE nick='Duckling'),
1483 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1489 (SELECT player FROM players WHERE nick='Duckling'),
1491 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1494 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1497 (SELECT player FROM players WHERE nick='Duckling'),
1499 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1502 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1503 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1506 (SELECT player FROM players WHERE nick='Ylini'),
1509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1512 (SELECT player FROM players WHERE nick='Ylini'),
1514 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1517 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1520 (SELECT player FROM players WHERE nick='Ylini'),
1522 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1525 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1528 (SELECT player FROM players WHERE nick='Ylini'),
1530 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1533 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1534 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1535 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1537 (SELECT player FROM players WHERE nick='Stream'),
1540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1543 (SELECT player FROM players WHERE nick='Stream'),
1545 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1548 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1551 (SELECT player FROM players WHERE nick='Stream'),
1553 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
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='Stream'),
1561 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1564 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1566 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1568 (SELECT player FROM players WHERE nick='Snute'),
1571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1574 (SELECT player FROM players WHERE nick='Snute'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1582 (SELECT player FROM players WHERE nick='Snute'),
1584 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
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='Snute'),
1592 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1595 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1599 (SELECT player FROM players WHERE nick='Hugo'),
1602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1605 (SELECT player FROM players WHERE nick='Hugo'),
1607 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1613 (SELECT player FROM players WHERE nick='Hugo'),
1615 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
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='Hugo'),
1623 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1626 INSERT INTO groups (tournament, round, parallel) VALUES (
1627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1629 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1632 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1634 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1635 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1637 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1639 UPDATE rounds SET randomsongs=2 WHERE
1640 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1642 UPDATE rounds SET chosensongs=1 WHERE
1643 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1645 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
1646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1649 (SELECT player FROM players WHERE nick='Zyc'),
1652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1655 (SELECT player FROM players WHERE nick='Zyc'),
1657 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1663 (SELECT player FROM players WHERE nick='Zyc'),
1665 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1671 (SELECT player FROM players WHERE nick='Zyc'),
1673 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1676 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1677 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1680 (SELECT player FROM players WHERE nick='Nameless'),
1683 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1684 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1686 (SELECT player FROM players WHERE nick='Nameless'),
1688 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1692 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1694 (SELECT player FROM players WHERE nick='Nameless'),
1696 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1702 (SELECT player FROM players WHERE nick='Nameless'),
1704 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1707 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1708 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1711 (SELECT player FROM players WHERE nick='Haggar'),
1714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1717 (SELECT player FROM players WHERE nick='Haggar'),
1719 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1725 (SELECT player FROM players WHERE nick='Haggar'),
1727 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1730 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1731 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1733 (SELECT player FROM players WHERE nick='Haggar'),
1735 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1738 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1739 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1740 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1742 (SELECT player FROM players WHERE nick='Olemann'),
1745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1748 (SELECT player FROM players WHERE nick='Olemann'),
1750 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1753 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1756 (SELECT player FROM players WHERE nick='Olemann'),
1758 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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='Olemann'),
1766 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1769 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1770 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1773 (SELECT player FROM players WHERE nick='RiChY'),
1776 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1777 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1779 (SELECT player FROM players WHERE nick='RiChY'),
1781 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
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='RiChY'),
1789 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
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='RiChY'),
1797 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
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('Exotic Ethnic')),
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('Stomp')),
1823 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1824 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1826 (SELECT player FROM players WHERE nick='DufF'),
1828 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1831 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1836 INSERT INTO groups (tournament, round, parallel) VALUES (
1837 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1839 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1842 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1844 UPDATE rounds SET randomsongs=1 WHERE
1845 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1847 UPDATE rounds SET chosensongs=1 WHERE
1848 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
1850 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1851 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1854 (SELECT player FROM players WHERE nick='Stream'),
1857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1858 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1860 (SELECT player FROM players WHERE nick='Stream'),
1862 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1866 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1868 (SELECT player FROM players WHERE nick='Stream'),
1870 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1873 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1874 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1875 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1877 (SELECT player FROM players WHERE nick='T|na'),
1880 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1881 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1883 (SELECT player FROM players WHERE nick='T|na'),
1885 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1888 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1889 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1891 (SELECT player FROM players WHERE nick='T|na'),
1893 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1896 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1900 (SELECT player FROM players WHERE nick='DufF'),
1903 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1904 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1906 (SELECT player FROM players WHERE nick='DufF'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1911 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1914 (SELECT player FROM players WHERE nick='DufF'),
1916 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1919 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1923 (SELECT player FROM players WHERE nick='OJK'),
1926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1929 (SELECT player FROM players WHERE nick='OJK'),
1931 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1937 (SELECT player FROM players WHERE nick='OJK'),
1939 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
1942 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1943 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1946 (SELECT player FROM players WHERE nick='Hugo'),
1949 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1950 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1952 (SELECT player FROM players WHERE nick='Hugo'),
1954 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1957 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1958 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1960 (SELECT player FROM players WHERE nick='Hugo'),
1962 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1965 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1966 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1969 (SELECT player FROM players WHERE nick='RiChY'),
1972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1975 (SELECT player FROM players WHERE nick='RiChY'),
1977 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1980 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1981 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1983 (SELECT player FROM players WHERE nick='RiChY'),
1985 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1988 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1989 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1990 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
1992 (SELECT player FROM players WHERE nick='Snute'),
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='Snute'),
2000 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2006 (SELECT player FROM players WHERE nick='Snute'),
2008 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2011 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2015 (SELECT player FROM players WHERE nick='Oliyzia'),
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='Oliyzia'),
2023 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2027 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2029 (SELECT player FROM players WHERE nick='Oliyzia'),
2031 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2034 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2035 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2036 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2038 (SELECT player FROM players WHERE nick='Haggar'),
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='Haggar'),
2046 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2049 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2052 (SELECT player FROM players WHERE nick='Haggar'),
2054 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2057 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2059 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2062 INSERT INTO groups (tournament, round, parallel) VALUES (
2063 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2065 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2068 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
2070 UPDATE rounds SET randomsongs=1 WHERE
2071 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2073 UPDATE rounds SET chosensongs=1 WHERE
2074 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2076 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2077 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2080 (SELECT player FROM players WHERE nick='Haggar'),
2083 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2084 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2086 (SELECT player FROM players WHERE nick='Haggar'),
2088 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2092 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2094 (SELECT player FROM players WHERE nick='Haggar'),
2096 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2099 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2100 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2101 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2103 (SELECT player FROM players WHERE nick='Hugo'),
2106 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2107 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2109 (SELECT player FROM players WHERE nick='Hugo'),
2111 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2115 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2117 (SELECT player FROM players WHERE nick='Hugo'),
2119 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2122 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2123 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2126 (SELECT player FROM players WHERE nick='RiChY'),
2129 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2130 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2132 (SELECT player FROM players WHERE nick='RiChY'),
2134 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2137 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2138 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2140 (SELECT player FROM players WHERE nick='RiChY'),
2142 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2145 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2146 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2149 (SELECT player FROM players WHERE nick='OJK'),
2152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2155 (SELECT player FROM players WHERE nick='OJK'),
2157 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2163 (SELECT player FROM players WHERE nick='OJK'),
2165 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2169 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2172 (SELECT player FROM players WHERE nick='Oliyzia'),
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='Oliyzia'),
2180 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2186 (SELECT player FROM players WHERE nick='Oliyzia'),
2188 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2195 (SELECT player FROM players WHERE nick='Snute'),
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='Snute'),
2203 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2209 (SELECT player FROM players WHERE nick='Snute'),
2211 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2214 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2215 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2218 (SELECT player FROM players WHERE nick='DufF'),
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('era (nostalmix)')),
2229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2232 (SELECT player FROM players WHERE nick='DufF'),
2234 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2237 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2242 INSERT INTO groups (tournament, round, parallel) VALUES (
2243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2245 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2248 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
2250 UPDATE rounds SET randomsongs=1 WHERE
2251 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2253 UPDATE rounds SET chosensongs=1 WHERE
2254 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2256 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2257 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2260 (SELECT player FROM players WHERE nick='Hugo'),
2263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2266 (SELECT player FROM players WHERE nick='Hugo'),
2268 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2274 (SELECT player FROM players WHERE nick='Hugo'),
2276 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2283 (SELECT player FROM players WHERE nick='RiChY'),
2286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2289 (SELECT player FROM players WHERE nick='RiChY'),
2291 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2297 (SELECT player FROM players WHERE nick='RiChY'),
2299 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2302 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2303 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2306 (SELECT player FROM players WHERE nick='DufF'),
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='DufF'),
2314 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2320 (SELECT player FROM players WHERE nick='DufF'),
2322 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2325 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2326 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2329 (SELECT player FROM players WHERE nick='Oliyzia'),
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('B4U')),
2340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2343 (SELECT player FROM players WHERE nick='Oliyzia'),
2345 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2348 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2352 (SELECT player FROM players WHERE nick='Snute'),
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('B4U')),
2363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2366 (SELECT player FROM players WHERE nick='Snute'),
2368 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2371 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2376 INSERT INTO groups (tournament, round, parallel) VALUES (
2377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2379 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2382 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
2384 UPDATE rounds SET randomsongs=1 WHERE
2385 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2387 UPDATE rounds SET chosensongs=1 WHERE
2388 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2390 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2394 (SELECT player FROM players WHERE nick='Hugo'),
2397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2400 (SELECT player FROM players WHERE nick='Hugo'),
2402 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2408 (SELECT player FROM players WHERE nick='Hugo'),
2410 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2413 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2414 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2417 (SELECT player FROM players WHERE nick='Oliyzia'),
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='Oliyzia'),
2425 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2429 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2431 (SELECT player FROM players WHERE nick='Oliyzia'),
2433 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2436 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2437 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2440 (SELECT player FROM players WHERE nick='Snute'),
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='Snute'),
2448 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2454 (SELECT player FROM players WHERE nick='Snute'),
2456 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2459 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2460 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2463 (SELECT player FROM players WHERE nick='DufF'),
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='DufF'),
2471 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2475 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2477 (SELECT player FROM players WHERE nick='DufF'),
2479 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2482 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2487 INSERT INTO groups (tournament, round, parallel) VALUES (
2488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2490 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2493 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
2495 UPDATE rounds SET randomsongs=1 WHERE
2496 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2498 UPDATE rounds SET chosensongs=1 WHERE
2499 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2501 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2502 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2503 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2505 (SELECT player FROM players WHERE nick='Hugo'),
2508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2511 (SELECT player FROM players WHERE nick='Hugo'),
2513 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2519 (SELECT player FROM players WHERE nick='Hugo'),
2521 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2524 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2525 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2528 (SELECT player FROM players WHERE nick='DufF'),
2531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2534 (SELECT player FROM players WHERE nick='DufF'),
2536 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2542 (SELECT player FROM players WHERE nick='DufF'),
2544 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2547 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2548 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2551 (SELECT player FROM players WHERE nick='Snute'),
2554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2557 (SELECT player FROM players WHERE nick='Snute'),
2559 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2565 (SELECT player FROM players WHERE nick='Snute'),
2567 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2570 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2575 INSERT INTO groups (tournament, round, parallel) VALUES (
2576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2578 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2581 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
2583 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2586 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2588 UPDATE rounds SET randomsongs=2 WHERE
2589 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3') AND
2591 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2592 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2595 (SELECT player FROM players WHERE nick='DufF'),
2598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2601 (SELECT player FROM players WHERE nick='DufF'),
2603 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2609 (SELECT player FROM players WHERE nick='DufF'),
2611 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2614 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2615 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2618 (SELECT player FROM players WHERE nick='Snute'),
2621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2624 (SELECT player FROM players WHERE nick='Snute'),
2626 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
2632 (SELECT player FROM players WHERE nick='Snute'),
2634 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),