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 2'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
28 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' 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 2'),
40 (SELECT player FROM players WHERE nick='Bush'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
46 (SELECT player FROM players WHERE nick='Bush'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
53 (SELECT player FROM players WHERE nick='Bush'),
54 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
57 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
60 (SELECT player FROM players WHERE nick='Bush'),
61 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
64 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' 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 2'),
68 (SELECT player FROM players WHERE nick='Ylini'),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
74 (SELECT player FROM players WHERE nick='Ylini'),
75 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
81 (SELECT player FROM players WHERE nick='Ylini'),
82 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
88 (SELECT player FROM players WHERE nick='Ylini'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' 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 2'),
96 (SELECT player FROM players WHERE nick='Stream'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
102 (SELECT player FROM players WHERE nick='Stream'),
103 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
109 (SELECT player FROM players WHERE nick='Stream'),
110 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
116 (SELECT player FROM players WHERE nick='Stream'),
117 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' 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 2'),
124 (SELECT player FROM players WHERE nick='T|na'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
130 (SELECT player FROM players WHERE nick='T|na'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
137 (SELECT player FROM players WHERE nick='T|na'),
138 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
144 (SELECT player FROM players WHERE nick='T|na'),
145 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
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 2'),
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 2'),
158 (SELECT player FROM players WHERE nick='Snute'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
165 (SELECT player FROM players WHERE nick='Snute'),
166 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
172 (SELECT player FROM players WHERE nick='Snute'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
176 INSERT INTO groups (tournament, round, parallel) VALUES (
177 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
179 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
180 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
182 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
184 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
189 UPDATE rounds SET randomsongs=2 WHERE
190 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
192 UPDATE rounds SET chosensongs=1 WHERE
193 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
195 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' 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 2'),
199 (SELECT player FROM players WHERE nick='Dabi'),
202 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
205 (SELECT player FROM players WHERE nick='Dabi'),
206 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
212 (SELECT player FROM players WHERE nick='Dabi'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
219 (SELECT player FROM players WHERE nick='Dabi'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 2'),
227 (SELECT player FROM players WHERE nick='Olemann'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
233 (SELECT player FROM players WHERE nick='Olemann'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
240 (SELECT player FROM players WHERE nick='Olemann'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
247 (SELECT player FROM players WHERE nick='Olemann'),
248 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' 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 2'),
255 (SELECT player FROM players WHERE nick='Smiph'),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
261 (SELECT player FROM players WHERE nick='Smiph'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
268 (SELECT player FROM players WHERE nick='Smiph'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
275 (SELECT player FROM players WHERE nick='Smiph'),
276 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' 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 2'),
283 (SELECT player FROM players WHERE nick='RiChY'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
289 (SELECT player FROM players WHERE nick='RiChY'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
296 (SELECT player FROM players WHERE nick='RiChY'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
303 (SELECT player FROM players WHERE nick='RiChY'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' 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 2'),
311 (SELECT player FROM players WHERE nick='DufF'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
317 (SELECT player FROM players WHERE nick='DufF'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
324 (SELECT player FROM players WHERE nick='DufF'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
331 (SELECT player FROM players WHERE nick='DufF'),
332 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
335 INSERT INTO groups (tournament, round, parallel) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
338 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
339 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
341 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
343 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
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 2') AND
351 UPDATE rounds SET chosensongs=1 WHERE
352 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
354 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' 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 2'),
358 (SELECT player FROM players WHERE nick='Raazu'),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
364 (SELECT player FROM players WHERE nick='Raazu'),
365 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
368 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
371 (SELECT player FROM players WHERE nick='Raazu'),
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 2'),
378 (SELECT player FROM players WHERE nick='Raazu'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
382 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' 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 2'),
386 (SELECT player FROM players WHERE nick='Draconia'),
389 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
392 (SELECT player FROM players WHERE nick='Draconia'),
393 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
399 (SELECT player FROM players WHERE nick='Draconia'),
400 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
406 (SELECT player FROM players WHERE nick='Draconia'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
411 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
414 (SELECT player FROM players WHERE nick='Havok'),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
420 (SELECT player FROM players WHERE nick='Havok'),
421 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
427 (SELECT player FROM players WHERE nick='Havok'),
428 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
431 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
434 (SELECT player FROM players WHERE nick='Havok'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
442 (SELECT player FROM players WHERE nick='Snofox'),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
448 (SELECT player FROM players WHERE nick='Snofox'),
449 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
452 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
455 (SELECT player FROM players WHERE nick='Snofox'),
456 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
459 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
462 (SELECT player FROM players WHERE nick='Snofox'),
463 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
470 (SELECT player FROM players WHERE nick='OJK'),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
476 (SELECT player FROM players WHERE nick='OJK'),
477 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
483 (SELECT player FROM players WHERE nick='OJK'),
484 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
490 (SELECT player FROM players WHERE nick='OJK'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
494 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
499 INSERT INTO groups (tournament, round, parallel) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
502 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
503 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
507 UPDATE rounds SET randomsongs=1 WHERE
508 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
510 UPDATE rounds SET chosensongs=1 WHERE
511 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
514 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
517 (SELECT player FROM players WHERE nick='Raazu'),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
523 (SELECT player FROM players WHERE nick='Raazu'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
530 (SELECT player FROM players WHERE nick='Raazu'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' 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 2'),
538 (SELECT player FROM players WHERE nick='Stream'),
541 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
544 (SELECT player FROM players WHERE nick='Stream'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
551 (SELECT player FROM players WHERE nick='Stream'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
555 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
556 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
557 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
559 (SELECT player FROM players WHERE nick='Olemann'),
562 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
565 (SELECT player FROM players WHERE nick='Olemann'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
569 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
572 (SELECT player FROM players WHERE nick='Olemann'),
573 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
576 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
577 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
580 (SELECT player FROM players WHERE nick='T|na'),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
586 (SELECT player FROM players WHERE nick='T|na'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
590 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
593 (SELECT player FROM players WHERE nick='T|na'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
599 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
601 (SELECT player FROM players WHERE nick='Snofox'),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
607 (SELECT player FROM players WHERE nick='Snofox'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
614 (SELECT player FROM players WHERE nick='Snofox'),
615 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
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 2'),
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 2'),
628 (SELECT player FROM players WHERE nick='RiChY'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
635 (SELECT player FROM players WHERE nick='RiChY'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
639 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
640 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
641 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
643 (SELECT player FROM players WHERE nick='Snute'),
646 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
649 (SELECT player FROM players WHERE nick='Snute'),
650 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
653 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
654 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
656 (SELECT player FROM players WHERE nick='Snute'),
657 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
660 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
661 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
662 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
664 (SELECT player FROM players WHERE nick='OJK'),
667 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
668 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
670 (SELECT player FROM players WHERE nick='OJK'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
674 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
677 (SELECT player FROM players WHERE nick='OJK'),
678 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
685 (SELECT player FROM players WHERE nick='DufF'),
688 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
691 (SELECT player FROM players WHERE nick='DufF'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
695 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
698 (SELECT player FROM players WHERE nick='DufF'),
699 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
702 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
704 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
707 INSERT INTO groups (tournament, round, parallel) VALUES (
708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
710 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
711 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
713 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
715 UPDATE rounds SET randomsongs=1 WHERE
716 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
718 UPDATE rounds SET chosensongs=1 WHERE
719 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' 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 2'),
725 (SELECT player FROM players WHERE nick='Stream'),
728 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
731 (SELECT player FROM players WHERE nick='Stream'),
732 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
738 (SELECT player FROM players WHERE nick='Stream'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
742 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
743 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
744 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
746 (SELECT player FROM players WHERE nick='T|na'),
749 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
752 (SELECT player FROM players WHERE nick='T|na'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
756 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
759 (SELECT player FROM players WHERE nick='T|na'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
763 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
765 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
767 (SELECT player FROM players WHERE nick='RiChY'),
770 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
773 (SELECT player FROM players WHERE nick='RiChY'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
777 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
780 (SELECT player FROM players WHERE nick='RiChY'),
781 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
788 (SELECT player FROM players WHERE nick='Snofox'),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
794 (SELECT player FROM players WHERE nick='Snofox'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
801 (SELECT player FROM players WHERE nick='Snofox'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
805 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' 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 2'),
809 (SELECT player FROM players WHERE nick='OJK'),
812 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
813 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
815 (SELECT player FROM players WHERE nick='OJK'),
816 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
819 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
822 (SELECT player FROM players WHERE nick='OJK'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
826 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
827 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
828 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
830 (SELECT player FROM players WHERE nick='Snute'),
833 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
834 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
836 (SELECT player FROM players WHERE nick='Snute'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
840 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
843 (SELECT player FROM players WHERE nick='Snute'),
844 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
847 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
848 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
849 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
851 (SELECT player FROM players WHERE nick='DufF'),
854 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
855 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
857 (SELECT player FROM players WHERE nick='DufF'),
858 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
861 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
864 (SELECT player FROM players WHERE nick='DufF'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
868 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
873 INSERT INTO groups (tournament, round, parallel) VALUES (
874 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
876 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
879 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
881 UPDATE rounds SET randomsongs=1 WHERE
882 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
884 UPDATE rounds SET chosensongs=1 WHERE
885 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
889 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
891 (SELECT player FROM players WHERE nick='OJK'),
894 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
897 (SELECT player FROM players WHERE nick='OJK'),
898 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
901 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
902 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
904 (SELECT player FROM players WHERE nick='OJK'),
905 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
908 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' 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 2'),
912 (SELECT player FROM players WHERE nick='T|na'),
915 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
916 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
918 (SELECT player FROM players WHERE nick='T|na'),
919 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
925 (SELECT player FROM players WHERE nick='T|na'),
926 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
929 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
930 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
931 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
933 (SELECT player FROM players WHERE nick='Snofox'),
936 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
939 (SELECT player FROM players WHERE nick='Snofox'),
940 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
943 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
946 (SELECT player FROM players WHERE nick='Snofox'),
947 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
950 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
951 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
952 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
954 (SELECT player FROM players WHERE nick='DufF'),
957 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
960 (SELECT player FROM players WHERE nick='DufF'),
961 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
964 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
967 (SELECT player FROM players WHERE nick='DufF'),
968 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
971 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
972 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
973 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
975 (SELECT player FROM players WHERE nick='Snute'),
978 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
981 (SELECT player FROM players WHERE nick='Snute'),
982 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
985 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
986 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
988 (SELECT player FROM players WHERE nick='Snute'),
989 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
992 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
994 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
997 INSERT INTO groups (tournament, round, parallel) VALUES (
998 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1000 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1001 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1003 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1005 UPDATE rounds SET randomsongs=1 WHERE
1006 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
1008 UPDATE rounds SET chosensongs=1 WHERE
1009 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
1011 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1015 (SELECT player FROM players WHERE nick='Snofox'),
1018 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1021 (SELECT player FROM players WHERE nick='Snofox'),
1022 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1025 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1026 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1028 (SELECT player FROM players WHERE nick='Snofox'),
1029 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1032 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1033 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1034 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1036 (SELECT player FROM players WHERE nick='DufF'),
1039 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1040 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1042 (SELECT player FROM players WHERE nick='DufF'),
1043 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1046 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1047 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1049 (SELECT player FROM players WHERE nick='DufF'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1053 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1055 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1057 (SELECT player FROM players WHERE nick='OJK'),
1060 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1061 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1063 (SELECT player FROM players WHERE nick='OJK'),
1064 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1067 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1068 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1070 (SELECT player FROM players WHERE nick='OJK'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1074 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1075 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1076 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1078 (SELECT player FROM players WHERE nick='Snute'),
1081 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1082 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1084 (SELECT player FROM players WHERE nick='Snute'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1088 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1091 (SELECT player FROM players WHERE nick='Snute'),
1092 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1095 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1097 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1100 INSERT INTO groups (tournament, round, parallel) VALUES (
1101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1103 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1104 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1106 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
1108 UPDATE rounds SET randomsongs=1 WHERE
1109 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
1111 UPDATE rounds SET chosensongs=1 WHERE
1112 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
1114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1115 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1116 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1118 (SELECT player FROM players WHERE nick='OJK'),
1121 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1124 (SELECT player FROM players WHERE nick='OJK'),
1125 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1128 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1129 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1131 (SELECT player FROM players WHERE nick='OJK'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1135 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1136 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1137 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1139 (SELECT player FROM players WHERE nick='DufF'),
1142 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1145 (SELECT player FROM players WHERE nick='DufF'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1149 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1152 (SELECT player FROM players WHERE nick='DufF'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' 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 2'),
1160 (SELECT player FROM players WHERE nick='Snute'),
1163 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1164 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1166 (SELECT player FROM players WHERE nick='Snute'),
1167 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1170 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1173 (SELECT player FROM players WHERE nick='Snute'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1177 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1179 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1182 INSERT INTO groups (tournament, round, parallel) VALUES (
1183 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1185 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1186 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1190 UPDATE rounds SET randomsongs=1 WHERE
1191 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
1193 UPDATE rounds SET chosensongs=1 WHERE
1194 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
1196 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1198 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1200 (SELECT player FROM players WHERE nick='Snute'),
1203 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1204 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1206 (SELECT player FROM players WHERE nick='Snute'),
1207 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1210 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1211 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1213 (SELECT player FROM players WHERE nick='Snute'),
1214 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1217 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1218 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1219 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1221 (SELECT player FROM players WHERE nick='OJK'),
1224 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1227 (SELECT player FROM players WHERE nick='OJK'),
1228 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1231 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
1234 (SELECT player FROM players WHERE nick='OJK'),
1235 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),