2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
57 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
59 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
62 INSERT INTO groups (tournament, round, parallel) VALUES (
63 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
65 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
66 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
70 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
71 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
73 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
75 UPDATE rounds SET randomsongs=2 WHERE
76 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
78 UPDATE rounds SET chosensongs=1 WHERE
79 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
81 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
82 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
83 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
85 (SELECT player FROM players WHERE nick='Bush'),
88 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
89 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
91 (SELECT player FROM players WHERE nick='Bush'),
93 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
96 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
99 (SELECT player FROM players WHERE nick='Bush'),
101 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
104 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
105 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
107 (SELECT player FROM players WHERE nick='Bush'),
109 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
112 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
113 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
116 (SELECT player FROM players WHERE nick='Ylini'),
119 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
122 (SELECT player FROM players WHERE nick='Ylini'),
124 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
130 (SELECT player FROM players WHERE nick='Ylini'),
132 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
138 (SELECT player FROM players WHERE nick='Ylini'),
140 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
143 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
144 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
147 (SELECT player FROM players WHERE nick='Stream'),
150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
153 (SELECT player FROM players WHERE nick='Stream'),
155 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
161 (SELECT player FROM players WHERE nick='Stream'),
163 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
167 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
169 (SELECT player FROM players WHERE nick='Stream'),
171 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
175 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
178 (SELECT player FROM players WHERE nick='T|na'),
181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
184 (SELECT player FROM players WHERE nick='T|na'),
186 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
190 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
192 (SELECT player FROM players WHERE nick='T|na'),
194 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
197 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
200 (SELECT player FROM players WHERE nick='T|na'),
202 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
205 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
206 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
209 (SELECT player FROM players WHERE nick='Snute'),
212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
215 (SELECT player FROM players WHERE nick='Snute'),
217 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
221 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
223 (SELECT player FROM players WHERE nick='Snute'),
225 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
228 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
231 (SELECT player FROM players WHERE nick='Snute'),
233 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
236 INSERT INTO groups (tournament, round, parallel) VALUES (
237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
239 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
242 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
244 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
247 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
249 UPDATE rounds SET randomsongs=2 WHERE
250 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
252 UPDATE rounds SET chosensongs=1 WHERE
253 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
255 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
256 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
259 (SELECT player FROM players WHERE nick='Dabi'),
262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
265 (SELECT player FROM players WHERE nick='Dabi'),
267 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
273 (SELECT player FROM players WHERE nick='Dabi'),
275 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
281 (SELECT player FROM players WHERE nick='Dabi'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
286 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
287 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
290 (SELECT player FROM players WHERE nick='Olemann'),
293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
296 (SELECT player FROM players WHERE nick='Olemann'),
298 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
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='Olemann'),
306 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
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='Olemann'),
314 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
317 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
318 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
321 (SELECT player FROM players WHERE nick='Smiph'),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
327 (SELECT player FROM players WHERE nick='Smiph'),
329 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
335 (SELECT player FROM players WHERE nick='Smiph'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
343 (SELECT player FROM players WHERE nick='Smiph'),
345 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
348 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
352 (SELECT player FROM players WHERE nick='RiChY'),
355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
358 (SELECT player FROM players WHERE nick='RiChY'),
360 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
366 (SELECT player FROM players WHERE nick='RiChY'),
368 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
374 (SELECT player FROM players WHERE nick='RiChY'),
376 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
379 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
380 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
383 (SELECT player FROM players WHERE nick='DufF'),
386 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
387 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
389 (SELECT player FROM players WHERE nick='DufF'),
391 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
397 (SELECT player FROM players WHERE nick='DufF'),
399 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
405 (SELECT player FROM players WHERE nick='DufF'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
410 INSERT INTO groups (tournament, round, parallel) VALUES (
411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
413 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
416 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
418 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
421 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
423 UPDATE rounds SET randomsongs=2 WHERE
424 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
426 UPDATE rounds SET chosensongs=1 WHERE
427 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
429 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
430 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
433 (SELECT player FROM players WHERE nick='Raazu'),
436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
439 (SELECT player FROM players WHERE nick='Raazu'),
441 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
447 (SELECT player FROM players WHERE nick='Raazu'),
449 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
455 (SELECT player FROM players WHERE nick='Raazu'),
457 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
460 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
461 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
464 (SELECT player FROM players WHERE nick='Draconia'),
467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
470 (SELECT player FROM players WHERE nick='Draconia'),
472 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
478 (SELECT player FROM players WHERE nick='Draconia'),
480 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
486 (SELECT player FROM players WHERE nick='Draconia'),
488 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
491 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
492 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
495 (SELECT player FROM players WHERE nick='Havok'),
498 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
501 (SELECT player FROM players WHERE nick='Havok'),
503 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
506 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
509 (SELECT player FROM players WHERE nick='Havok'),
511 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
514 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
515 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
517 (SELECT player FROM players WHERE nick='Havok'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
522 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
526 (SELECT player FROM players WHERE nick='Snofox'),
529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
532 (SELECT player FROM players WHERE nick='Snofox'),
534 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
540 (SELECT player FROM players WHERE nick='Snofox'),
542 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
548 (SELECT player FROM players WHERE nick='Snofox'),
550 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
553 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
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='OJK'),
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='OJK'),
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='OJK'),
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='OJK'),
581 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
584 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
586 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
589 INSERT INTO groups (tournament, round, parallel) VALUES (
590 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
592 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
595 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
597 UPDATE rounds SET randomsongs=1 WHERE
598 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
600 UPDATE rounds SET chosensongs=1 WHERE
601 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
603 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
604 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
607 (SELECT player FROM players WHERE nick='Raazu'),
610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
613 (SELECT player FROM players WHERE nick='Raazu'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
618 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
619 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
621 (SELECT player FROM players WHERE nick='Raazu'),
623 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
626 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
627 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
630 (SELECT player FROM players WHERE nick='Stream'),
633 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
636 (SELECT player FROM players WHERE nick='Stream'),
638 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
641 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
644 (SELECT player FROM players WHERE nick='Stream'),
646 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
649 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
650 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
653 (SELECT player FROM players WHERE nick='Olemann'),
656 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
659 (SELECT player FROM players WHERE nick='Olemann'),
661 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
665 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
667 (SELECT player FROM players WHERE nick='Olemann'),
669 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
672 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
673 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
676 (SELECT player FROM players WHERE nick='T|na'),
679 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
680 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
682 (SELECT player FROM players WHERE nick='T|na'),
684 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
687 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
690 (SELECT player FROM players WHERE nick='T|na'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
695 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
696 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
697 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
699 (SELECT player FROM players WHERE nick='Snofox'),
702 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
703 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
705 (SELECT player FROM players WHERE nick='Snofox'),
707 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
711 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
713 (SELECT player FROM players WHERE nick='Snofox'),
715 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
718 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
719 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
722 (SELECT player FROM players WHERE nick='RiChY'),
725 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
728 (SELECT player FROM players WHERE nick='RiChY'),
730 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
733 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
736 (SELECT player FROM players WHERE nick='RiChY'),
738 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
741 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
742 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
745 (SELECT player FROM players WHERE nick='Snute'),
748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
749 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
751 (SELECT player FROM players WHERE nick='Snute'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
759 (SELECT player FROM players WHERE nick='Snute'),
761 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
764 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
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='OJK'),
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='OJK'),
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='OJK'),
784 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
787 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
788 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
791 (SELECT player FROM players WHERE nick='DufF'),
794 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
795 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
797 (SELECT player FROM players WHERE nick='DufF'),
799 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
802 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
803 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
805 (SELECT player FROM players WHERE nick='DufF'),
807 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
810 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
812 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
815 INSERT INTO groups (tournament, round, parallel) VALUES (
816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
818 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
821 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
823 UPDATE rounds SET randomsongs=1 WHERE
824 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
826 UPDATE rounds SET chosensongs=1 WHERE
827 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
829 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
830 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
833 (SELECT player FROM players WHERE nick='Stream'),
836 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
837 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
839 (SELECT player FROM players WHERE nick='Stream'),
841 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
845 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
847 (SELECT player FROM players WHERE nick='Stream'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
852 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
853 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
856 (SELECT player FROM players WHERE nick='T|na'),
859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
862 (SELECT player FROM players WHERE nick='T|na'),
864 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
870 (SELECT player FROM players WHERE nick='T|na'),
872 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
875 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
876 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
879 (SELECT player FROM players WHERE nick='RiChY'),
882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
885 (SELECT player FROM players WHERE nick='RiChY'),
887 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
893 (SELECT player FROM players WHERE nick='RiChY'),
895 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
898 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
899 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
902 (SELECT player FROM players WHERE nick='Snofox'),
905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
908 (SELECT player FROM players WHERE nick='Snofox'),
910 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
916 (SELECT player FROM players WHERE nick='Snofox'),
918 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
921 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
922 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
925 (SELECT player FROM players WHERE nick='OJK'),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
931 (SELECT player FROM players WHERE nick='OJK'),
933 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
939 (SELECT player FROM players WHERE nick='OJK'),
941 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
944 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
945 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
946 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
948 (SELECT player FROM players WHERE nick='Snute'),
951 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
954 (SELECT player FROM players WHERE nick='Snute'),
956 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
959 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
962 (SELECT player FROM players WHERE nick='Snute'),
964 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
967 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
968 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
969 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
971 (SELECT player FROM players WHERE nick='DufF'),
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='DufF'),
979 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
985 (SELECT player FROM players WHERE nick='DufF'),
987 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
990 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
992 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
995 INSERT INTO groups (tournament, round, parallel) VALUES (
996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
998 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
1003 UPDATE rounds SET randomsongs=1 WHERE
1004 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1006 UPDATE rounds SET chosensongs=1 WHERE
1007 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1009 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1010 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1013 (SELECT player FROM players WHERE nick='OJK'),
1016 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1017 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1019 (SELECT player FROM players WHERE nick='OJK'),
1021 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1024 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1027 (SELECT player FROM players WHERE nick='OJK'),
1029 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1032 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1033 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1036 (SELECT player FROM players WHERE nick='T|na'),
1039 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1040 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1042 (SELECT player FROM players WHERE nick='T|na'),
1044 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1047 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1048 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1050 (SELECT player FROM players WHERE nick='T|na'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1055 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1056 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1059 (SELECT player FROM players WHERE nick='Snofox'),
1062 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1063 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1065 (SELECT player FROM players WHERE nick='Snofox'),
1067 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1071 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1073 (SELECT player FROM players WHERE nick='Snofox'),
1075 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1078 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1079 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1080 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1082 (SELECT player FROM players WHERE nick='DufF'),
1085 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1088 (SELECT player FROM players WHERE nick='DufF'),
1090 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1093 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1096 (SELECT player FROM players WHERE nick='DufF'),
1098 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1101 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1102 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1105 (SELECT player FROM players WHERE nick='Snute'),
1108 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1111 (SELECT player FROM players WHERE nick='Snute'),
1113 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1116 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1119 (SELECT player FROM players WHERE nick='Snute'),
1121 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1124 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1129 INSERT INTO groups (tournament, round, parallel) VALUES (
1130 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1132 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1137 UPDATE rounds SET randomsongs=1 WHERE
1138 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1140 UPDATE rounds SET chosensongs=1 WHERE
1141 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1143 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1144 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1147 (SELECT player FROM players WHERE nick='Snofox'),
1150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1153 (SELECT player FROM players WHERE nick='Snofox'),
1155 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
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('Max 300')),
1166 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1170 (SELECT player FROM players WHERE nick='DufF'),
1173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1176 (SELECT player FROM players WHERE nick='DufF'),
1178 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1184 (SELECT player FROM players WHERE nick='DufF'),
1186 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1189 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1190 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1193 (SELECT player FROM players WHERE nick='OJK'),
1196 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1197 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1199 (SELECT player FROM players WHERE nick='OJK'),
1201 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1207 (SELECT player FROM players WHERE nick='OJK'),
1209 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1212 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1213 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1216 (SELECT player FROM players WHERE nick='Snute'),
1219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1222 (SELECT player FROM players WHERE nick='Snute'),
1224 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1230 (SELECT player FROM players WHERE nick='Snute'),
1232 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1235 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1240 INSERT INTO groups (tournament, round, parallel) VALUES (
1241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1243 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1244 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1246 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
1248 UPDATE rounds SET randomsongs=1 WHERE
1249 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1251 UPDATE rounds SET chosensongs=1 WHERE
1252 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1254 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1255 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1258 (SELECT player FROM players WHERE nick='OJK'),
1261 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1264 (SELECT player FROM players WHERE nick='OJK'),
1266 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1269 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1270 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1272 (SELECT player FROM players WHERE nick='OJK'),
1274 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1277 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1278 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1281 (SELECT player FROM players WHERE nick='DufF'),
1284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1287 (SELECT player FROM players WHERE nick='DufF'),
1289 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1292 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1295 (SELECT player FROM players WHERE nick='DufF'),
1297 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1300 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1301 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1304 (SELECT player FROM players WHERE nick='Snute'),
1307 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1308 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1310 (SELECT player FROM players WHERE nick='Snute'),
1312 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1315 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1316 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1318 (SELECT player FROM players WHERE nick='Snute'),
1320 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1323 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1328 INSERT INTO groups (tournament, round, parallel) VALUES (
1329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1331 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1334 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1336 UPDATE rounds SET randomsongs=1 WHERE
1337 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1339 UPDATE rounds SET chosensongs=1 WHERE
1340 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1342 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1343 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1346 (SELECT player FROM players WHERE nick='Snute'),
1349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1352 (SELECT player FROM players WHERE nick='Snute'),
1354 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1360 (SELECT player FROM players WHERE nick='Snute'),
1362 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1365 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
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')),