2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
16 (SELECT player FROM players WHERE nick='OJK'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
28 (SELECT player FROM players WHERE nick='DufF'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
34 (SELECT player FROM players WHERE nick='Snofox'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
40 (SELECT player FROM players WHERE nick='T|na'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
46 (SELECT player FROM players WHERE nick='RiChY'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
52 (SELECT player FROM players WHERE nick='Stream'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
58 (SELECT player FROM players WHERE nick='Olemann'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
64 (SELECT player FROM players WHERE nick='Raazu'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
70 (SELECT player FROM players WHERE nick='Ylini'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
76 (SELECT player FROM players WHERE nick='Smiph'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
82 (SELECT player FROM players WHERE nick='Havok'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
88 (SELECT player FROM players WHERE nick='Draconia'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
94 (SELECT player FROM players WHERE nick='Dabi'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
100 (SELECT player FROM players WHERE nick='Bush'),
102 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
107 INSERT INTO groups (tournament, round, parallel) VALUES (
108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
110 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
113 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
115 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
118 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
120 UPDATE rounds SET randomsongs=2 WHERE
121 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
123 UPDATE rounds SET chosensongs=1 WHERE
124 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
129 (SELECT player FROM players WHERE nick='Bush'),
132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
135 (SELECT player FROM players WHERE nick='Bush'),
137 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
143 (SELECT player FROM players WHERE nick='Bush'),
145 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
151 (SELECT player FROM players WHERE nick='Bush'),
153 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
156 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
159 (SELECT player FROM players WHERE nick='Ylini'),
162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
165 (SELECT player FROM players WHERE nick='Ylini'),
167 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
173 (SELECT player FROM players WHERE nick='Ylini'),
175 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
181 (SELECT player FROM players WHERE nick='Ylini'),
183 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
189 (SELECT player FROM players WHERE nick='Stream'),
192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
195 (SELECT player FROM players WHERE nick='Stream'),
197 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
203 (SELECT player FROM players WHERE nick='Stream'),
205 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
211 (SELECT player FROM players WHERE nick='Stream'),
213 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
216 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
219 (SELECT player FROM players WHERE nick='T|na'),
222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
225 (SELECT player FROM players WHERE nick='T|na'),
227 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
233 (SELECT player FROM players WHERE nick='T|na'),
235 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
241 (SELECT player FROM players WHERE nick='T|na'),
243 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
249 (SELECT player FROM players WHERE nick='Snute'),
252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
255 (SELECT player FROM players WHERE nick='Snute'),
257 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
263 (SELECT player FROM players WHERE nick='Snute'),
265 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
271 (SELECT player FROM players WHERE nick='Snute'),
273 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
276 INSERT INTO groups (tournament, round, parallel) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
279 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
282 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
284 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
287 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
289 UPDATE rounds SET randomsongs=2 WHERE
290 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
292 UPDATE rounds SET chosensongs=1 WHERE
293 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
298 (SELECT player FROM players WHERE nick='Dabi'),
301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
304 (SELECT player FROM players WHERE nick='Dabi'),
306 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
312 (SELECT player FROM players WHERE nick='Dabi'),
314 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
320 (SELECT player FROM players WHERE nick='Dabi'),
322 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
325 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
328 (SELECT player FROM players WHERE nick='Olemann'),
331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
334 (SELECT player FROM players WHERE nick='Olemann'),
336 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
339 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
342 (SELECT player FROM players WHERE nick='Olemann'),
344 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
350 (SELECT player FROM players WHERE nick='Olemann'),
352 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
358 (SELECT player FROM players WHERE nick='Smiph'),
361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
364 (SELECT player FROM players WHERE nick='Smiph'),
366 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
369 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
372 (SELECT player FROM players WHERE nick='Smiph'),
374 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
377 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
378 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
380 (SELECT player FROM players WHERE nick='Smiph'),
382 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
388 (SELECT player FROM players WHERE nick='RiChY'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
394 (SELECT player FROM players WHERE nick='RiChY'),
396 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
402 (SELECT player FROM players WHERE nick='RiChY'),
404 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
410 (SELECT player FROM players WHERE nick='RiChY'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
418 (SELECT player FROM players WHERE nick='DufF'),
421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
424 (SELECT player FROM players WHERE nick='DufF'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
432 (SELECT player FROM players WHERE nick='DufF'),
434 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
440 (SELECT player FROM players WHERE nick='DufF'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
445 INSERT INTO groups (tournament, round, parallel) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
448 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
451 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
453 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
456 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
458 UPDATE rounds SET randomsongs=2 WHERE
459 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
461 UPDATE rounds SET chosensongs=1 WHERE
462 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
467 (SELECT player FROM players WHERE nick='Raazu'),
470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
473 (SELECT player FROM players WHERE nick='Raazu'),
475 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
481 (SELECT player FROM players WHERE nick='Raazu'),
483 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
489 (SELECT player FROM players WHERE nick='Raazu'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
494 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
497 (SELECT player FROM players WHERE nick='Draconia'),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
503 (SELECT player FROM players WHERE nick='Draconia'),
505 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
511 (SELECT player FROM players WHERE nick='Draconia'),
513 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
519 (SELECT player FROM players WHERE nick='Draconia'),
521 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
524 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
527 (SELECT player FROM players WHERE nick='Havok'),
530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
533 (SELECT player FROM players WHERE nick='Havok'),
535 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
541 (SELECT player FROM players WHERE nick='Havok'),
543 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
549 (SELECT player FROM players WHERE nick='Havok'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
554 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
557 (SELECT player FROM players WHERE nick='Snofox'),
560 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
563 (SELECT player FROM players WHERE nick='Snofox'),
565 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
571 (SELECT player FROM players WHERE nick='Snofox'),
573 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
579 (SELECT player FROM players WHERE nick='Snofox'),
581 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
584 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
587 (SELECT player FROM players WHERE nick='OJK'),
590 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
593 (SELECT player FROM players WHERE nick='OJK'),
595 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
601 (SELECT player FROM players WHERE nick='OJK'),
603 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
609 (SELECT player FROM players WHERE nick='OJK'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
614 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
619 INSERT INTO groups (tournament, round, parallel) VALUES (
620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
622 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
625 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
627 UPDATE rounds SET randomsongs=1 WHERE
628 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
630 UPDATE rounds SET chosensongs=1 WHERE
631 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
633 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
636 (SELECT player FROM players WHERE nick='Raazu'),
639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
642 (SELECT player FROM players WHERE nick='Raazu'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
650 (SELECT player FROM players WHERE nick='Raazu'),
652 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
655 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
658 (SELECT player FROM players WHERE nick='Stream'),
661 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
662 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
664 (SELECT player FROM players WHERE nick='Stream'),
666 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
672 (SELECT player FROM players WHERE nick='Stream'),
674 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
677 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
680 (SELECT player FROM players WHERE nick='Olemann'),
683 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
684 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
686 (SELECT player FROM players WHERE nick='Olemann'),
688 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
692 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
694 (SELECT player FROM players WHERE nick='Olemann'),
696 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
699 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
702 (SELECT player FROM players WHERE nick='T|na'),
705 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
708 (SELECT player FROM players WHERE nick='T|na'),
710 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
713 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
714 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
716 (SELECT player FROM players WHERE nick='T|na'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
721 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
722 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
724 (SELECT player FROM players WHERE nick='Snofox'),
727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
730 (SELECT player FROM players WHERE nick='Snofox'),
732 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
735 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
738 (SELECT player FROM players WHERE nick='Snofox'),
740 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
743 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
746 (SELECT player FROM players WHERE nick='RiChY'),
749 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
752 (SELECT player FROM players WHERE nick='RiChY'),
754 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
757 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
758 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
760 (SELECT player FROM players WHERE nick='RiChY'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
765 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
768 (SELECT player FROM players WHERE nick='Snute'),
771 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
774 (SELECT player FROM players WHERE nick='Snute'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
779 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
782 (SELECT player FROM players WHERE nick='Snute'),
784 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
787 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
790 (SELECT player FROM players WHERE nick='OJK'),
793 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
794 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
796 (SELECT player FROM players WHERE nick='OJK'),
798 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
804 (SELECT player FROM players WHERE nick='OJK'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
809 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
812 (SELECT player FROM players WHERE nick='DufF'),
815 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
818 (SELECT player FROM players WHERE nick='DufF'),
820 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
823 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
824 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
826 (SELECT player FROM players WHERE nick='DufF'),
828 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
831 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
836 INSERT INTO groups (tournament, round, parallel) VALUES (
837 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
839 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
842 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
844 UPDATE rounds SET randomsongs=1 WHERE
845 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
847 UPDATE rounds SET chosensongs=1 WHERE
848 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
850 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
851 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
853 (SELECT player FROM players WHERE nick='Stream'),
856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
857 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
859 (SELECT player FROM players WHERE nick='Stream'),
861 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
864 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
865 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
867 (SELECT player FROM players WHERE nick='Stream'),
869 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
872 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
873 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
875 (SELECT player FROM players WHERE nick='T|na'),
878 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
879 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
881 (SELECT player FROM players WHERE nick='T|na'),
883 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
886 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
887 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
889 (SELECT player FROM players WHERE nick='T|na'),
891 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
894 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
897 (SELECT player FROM players WHERE nick='RiChY'),
900 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
901 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
903 (SELECT player FROM players WHERE nick='RiChY'),
905 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
908 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
909 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
911 (SELECT player FROM players WHERE nick='RiChY'),
913 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
916 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
917 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
919 (SELECT player FROM players WHERE nick='Snofox'),
922 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
925 (SELECT player FROM players WHERE nick='Snofox'),
927 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
933 (SELECT player FROM players WHERE nick='Snofox'),
935 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
938 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
939 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
941 (SELECT player FROM players WHERE nick='OJK'),
944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
947 (SELECT player FROM players WHERE nick='OJK'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
952 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
955 (SELECT player FROM players WHERE nick='OJK'),
957 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
960 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
961 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
963 (SELECT player FROM players WHERE nick='Snute'),
966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
969 (SELECT player FROM players WHERE nick='Snute'),
971 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
974 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
975 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
977 (SELECT player FROM players WHERE nick='Snute'),
979 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
982 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
985 (SELECT player FROM players WHERE nick='DufF'),
988 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
991 (SELECT player FROM players WHERE nick='DufF'),
993 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
999 (SELECT player FROM players WHERE nick='DufF'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1004 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1006 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1009 INSERT INTO groups (tournament, round, parallel) VALUES (
1010 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1012 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1015 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
1017 UPDATE rounds SET randomsongs=1 WHERE
1018 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1020 UPDATE rounds SET chosensongs=1 WHERE
1021 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1023 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1024 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1026 (SELECT player FROM players WHERE nick='OJK'),
1029 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1032 (SELECT player FROM players WHERE nick='OJK'),
1034 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1038 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1040 (SELECT player FROM players WHERE nick='OJK'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1045 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1048 (SELECT player FROM players WHERE nick='T|na'),
1051 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1054 (SELECT player FROM players WHERE nick='T|na'),
1056 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1059 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1060 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1062 (SELECT player FROM players WHERE nick='T|na'),
1064 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1067 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1068 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1070 (SELECT player FROM players WHERE nick='Snofox'),
1073 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1076 (SELECT player FROM players WHERE nick='Snofox'),
1078 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1081 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1082 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1084 (SELECT player FROM players WHERE nick='Snofox'),
1086 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1089 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1092 (SELECT player FROM players WHERE nick='DufF'),
1095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1096 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1098 (SELECT player FROM players WHERE nick='DufF'),
1100 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1106 (SELECT player FROM players WHERE nick='DufF'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1111 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1114 (SELECT player FROM players WHERE nick='Snute'),
1117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1120 (SELECT player FROM players WHERE nick='Snute'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1128 (SELECT player FROM players WHERE nick='Snute'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1133 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1138 INSERT INTO groups (tournament, round, parallel) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1141 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1142 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1144 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1146 UPDATE rounds SET randomsongs=1 WHERE
1147 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1149 UPDATE rounds SET chosensongs=1 WHERE
1150 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1152 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1155 (SELECT player FROM players WHERE nick='Snofox'),
1158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1161 (SELECT player FROM players WHERE nick='Snofox'),
1163 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1167 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1169 (SELECT player FROM players WHERE nick='Snofox'),
1171 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1174 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1175 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1177 (SELECT player FROM players WHERE nick='DufF'),
1180 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1181 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1183 (SELECT player FROM players WHERE nick='DufF'),
1185 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1189 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1191 (SELECT player FROM players WHERE nick='DufF'),
1193 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1197 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1199 (SELECT player FROM players WHERE nick='OJK'),
1202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1203 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1205 (SELECT player FROM players WHERE nick='OJK'),
1207 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1210 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1211 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1213 (SELECT player FROM players WHERE nick='OJK'),
1215 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1218 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1219 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1221 (SELECT player FROM players WHERE nick='Snute'),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1227 (SELECT player FROM players WHERE nick='Snute'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1235 (SELECT player FROM players WHERE nick='Snute'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1240 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1245 INSERT INTO groups (tournament, round, parallel) VALUES (
1246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1248 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1251 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
1253 UPDATE rounds SET randomsongs=1 WHERE
1254 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1256 UPDATE rounds SET chosensongs=1 WHERE
1257 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1259 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1262 (SELECT player FROM players WHERE nick='OJK'),
1265 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1268 (SELECT player FROM players WHERE nick='OJK'),
1270 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1273 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1276 (SELECT player FROM players WHERE nick='OJK'),
1278 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1281 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1284 (SELECT player FROM players WHERE nick='DufF'),
1287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1290 (SELECT player FROM players WHERE nick='DufF'),
1292 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1298 (SELECT player FROM players WHERE nick='DufF'),
1300 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1303 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1306 (SELECT player FROM players WHERE nick='Snute'),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1312 (SELECT player FROM players WHERE nick='Snute'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1320 (SELECT player FROM players WHERE nick='Snute'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1325 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1330 INSERT INTO groups (tournament, round, parallel) VALUES (
1331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1333 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1338 UPDATE rounds SET randomsongs=1 WHERE
1339 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1341 UPDATE rounds SET chosensongs=1 WHERE
1342 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1344 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1347 (SELECT player FROM players WHERE nick='Snute'),
1350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1353 (SELECT player FROM players WHERE nick='Snute'),
1355 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1361 (SELECT player FROM players WHERE nick='Snute'),
1363 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1369 (SELECT player FROM players WHERE nick='OJK'),
1372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1375 (SELECT player FROM players WHERE nick='OJK'),
1377 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1383 (SELECT player FROM players WHERE nick='OJK'),
1385 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),