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 rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE tournamentname='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 tournamentname='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 tournamentname='Challenge Cup 2') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='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 tournamentname='Challenge Cup 2'),
40 (SELECT player FROM players WHERE nick='Bush'),
43 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
46 (SELECT player FROM players WHERE nick='Bush'),
48 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
54 (SELECT player FROM players WHERE nick='Bush'),
56 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
62 (SELECT player FROM players WHERE nick='Bush'),
64 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
67 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
68 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
69 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
71 (SELECT player FROM players WHERE nick='Ylini'),
74 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
75 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
77 (SELECT player FROM players WHERE nick='Ylini'),
79 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
85 (SELECT player FROM players WHERE nick='Ylini'),
87 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
93 (SELECT player FROM players WHERE nick='Ylini'),
95 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
99 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
102 (SELECT player FROM players WHERE nick='Stream'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
108 (SELECT player FROM players WHERE nick='Stream'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
116 (SELECT player FROM players WHERE nick='Stream'),
118 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
124 (SELECT player FROM players WHERE nick='Stream'),
126 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
133 (SELECT player FROM players WHERE nick='T|na'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
139 (SELECT player FROM players WHERE nick='T|na'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
147 (SELECT player FROM players WHERE nick='T|na'),
149 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
155 (SELECT player FROM players WHERE nick='T|na'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
164 (SELECT player FROM players WHERE nick='Snute'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
170 (SELECT player FROM players WHERE nick='Snute'),
172 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
178 (SELECT player FROM players WHERE nick='Snute'),
180 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
186 (SELECT player FROM players WHERE nick='Snute'),
188 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
191 INSERT INTO groups (tournament, round, parallel) VALUES (
192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
194 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
197 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
199 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
202 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
204 UPDATE rounds SET randomsongs=2 WHERE
205 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
207 UPDATE rounds SET chosensongs=1 WHERE
208 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
214 (SELECT player FROM players WHERE nick='Dabi'),
217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
220 (SELECT player FROM players WHERE nick='Dabi'),
222 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
228 (SELECT player FROM players WHERE nick='Dabi'),
230 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
236 (SELECT player FROM players WHERE nick='Dabi'),
238 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
245 (SELECT player FROM players WHERE nick='Olemann'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
251 (SELECT player FROM players WHERE nick='Olemann'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
259 (SELECT player FROM players WHERE nick='Olemann'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
267 (SELECT player FROM players WHERE nick='Olemann'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
276 (SELECT player FROM players WHERE nick='Smiph'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
282 (SELECT player FROM players WHERE nick='Smiph'),
284 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
290 (SELECT player FROM players WHERE nick='Smiph'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
298 (SELECT player FROM players WHERE nick='Smiph'),
300 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
307 (SELECT player FROM players WHERE nick='RiChY'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
313 (SELECT player FROM players WHERE nick='RiChY'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
321 (SELECT player FROM players WHERE nick='RiChY'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
329 (SELECT player FROM players WHERE nick='RiChY'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
338 (SELECT player FROM players WHERE nick='DufF'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
344 (SELECT player FROM players WHERE nick='DufF'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
352 (SELECT player FROM players WHERE nick='DufF'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
360 (SELECT player FROM players WHERE nick='DufF'),
362 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
365 INSERT INTO groups (tournament, round, parallel) VALUES (
366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
368 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
371 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
373 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
376 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
378 UPDATE rounds SET randomsongs=2 WHERE
379 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
381 UPDATE rounds SET chosensongs=1 WHERE
382 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
384 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
388 (SELECT player FROM players WHERE nick='Raazu'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
394 (SELECT player FROM players WHERE nick='Raazu'),
396 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
402 (SELECT player FROM players WHERE nick='Raazu'),
404 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
410 (SELECT player FROM players WHERE nick='Raazu'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
415 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
416 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
419 (SELECT player FROM players WHERE nick='Draconia'),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
425 (SELECT player FROM players WHERE nick='Draconia'),
427 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
433 (SELECT player FROM players WHERE nick='Draconia'),
435 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
441 (SELECT player FROM players WHERE nick='Draconia'),
443 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
450 (SELECT player FROM players WHERE nick='Havok'),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
456 (SELECT player FROM players WHERE nick='Havok'),
458 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
464 (SELECT player FROM players WHERE nick='Havok'),
466 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
472 (SELECT player FROM players WHERE nick='Havok'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
481 (SELECT player FROM players WHERE nick='Snofox'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
487 (SELECT player FROM players WHERE nick='Snofox'),
489 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
495 (SELECT player FROM players WHERE nick='Snofox'),
497 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
503 (SELECT player FROM players WHERE nick='Snofox'),
505 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
509 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
512 (SELECT player FROM players WHERE nick='OJK'),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
518 (SELECT player FROM players WHERE nick='OJK'),
520 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
526 (SELECT player FROM players WHERE nick='OJK'),
528 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
534 (SELECT player FROM players WHERE nick='OJK'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
539 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
544 INSERT INTO groups (tournament, round, parallel) VALUES (
545 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
547 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
550 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
552 UPDATE rounds SET randomsongs=1 WHERE
553 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
555 UPDATE rounds SET chosensongs=1 WHERE
556 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
558 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
559 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
562 (SELECT player FROM players WHERE nick='Raazu'),
565 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
566 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
568 (SELECT player FROM players WHERE nick='Raazu'),
570 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
576 (SELECT player FROM players WHERE nick='Raazu'),
578 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
581 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
582 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
583 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
585 (SELECT player FROM players WHERE nick='Stream'),
588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
591 (SELECT player FROM players WHERE nick='Stream'),
593 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
599 (SELECT player FROM players WHERE nick='Stream'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
604 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
605 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
606 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
608 (SELECT player FROM players WHERE nick='Olemann'),
611 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
614 (SELECT player FROM players WHERE nick='Olemann'),
616 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
619 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
622 (SELECT player FROM players WHERE nick='Olemann'),
624 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
627 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
628 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
631 (SELECT player FROM players WHERE nick='T|na'),
634 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
635 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
637 (SELECT player FROM players WHERE nick='T|na'),
639 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
642 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
643 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
645 (SELECT player FROM players WHERE nick='T|na'),
647 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
650 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
654 (SELECT player FROM players WHERE nick='Snofox'),
657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
660 (SELECT player FROM players WHERE nick='Snofox'),
662 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
668 (SELECT player FROM players WHERE nick='Snofox'),
670 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
673 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
677 (SELECT player FROM players WHERE nick='RiChY'),
680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
683 (SELECT player FROM players WHERE nick='RiChY'),
685 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
691 (SELECT player FROM players WHERE nick='RiChY'),
693 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
696 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
697 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
700 (SELECT player FROM players WHERE nick='Snute'),
703 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
706 (SELECT player FROM players WHERE nick='Snute'),
708 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
714 (SELECT player FROM players WHERE nick='Snute'),
716 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
719 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
720 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
723 (SELECT player FROM players WHERE nick='OJK'),
726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
729 (SELECT player FROM players WHERE nick='OJK'),
731 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
734 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
735 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
737 (SELECT player FROM players WHERE nick='OJK'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
742 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
743 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
746 (SELECT player FROM players WHERE nick='DufF'),
749 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
752 (SELECT player FROM players WHERE nick='DufF'),
754 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
757 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
758 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
760 (SELECT player FROM players WHERE nick='DufF'),
762 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
765 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
770 INSERT INTO groups (tournament, round, parallel) VALUES (
771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
773 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
774 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
778 UPDATE rounds SET randomsongs=1 WHERE
779 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
781 UPDATE rounds SET chosensongs=1 WHERE
782 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
788 (SELECT player FROM players WHERE nick='Stream'),
791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
794 (SELECT player FROM players WHERE nick='Stream'),
796 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
799 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
802 (SELECT player FROM players WHERE nick='Stream'),
804 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
807 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
808 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
809 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
811 (SELECT player FROM players WHERE nick='T|na'),
814 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
815 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
817 (SELECT player FROM players WHERE nick='T|na'),
819 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
822 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
823 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
825 (SELECT player FROM players WHERE nick='T|na'),
827 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
830 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
831 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
834 (SELECT player FROM players WHERE nick='RiChY'),
837 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
840 (SELECT player FROM players WHERE nick='RiChY'),
842 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
845 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
848 (SELECT player FROM players WHERE nick='RiChY'),
850 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
853 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
857 (SELECT player FROM players WHERE nick='Snofox'),
860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
863 (SELECT player FROM players WHERE nick='Snofox'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
871 (SELECT player FROM players WHERE nick='Snofox'),
873 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
876 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
877 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
880 (SELECT player FROM players WHERE nick='OJK'),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
886 (SELECT player FROM players WHERE nick='OJK'),
888 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
894 (SELECT player FROM players WHERE nick='OJK'),
896 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
899 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
900 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
901 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
903 (SELECT player FROM players WHERE nick='Snute'),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
909 (SELECT player FROM players WHERE nick='Snute'),
911 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
914 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
917 (SELECT player FROM players WHERE nick='Snute'),
919 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
922 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
923 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
924 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
926 (SELECT player FROM players WHERE nick='DufF'),
929 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
930 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
932 (SELECT player FROM players WHERE nick='DufF'),
934 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
937 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
938 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
940 (SELECT player FROM players WHERE nick='DufF'),
942 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
945 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
947 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
950 INSERT INTO groups (tournament, round, parallel) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
953 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
954 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
956 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
958 UPDATE rounds SET randomsongs=1 WHERE
959 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
961 UPDATE rounds SET chosensongs=1 WHERE
962 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
964 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
965 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
968 (SELECT player FROM players WHERE nick='OJK'),
971 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
972 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
974 (SELECT player FROM players WHERE nick='OJK'),
976 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
979 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
980 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
982 (SELECT player FROM players WHERE nick='OJK'),
984 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
987 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
988 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
991 (SELECT player FROM players WHERE nick='T|na'),
994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
997 (SELECT player FROM players WHERE nick='T|na'),
999 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1005 (SELECT player FROM players WHERE nick='T|na'),
1007 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1010 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1011 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1012 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1014 (SELECT player FROM players WHERE nick='Snofox'),
1017 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1018 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1020 (SELECT player FROM players WHERE nick='Snofox'),
1022 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1028 (SELECT player FROM players WHERE nick='Snofox'),
1030 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1033 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1034 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1037 (SELECT player FROM players WHERE nick='DufF'),
1040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1041 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1043 (SELECT player FROM players WHERE nick='DufF'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1051 (SELECT player FROM players WHERE nick='DufF'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1057 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1058 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1060 (SELECT player FROM players WHERE nick='Snute'),
1063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1064 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1066 (SELECT player FROM players WHERE nick='Snute'),
1068 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
1071 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1072 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1074 (SELECT player FROM players WHERE nick='Snute'),
1076 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1079 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1084 INSERT INTO groups (tournament, round, parallel) VALUES (
1085 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1087 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1090 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1092 UPDATE rounds SET randomsongs=1 WHERE
1093 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1095 UPDATE rounds SET chosensongs=1 WHERE
1096 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1098 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1102 (SELECT player FROM players WHERE nick='Snofox'),
1105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1108 (SELECT player FROM players WHERE nick='Snofox'),
1110 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1116 (SELECT player FROM players WHERE nick='Snofox'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1121 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1122 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1125 (SELECT player FROM players WHERE nick='DufF'),
1128 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1129 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1131 (SELECT player FROM players WHERE nick='DufF'),
1133 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1139 (SELECT player FROM players WHERE nick='DufF'),
1141 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1145 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1148 (SELECT player FROM players WHERE nick='OJK'),
1151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1154 (SELECT player FROM players WHERE nick='OJK'),
1156 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1159 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1160 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1162 (SELECT player FROM players WHERE nick='OJK'),
1164 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1167 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1169 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1171 (SELECT player FROM players WHERE nick='Snute'),
1174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1175 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1177 (SELECT player FROM players WHERE nick='Snute'),
1179 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1185 (SELECT player FROM players WHERE nick='Snute'),
1187 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1190 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1195 INSERT INTO groups (tournament, round, parallel) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1198 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1201 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
1203 UPDATE rounds SET randomsongs=1 WHERE
1204 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1206 UPDATE rounds SET chosensongs=1 WHERE
1207 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1209 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1211 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1213 (SELECT player FROM players WHERE nick='OJK'),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1219 (SELECT player FROM players WHERE nick='OJK'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1227 (SELECT player FROM players WHERE nick='OJK'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1232 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1233 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1236 (SELECT player FROM players WHERE nick='DufF'),
1239 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1242 (SELECT player FROM players WHERE nick='DufF'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1250 (SELECT player FROM players WHERE nick='DufF'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1255 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1256 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1259 (SELECT player FROM players WHERE nick='Snute'),
1262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1265 (SELECT player FROM players WHERE nick='Snute'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1273 (SELECT player FROM players WHERE nick='Snute'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1278 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1283 INSERT INTO groups (tournament, round, parallel) VALUES (
1284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1286 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1289 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1291 UPDATE rounds SET randomsongs=1 WHERE
1292 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1294 UPDATE rounds SET chosensongs=1 WHERE
1295 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2') AND
1297 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1298 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1301 (SELECT player FROM players WHERE nick='Snute'),
1304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1307 (SELECT player FROM players WHERE nick='Snute'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1315 (SELECT player FROM players WHERE nick='Snute'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1320 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1321 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1324 (SELECT player FROM players WHERE nick='OJK'),
1327 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1330 (SELECT player FROM players WHERE nick='OJK'),
1332 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1335 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'),
1338 (SELECT player FROM players WHERE nick='OJK'),
1340 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),