2 INSERT INTO tournaments
3 (season, name, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE name='Norway'),
9 (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
23 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
40 (SELECT player FROM players WHERE nick='Ted Kristian'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
46 (SELECT player FROM players WHERE nick='Ted Kristian'),
47 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
53 (SELECT player FROM players WHERE nick='Ted Kristian'),
54 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
57 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
60 (SELECT player FROM players WHERE nick='Ted Kristian'),
61 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
64 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 );
65 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
66 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
68 (SELECT player FROM players WHERE nick='Pål Andre'),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
74 (SELECT player FROM players WHERE nick='Pål Andre'),
75 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
81 (SELECT player FROM players WHERE nick='Pål Andre'),
82 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
88 (SELECT player FROM players WHERE nick='Pål Andre'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
93 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
94 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
96 (SELECT player FROM players WHERE nick='Mulefisk'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
102 (SELECT player FROM players WHERE nick='Mulefisk'),
103 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
109 (SELECT player FROM players WHERE nick='Mulefisk'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
116 (SELECT player FROM players WHERE nick='Mulefisk'),
117 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
124 (SELECT player FROM players WHERE nick='Haggar'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
130 (SELECT player FROM players WHERE nick='Haggar'),
131 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
137 (SELECT player FROM players WHERE nick='Haggar'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
144 (SELECT player FROM players WHERE nick='Haggar'),
145 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
152 (SELECT player FROM players WHERE nick='Snute'),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
158 (SELECT player FROM players WHERE nick='Snute'),
159 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
165 (SELECT player FROM players WHERE nick='Snute'),
166 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
172 (SELECT player FROM players WHERE nick='Snute'),
173 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
176 INSERT INTO groups (tournament, round, parallel) VALUES (
177 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
179 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
180 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
182 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
184 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
189 UPDATE rounds SET randomsongs=2 WHERE
190 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
192 UPDATE rounds SET chosensongs=1 WHERE
193 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
195 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
199 (SELECT player FROM players WHERE nick='Jim Andre'),
202 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
205 (SELECT player FROM players WHERE nick='Jim Andre'),
206 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
212 (SELECT player FROM players WHERE nick='Jim Andre'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
219 (SELECT player FROM players WHERE nick='Jim Andre'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
227 (SELECT player FROM players WHERE nick='Andre'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
233 (SELECT player FROM players WHERE nick='Andre'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
240 (SELECT player FROM players WHERE nick='Andre'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
247 (SELECT player FROM players WHERE nick='Andre'),
248 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
255 (SELECT player FROM players WHERE nick='Dabi'),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
261 (SELECT player FROM players WHERE nick='Dabi'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
268 (SELECT player FROM players WHERE nick='Dabi'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
275 (SELECT player FROM players WHERE nick='Dabi'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
283 (SELECT player FROM players WHERE nick='Oliyzia'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
289 (SELECT player FROM players WHERE nick='Oliyzia'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
296 (SELECT player FROM players WHERE nick='Oliyzia'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
303 (SELECT player FROM players WHERE nick='Oliyzia'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
311 (SELECT player FROM players WHERE nick='OJK'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
317 (SELECT player FROM players WHERE nick='OJK'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
324 (SELECT player FROM players WHERE nick='OJK'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
331 (SELECT player FROM players WHERE nick='OJK'),
332 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
335 INSERT INTO groups (tournament, round, parallel) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
338 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
339 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
341 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
343 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
346 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
348 UPDATE rounds SET randomsongs=2 WHERE
349 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
351 UPDATE rounds SET chosensongs=1 WHERE
352 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
354 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
358 (SELECT player FROM players WHERE nick='Glukko'),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
364 (SELECT player FROM players WHERE nick='Glukko'),
365 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
368 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
371 (SELECT player FROM players WHERE nick='Glukko'),
372 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
378 (SELECT player FROM players WHERE nick='Glukko'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
382 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole-Christian' AS nick WHERE 'Ole-Christian' NOT IN ( SELECT nick FROM players );
383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
386 (SELECT player FROM players WHERE nick='Ole-Christian'),
389 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
392 (SELECT player FROM players WHERE nick='Ole-Christian'),
393 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
399 (SELECT player FROM players WHERE nick='Ole-Christian'),
400 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
403 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
404 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
405 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
407 (SELECT player FROM players WHERE nick='Zyc'),
410 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
411 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
413 (SELECT player FROM players WHERE nick='Zyc'),
414 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
420 (SELECT player FROM players WHERE nick='Zyc'),
421 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
427 (SELECT player FROM players WHERE nick='Zyc'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
431 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
432 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
433 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
435 (SELECT player FROM players WHERE nick='Ylini'),
438 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
441 (SELECT player FROM players WHERE nick='Ylini'),
442 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
448 (SELECT player FROM players WHERE nick='Ylini'),
449 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
452 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
455 (SELECT player FROM players WHERE nick='Ylini'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
459 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
460 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
461 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
463 (SELECT player FROM players WHERE nick='DufF'),
466 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
467 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
469 (SELECT player FROM players WHERE nick='DufF'),
470 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
476 (SELECT player FROM players WHERE nick='DufF'),
477 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
483 (SELECT player FROM players WHERE nick='DufF'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
487 INSERT INTO groups (tournament, round, parallel) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
490 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
491 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
493 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
495 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
498 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
500 UPDATE rounds SET randomsongs=2 WHERE
501 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
503 UPDATE rounds SET chosensongs=1 WHERE
504 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
506 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
507 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
508 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
510 (SELECT player FROM players WHERE nick='Th0rny'),
513 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
516 (SELECT player FROM players WHERE nick='Th0rny'),
517 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
523 (SELECT player FROM players WHERE nick='Th0rny'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
530 (SELECT player FROM players WHERE nick='Th0rny'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
538 (SELECT player FROM players WHERE nick='Nameless'),
541 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
544 (SELECT player FROM players WHERE nick='Nameless'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
551 (SELECT player FROM players WHERE nick='Nameless'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
555 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
556 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
558 (SELECT player FROM players WHERE nick='Nameless'),
559 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
562 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
563 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
564 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
566 (SELECT player FROM players WHERE nick='Matsi'),
569 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
572 (SELECT player FROM players WHERE nick='Matsi'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
576 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
579 (SELECT player FROM players WHERE nick='Matsi'),
580 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
586 (SELECT player FROM players WHERE nick='Matsi'),
587 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
590 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
591 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
592 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
594 (SELECT player FROM players WHERE nick='Draconia'),
597 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
598 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
600 (SELECT player FROM players WHERE nick='Draconia'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
607 (SELECT player FROM players WHERE nick='Draconia'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
614 (SELECT player FROM players WHERE nick='Draconia'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
618 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
619 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
620 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
622 (SELECT player FROM players WHERE nick='RiChY'),
625 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
626 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
628 (SELECT player FROM players WHERE nick='RiChY'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
635 (SELECT player FROM players WHERE nick='RiChY'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
639 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
642 (SELECT player FROM players WHERE nick='RiChY'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
646 INSERT INTO groups (tournament, round, parallel) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
649 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
650 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
652 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
654 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
657 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
659 UPDATE rounds SET randomsongs=2 WHERE
660 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
662 UPDATE rounds SET chosensongs=1 WHERE
663 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
665 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
666 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
669 (SELECT player FROM players WHERE nick='Eruanna'),
672 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
673 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
675 (SELECT player FROM players WHERE nick='Eruanna'),
676 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
679 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
680 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
682 (SELECT player FROM players WHERE nick='Eruanna'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
686 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
689 (SELECT player FROM players WHERE nick='Eruanna'),
690 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
693 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
694 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
695 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
697 (SELECT player FROM players WHERE nick='Advena'),
700 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
701 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
703 (SELECT player FROM players WHERE nick='Advena'),
704 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
707 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
710 (SELECT player FROM players WHERE nick='Advena'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
714 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
717 (SELECT player FROM players WHERE nick='Advena'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
723 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
725 (SELECT player FROM players WHERE nick='Tassen'),
728 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
731 (SELECT player FROM players WHERE nick='Tassen'),
732 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
738 (SELECT player FROM players WHERE nick='Tassen'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
742 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
743 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
745 (SELECT player FROM players WHERE nick='Tassen'),
746 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
749 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
750 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
751 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
753 (SELECT player FROM players WHERE nick='Duckling'),
756 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
759 (SELECT player FROM players WHERE nick='Duckling'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
763 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
764 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
766 (SELECT player FROM players WHERE nick='Duckling'),
767 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
770 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
773 (SELECT player FROM players WHERE nick='Duckling'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
777 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
778 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
779 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
781 (SELECT player FROM players WHERE nick='Olemann'),
784 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
785 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
787 (SELECT player FROM players WHERE nick='Olemann'),
788 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
794 (SELECT player FROM players WHERE nick='Olemann'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
801 (SELECT player FROM players WHERE nick='Olemann'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
805 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
806 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
807 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
809 (SELECT player FROM players WHERE nick='T|na'),
812 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
813 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
815 (SELECT player FROM players WHERE nick='T|na'),
816 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
819 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
822 (SELECT player FROM players WHERE nick='T|na'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
826 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
829 (SELECT player FROM players WHERE nick='T|na'),
830 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
833 INSERT INTO groups (tournament, round, parallel) VALUES (
834 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
836 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
837 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
839 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
841 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
844 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
846 UPDATE rounds SET randomsongs=2 WHERE
847 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
849 UPDATE rounds SET chosensongs=1 WHERE
850 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
852 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
853 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
854 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
856 (SELECT player FROM players WHERE nick='Bonzo'),
859 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
860 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
862 (SELECT player FROM players WHERE nick='Bonzo'),
863 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
866 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
867 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
869 (SELECT player FROM players WHERE nick='Bonzo'),
870 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
873 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
874 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
876 (SELECT player FROM players WHERE nick='Bonzo'),
877 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
880 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gollum' AS nick WHERE 'Gollum' NOT IN ( SELECT nick FROM players );
881 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
882 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
884 (SELECT player FROM players WHERE nick='Gollum'),
887 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
888 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
890 (SELECT player FROM players WHERE nick='Gollum'),
891 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
894 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
897 (SELECT player FROM players WHERE nick='Gollum'),
898 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
901 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
902 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
904 (SELECT player FROM players WHERE nick='Gollum'),
905 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
908 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
909 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
910 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
912 (SELECT player FROM players WHERE nick='Hugo'),
915 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
916 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
918 (SELECT player FROM players WHERE nick='Hugo'),
919 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
925 (SELECT player FROM players WHERE nick='Hugo'),
926 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
929 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
930 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
932 (SELECT player FROM players WHERE nick='Hugo'),
933 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
936 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
937 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
938 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
940 (SELECT player FROM players WHERE nick='Auran'),
943 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
946 (SELECT player FROM players WHERE nick='Auran'),
947 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
950 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
953 (SELECT player FROM players WHERE nick='Auran'),
954 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
957 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
960 (SELECT player FROM players WHERE nick='Auran'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
964 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
965 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
966 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
968 (SELECT player FROM players WHERE nick='Smiph'),
971 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
972 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
974 (SELECT player FROM players WHERE nick='Smiph'),
975 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
978 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
981 (SELECT player FROM players WHERE nick='Smiph'),
982 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
985 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
986 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
988 (SELECT player FROM players WHERE nick='Smiph'),
989 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
992 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
993 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
994 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
996 (SELECT player FROM players WHERE nick='Stream'),
999 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1000 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1002 (SELECT player FROM players WHERE nick='Stream'),
1003 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1006 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1009 (SELECT player FROM players WHERE nick='Stream'),
1010 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1013 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1014 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1016 (SELECT player FROM players WHERE nick='Stream'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1020 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1022 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1025 INSERT INTO groups (tournament, round, parallel) VALUES (
1026 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1028 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1033 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1034 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1036 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
1038 UPDATE rounds SET randomsongs=2 WHERE
1039 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1041 UPDATE rounds SET chosensongs=1 WHERE
1042 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1044 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1045 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1046 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1048 (SELECT player FROM players WHERE nick='Smiph'),
1051 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1054 (SELECT player FROM players WHERE nick='Smiph'),
1055 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1058 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1059 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1061 (SELECT player FROM players WHERE nick='Smiph'),
1062 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1065 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1068 (SELECT player FROM players WHERE nick='Smiph'),
1069 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1072 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1073 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1074 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1076 (SELECT player FROM players WHERE nick='Mulefisk'),
1079 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1080 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1082 (SELECT player FROM players WHERE nick='Mulefisk'),
1083 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1086 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1089 (SELECT player FROM players WHERE nick='Mulefisk'),
1090 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1093 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1096 (SELECT player FROM players WHERE nick='Mulefisk'),
1097 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1100 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1101 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1102 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1104 (SELECT player FROM players WHERE nick='Oliyzia'),
1107 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1110 (SELECT player FROM players WHERE nick='Oliyzia'),
1111 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1114 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1115 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1117 (SELECT player FROM players WHERE nick='Oliyzia'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1121 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1124 (SELECT player FROM players WHERE nick='Oliyzia'),
1125 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1128 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
1129 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1130 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1132 (SELECT player FROM players WHERE nick='Th0rny'),
1135 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1136 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1138 (SELECT player FROM players WHERE nick='Th0rny'),
1139 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1142 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1145 (SELECT player FROM players WHERE nick='Th0rny'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1149 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1152 (SELECT player FROM players WHERE nick='Th0rny'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1157 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1158 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1160 (SELECT player FROM players WHERE nick='OJK'),
1163 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1164 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1166 (SELECT player FROM players WHERE nick='OJK'),
1167 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1170 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1173 (SELECT player FROM players WHERE nick='OJK'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1177 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1180 (SELECT player FROM players WHERE nick='OJK'),
1181 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1184 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1185 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1186 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1188 (SELECT player FROM players WHERE nick='T|na'),
1191 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1192 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1194 (SELECT player FROM players WHERE nick='T|na'),
1195 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1198 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1199 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1201 (SELECT player FROM players WHERE nick='T|na'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1205 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1206 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1208 (SELECT player FROM players WHERE nick='T|na'),
1209 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1212 INSERT INTO groups (tournament, round, parallel) VALUES (
1213 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1215 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1216 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1218 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1220 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1221 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1223 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
1225 UPDATE rounds SET randomsongs=2 WHERE
1226 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1228 UPDATE rounds SET chosensongs=1 WHERE
1229 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1231 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
1232 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1233 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1235 (SELECT player FROM players WHERE nick='Dabi'),
1238 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1241 (SELECT player FROM players WHERE nick='Dabi'),
1242 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1245 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1246 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1248 (SELECT player FROM players WHERE nick='Dabi'),
1249 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1252 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1255 (SELECT player FROM players WHERE nick='Dabi'),
1256 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1259 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1260 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1261 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1263 (SELECT player FROM players WHERE nick='Duckling'),
1266 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1269 (SELECT player FROM players WHERE nick='Duckling'),
1270 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1273 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1276 (SELECT player FROM players WHERE nick='Duckling'),
1277 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1280 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1283 (SELECT player FROM players WHERE nick='Duckling'),
1284 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1287 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1288 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1289 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1291 (SELECT player FROM players WHERE nick='Ylini'),
1294 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1295 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1297 (SELECT player FROM players WHERE nick='Ylini'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1301 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1304 (SELECT player FROM players WHERE nick='Ylini'),
1305 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1308 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1311 (SELECT player FROM players WHERE nick='Ylini'),
1312 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1315 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1316 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1317 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1319 (SELECT player FROM players WHERE nick='Stream'),
1322 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1323 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1325 (SELECT player FROM players WHERE nick='Stream'),
1326 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1329 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1330 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1332 (SELECT player FROM players WHERE nick='Stream'),
1333 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1336 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1339 (SELECT player FROM players WHERE nick='Stream'),
1340 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1343 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1344 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1345 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1347 (SELECT player FROM players WHERE nick='Snute'),
1350 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1351 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1353 (SELECT player FROM players WHERE nick='Snute'),
1354 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1357 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1360 (SELECT player FROM players WHERE nick='Snute'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1364 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1367 (SELECT player FROM players WHERE nick='Snute'),
1368 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1371 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1372 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1373 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1375 (SELECT player FROM players WHERE nick='Hugo'),
1378 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1379 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1381 (SELECT player FROM players WHERE nick='Hugo'),
1382 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1385 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1388 (SELECT player FROM players WHERE nick='Hugo'),
1389 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1392 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1393 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1395 (SELECT player FROM players WHERE nick='Hugo'),
1396 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1399 INSERT INTO groups (tournament, round, parallel) VALUES (
1400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1402 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1403 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1405 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1407 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1408 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1412 UPDATE rounds SET randomsongs=2 WHERE
1413 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1415 UPDATE rounds SET chosensongs=1 WHERE
1416 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1418 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zyc' AS nick WHERE 'Zyc' NOT IN ( SELECT nick FROM players );
1419 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1420 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1422 (SELECT player FROM players WHERE nick='Zyc'),
1425 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1426 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1428 (SELECT player FROM players WHERE nick='Zyc'),
1429 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1432 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1433 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1435 (SELECT player FROM players WHERE nick='Zyc'),
1436 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1439 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1440 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1442 (SELECT player FROM players WHERE nick='Zyc'),
1443 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1448 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1450 (SELECT player FROM players WHERE nick='Nameless'),
1453 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1454 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1456 (SELECT player FROM players WHERE nick='Nameless'),
1457 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1460 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1463 (SELECT player FROM players WHERE nick='Nameless'),
1464 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1467 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1470 (SELECT player FROM players WHERE nick='Nameless'),
1471 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1474 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1476 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1478 (SELECT player FROM players WHERE nick='Haggar'),
1481 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1482 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1484 (SELECT player FROM players WHERE nick='Haggar'),
1485 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1488 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1489 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1491 (SELECT player FROM players WHERE nick='Haggar'),
1492 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1495 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1498 (SELECT player FROM players WHERE nick='Haggar'),
1499 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1502 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1503 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1504 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1506 (SELECT player FROM players WHERE nick='Olemann'),
1509 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1510 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1512 (SELECT player FROM players WHERE nick='Olemann'),
1513 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1516 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1519 (SELECT player FROM players WHERE nick='Olemann'),
1520 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1523 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1526 (SELECT player FROM players WHERE nick='Olemann'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1530 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1531 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1532 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1534 (SELECT player FROM players WHERE nick='RiChY'),
1537 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1538 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1540 (SELECT player FROM players WHERE nick='RiChY'),
1541 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1544 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1545 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1547 (SELECT player FROM players WHERE nick='RiChY'),
1548 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1551 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1554 (SELECT player FROM players WHERE nick='RiChY'),
1555 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1558 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1559 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1560 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1562 (SELECT player FROM players WHERE nick='DufF'),
1565 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1566 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1568 (SELECT player FROM players WHERE nick='DufF'),
1569 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1572 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1573 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1575 (SELECT player FROM players WHERE nick='DufF'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1579 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1582 (SELECT player FROM players WHERE nick='DufF'),
1583 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1586 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1588 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1591 INSERT INTO groups (tournament, round, parallel) VALUES (
1592 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1594 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1595 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1599 UPDATE rounds SET randomsongs=1 WHERE
1600 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1602 UPDATE rounds SET chosensongs=1 WHERE
1603 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1605 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1606 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1607 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1609 (SELECT player FROM players WHERE nick='Stream'),
1612 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1613 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1615 (SELECT player FROM players WHERE nick='Stream'),
1616 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1619 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1620 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1622 (SELECT player FROM players WHERE nick='Stream'),
1623 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1626 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1627 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1628 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1630 (SELECT player FROM players WHERE nick='T|na'),
1633 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1634 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1636 (SELECT player FROM players WHERE nick='T|na'),
1637 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1640 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1641 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1643 (SELECT player FROM players WHERE nick='T|na'),
1644 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1647 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1648 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1649 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1651 (SELECT player FROM players WHERE nick='DufF'),
1654 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1657 (SELECT player FROM players WHERE nick='DufF'),
1658 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1661 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1662 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1664 (SELECT player FROM players WHERE nick='DufF'),
1665 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1668 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1669 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1670 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1672 (SELECT player FROM players WHERE nick='OJK'),
1675 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1676 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1678 (SELECT player FROM players WHERE nick='OJK'),
1679 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1682 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1685 (SELECT player FROM players WHERE nick='OJK'),
1686 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
1689 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1690 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1691 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1693 (SELECT player FROM players WHERE nick='Hugo'),
1696 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1699 (SELECT player FROM players WHERE nick='Hugo'),
1700 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1703 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1704 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1706 (SELECT player FROM players WHERE nick='Hugo'),
1707 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1710 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1711 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1712 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1714 (SELECT player FROM players WHERE nick='RiChY'),
1717 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1718 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1720 (SELECT player FROM players WHERE nick='RiChY'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1724 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1725 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1727 (SELECT player FROM players WHERE nick='RiChY'),
1728 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1731 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1732 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1733 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1735 (SELECT player FROM players WHERE nick='Snute'),
1738 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1741 (SELECT player FROM players WHERE nick='Snute'),
1742 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1745 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1746 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1748 (SELECT player FROM players WHERE nick='Snute'),
1749 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1752 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1754 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1756 (SELECT player FROM players WHERE nick='Oliyzia'),
1759 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1760 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1762 (SELECT player FROM players WHERE nick='Oliyzia'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1766 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1769 (SELECT player FROM players WHERE nick='Oliyzia'),
1770 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1773 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1774 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1775 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1777 (SELECT player FROM players WHERE nick='Haggar'),
1780 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1781 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1783 (SELECT player FROM players WHERE nick='Haggar'),
1784 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1787 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1788 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1790 (SELECT player FROM players WHERE nick='Haggar'),
1791 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1794 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1796 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1799 INSERT INTO groups (tournament, round, parallel) VALUES (
1800 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1802 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1803 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1805 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
1807 UPDATE rounds SET randomsongs=1 WHERE
1808 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1810 UPDATE rounds SET chosensongs=1 WHERE
1811 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1813 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1814 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1815 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1817 (SELECT player FROM players WHERE nick='Haggar'),
1820 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1821 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1823 (SELECT player FROM players WHERE nick='Haggar'),
1824 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1827 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1828 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1830 (SELECT player FROM players WHERE nick='Haggar'),
1831 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1834 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1835 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1836 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1838 (SELECT player FROM players WHERE nick='Hugo'),
1841 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1844 (SELECT player FROM players WHERE nick='Hugo'),
1845 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1848 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1849 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1851 (SELECT player FROM players WHERE nick='Hugo'),
1852 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1855 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1856 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1857 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1859 (SELECT player FROM players WHERE nick='RiChY'),
1862 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1863 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1865 (SELECT player FROM players WHERE nick='RiChY'),
1866 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1869 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1872 (SELECT player FROM players WHERE nick='RiChY'),
1873 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1876 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1877 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1878 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1880 (SELECT player FROM players WHERE nick='OJK'),
1883 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1886 (SELECT player FROM players WHERE nick='OJK'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1890 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1893 (SELECT player FROM players WHERE nick='OJK'),
1894 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1897 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1899 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1901 (SELECT player FROM players WHERE nick='Oliyzia'),
1904 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1907 (SELECT player FROM players WHERE nick='Oliyzia'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1911 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1912 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1914 (SELECT player FROM players WHERE nick='Oliyzia'),
1915 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1918 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1919 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1920 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1922 (SELECT player FROM players WHERE nick='Snute'),
1925 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1928 (SELECT player FROM players WHERE nick='Snute'),
1929 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1932 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1933 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1935 (SELECT player FROM players WHERE nick='Snute'),
1936 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1939 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1940 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1941 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1943 (SELECT player FROM players WHERE nick='DufF'),
1946 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1949 (SELECT player FROM players WHERE nick='DufF'),
1950 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1953 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1956 (SELECT player FROM players WHERE nick='DufF'),
1957 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1960 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1962 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1965 INSERT INTO groups (tournament, round, parallel) VALUES (
1966 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1968 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1969 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1971 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
1973 UPDATE rounds SET randomsongs=1 WHERE
1974 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1976 UPDATE rounds SET chosensongs=1 WHERE
1977 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
1979 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
1980 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1981 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1983 (SELECT player FROM players WHERE nick='Hugo'),
1986 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1987 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1989 (SELECT player FROM players WHERE nick='Hugo'),
1990 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1993 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1994 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
1996 (SELECT player FROM players WHERE nick='Hugo'),
1997 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2000 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2001 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2002 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2004 (SELECT player FROM players WHERE nick='RiChY'),
2007 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2008 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2010 (SELECT player FROM players WHERE nick='RiChY'),
2011 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2014 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2015 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2017 (SELECT player FROM players WHERE nick='RiChY'),
2018 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2021 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2022 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2023 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2025 (SELECT player FROM players WHERE nick='DufF'),
2028 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2031 (SELECT player FROM players WHERE nick='DufF'),
2032 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2035 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2036 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2038 (SELECT player FROM players WHERE nick='DufF'),
2039 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2042 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2043 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2044 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2046 (SELECT player FROM players WHERE nick='Oliyzia'),
2049 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2052 (SELECT player FROM players WHERE nick='Oliyzia'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2056 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2059 (SELECT player FROM players WHERE nick='Oliyzia'),
2060 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2063 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2065 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2067 (SELECT player FROM players WHERE nick='Snute'),
2070 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2071 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2073 (SELECT player FROM players WHERE nick='Snute'),
2074 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2077 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2078 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2080 (SELECT player FROM players WHERE nick='Snute'),
2081 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2084 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2086 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2089 INSERT INTO groups (tournament, round, parallel) VALUES (
2090 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2092 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2093 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2095 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
2097 UPDATE rounds SET randomsongs=1 WHERE
2098 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
2100 UPDATE rounds SET chosensongs=1 WHERE
2101 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
2103 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2104 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2105 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2107 (SELECT player FROM players WHERE nick='Hugo'),
2110 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2111 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2113 (SELECT player FROM players WHERE nick='Hugo'),
2114 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2117 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2118 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2120 (SELECT player FROM players WHERE nick='Hugo'),
2121 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2124 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2125 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2126 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2128 (SELECT player FROM players WHERE nick='Oliyzia'),
2131 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2132 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2134 (SELECT player FROM players WHERE nick='Oliyzia'),
2135 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2138 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2139 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2141 (SELECT player FROM players WHERE nick='Oliyzia'),
2142 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2145 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2146 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2147 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2149 (SELECT player FROM players WHERE nick='Snute'),
2152 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2155 (SELECT player FROM players WHERE nick='Snute'),
2156 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2159 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2160 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2162 (SELECT player FROM players WHERE nick='Snute'),
2163 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2166 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2170 (SELECT player FROM players WHERE nick='DufF'),
2173 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2174 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2176 (SELECT player FROM players WHERE nick='DufF'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2180 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2181 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2183 (SELECT player FROM players WHERE nick='DufF'),
2184 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2187 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2192 INSERT INTO groups (tournament, round, parallel) VALUES (
2193 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2195 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2198 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
2200 UPDATE rounds SET randomsongs=1 WHERE
2201 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
2203 UPDATE rounds SET chosensongs=1 WHERE
2204 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
2206 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hugo' AS nick WHERE 'Hugo' NOT IN ( SELECT nick FROM players );
2207 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2208 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2210 (SELECT player FROM players WHERE nick='Hugo'),
2213 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2214 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2216 (SELECT player FROM players WHERE nick='Hugo'),
2217 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2220 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2221 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2223 (SELECT player FROM players WHERE nick='Hugo'),
2224 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2227 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2229 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2231 (SELECT player FROM players WHERE nick='DufF'),
2234 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2235 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2237 (SELECT player FROM players WHERE nick='DufF'),
2238 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2241 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2242 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2244 (SELECT player FROM players WHERE nick='DufF'),
2245 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2248 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2249 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2250 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2252 (SELECT player FROM players WHERE nick='Snute'),
2255 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2256 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2258 (SELECT player FROM players WHERE nick='Snute'),
2259 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2262 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2263 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2265 (SELECT player FROM players WHERE nick='Snute'),
2266 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2269 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2271 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2274 INSERT INTO groups (tournament, round, parallel) VALUES (
2275 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2277 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2278 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2280 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
2282 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2283 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2285 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2287 UPDATE rounds SET randomsongs=2 WHERE
2288 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 3') AND
2290 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2291 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2294 (SELECT player FROM players WHERE nick='DufF'),
2297 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2298 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2300 (SELECT player FROM players WHERE nick='DufF'),
2301 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2304 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2307 (SELECT player FROM players WHERE nick='DufF'),
2308 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2311 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2315 (SELECT player FROM players WHERE nick='Snute'),
2318 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2319 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2321 (SELECT player FROM players WHERE nick='Snute'),
2322 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2325 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2326 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 3'),
2328 (SELECT player FROM players WHERE nick='Snute'),
2329 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),