2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
5 'Challenge Cup 1 - 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 1 - 2004'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Candy'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' 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 1 - 2004'),
40 (SELECT player FROM players WHERE nick='Haggar'),
43 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
46 (SELECT player FROM players WHERE nick='Haggar'),
48 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
54 (SELECT player FROM players WHERE nick='Haggar'),
56 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
62 (SELECT player FROM players WHERE nick='Haggar'),
64 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
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 1 - 2004'),
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 1 - 2004'),
77 (SELECT player FROM players WHERE nick='Ylini'),
79 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
85 (SELECT player FROM players WHERE nick='Ylini'),
87 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
93 (SELECT player FROM players WHERE nick='Ylini'),
95 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' 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 1 - 2004'),
102 (SELECT player FROM players WHERE nick='Mulefisk'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
108 (SELECT player FROM players WHERE nick='Mulefisk'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
116 (SELECT player FROM players WHERE nick='Mulefisk'),
118 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
124 (SELECT player FROM players WHERE nick='Mulefisk'),
126 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' 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 1 - 2004'),
133 (SELECT player FROM players WHERE nick='Slusk'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
139 (SELECT player FROM players WHERE nick='Slusk'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
147 (SELECT player FROM players WHERE nick='Slusk'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
155 (SELECT player FROM players WHERE nick='Slusk'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' 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 1 - 2004'),
164 (SELECT player FROM players WHERE nick='Tom'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
170 (SELECT player FROM players WHERE nick='Tom'),
172 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
178 (SELECT player FROM players WHERE nick='Tom'),
180 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
186 (SELECT player FROM players WHERE nick='Tom'),
188 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
191 INSERT INTO groups (tournament, round, parallel) VALUES (
192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
194 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
197 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
199 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
202 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
204 UPDATE rounds SET randomsongs=2 WHERE
205 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
207 UPDATE rounds SET chosensongs=1 WHERE
208 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' 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 1 - 2004'),
214 (SELECT player FROM players WHERE nick='Golddragon'),
217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
220 (SELECT player FROM players WHERE nick='Golddragon'),
222 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
228 (SELECT player FROM players WHERE nick='Golddragon'),
230 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
236 (SELECT player FROM players WHERE nick='Golddragon'),
238 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' 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 1 - 2004'),
245 (SELECT player FROM players WHERE nick='Jallaman'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
251 (SELECT player FROM players WHERE nick='Jallaman'),
253 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
259 (SELECT player FROM players WHERE nick='Jallaman'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
267 (SELECT player FROM players WHERE nick='Jallaman'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' 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 1 - 2004'),
276 (SELECT player FROM players WHERE nick='OJK'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
282 (SELECT player FROM players WHERE nick='OJK'),
284 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
290 (SELECT player FROM players WHERE nick='OJK'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
298 (SELECT player FROM players WHERE nick='OJK'),
300 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' 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 1 - 2004'),
307 (SELECT player FROM players WHERE nick='Matsi'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
313 (SELECT player FROM players WHERE nick='Matsi'),
315 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
321 (SELECT player FROM players WHERE nick='Matsi'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
329 (SELECT player FROM players WHERE nick='Matsi'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' 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 1 - 2004'),
338 (SELECT player FROM players WHERE nick='Snute'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
344 (SELECT player FROM players WHERE nick='Snute'),
346 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
352 (SELECT player FROM players WHERE nick='Snute'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
360 (SELECT player FROM players WHERE nick='Snute'),
362 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
365 INSERT INTO groups (tournament, round, parallel) VALUES (
366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
368 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
371 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
373 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
376 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
378 UPDATE rounds SET randomsongs=2 WHERE
379 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
381 UPDATE rounds SET chosensongs=1 WHERE
382 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
384 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' 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 1 - 2004'),
388 (SELECT player FROM players WHERE nick='tombot'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
394 (SELECT player FROM players WHERE nick='tombot'),
396 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
402 (SELECT player FROM players WHERE nick='tombot'),
404 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
410 (SELECT player FROM players WHERE nick='tombot'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
415 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' 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 1 - 2004'),
419 (SELECT player FROM players WHERE nick='Ink'),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
425 (SELECT player FROM players WHERE nick='Ink'),
427 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
433 (SELECT player FROM players WHERE nick='Ink'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
441 (SELECT player FROM players WHERE nick='Ink'),
443 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' 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 1 - 2004'),
450 (SELECT player FROM players WHERE nick='Stream'),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
456 (SELECT player FROM players WHERE nick='Stream'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
464 (SELECT player FROM players WHERE nick='Stream'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
472 (SELECT player FROM players WHERE nick='Stream'),
474 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' 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 1 - 2004'),
481 (SELECT player FROM players WHERE nick='Spinnvill'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
487 (SELECT player FROM players WHERE nick='Spinnvill'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
495 (SELECT player FROM players WHERE nick='Spinnvill'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
503 (SELECT player FROM players WHERE nick='Spinnvill'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' 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 1 - 2004'),
512 (SELECT player FROM players WHERE nick='Telc'),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
518 (SELECT player FROM players WHERE nick='Telc'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
526 (SELECT player FROM players WHERE nick='Telc'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
534 (SELECT player FROM players WHERE nick='Telc'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
539 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
540 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
543 (SELECT player FROM players WHERE nick='DufF'),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
549 (SELECT player FROM players WHERE nick='DufF'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
557 (SELECT player FROM players WHERE nick='DufF'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
565 (SELECT player FROM players WHERE nick='DufF'),
567 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
570 INSERT INTO groups (tournament, round, parallel) VALUES (
571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
573 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
576 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
578 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
581 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
583 UPDATE rounds SET randomsongs=2 WHERE
584 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
586 UPDATE rounds SET chosensongs=1 WHERE
587 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
589 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
593 (SELECT player FROM players WHERE nick='Duckling'),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
599 (SELECT player FROM players WHERE nick='Duckling'),
601 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
607 (SELECT player FROM players WHERE nick='Duckling'),
609 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
612 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
613 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
615 (SELECT player FROM players WHERE nick='Duckling'),
617 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
620 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
621 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
624 (SELECT player FROM players WHERE nick='Auran'),
627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
630 (SELECT player FROM players WHERE nick='Auran'),
632 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
638 (SELECT player FROM players WHERE nick='Auran'),
640 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
646 (SELECT player FROM players WHERE nick='Auran'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
651 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
652 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
655 (SELECT player FROM players WHERE nick='Advena'),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
661 (SELECT player FROM players WHERE nick='Advena'),
663 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
669 (SELECT player FROM players WHERE nick='Advena'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
677 (SELECT player FROM players WHERE nick='Advena'),
679 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
682 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
683 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
684 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
686 (SELECT player FROM players WHERE nick='Snofox'),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
692 (SELECT player FROM players WHERE nick='Snofox'),
694 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
700 (SELECT player FROM players WHERE nick='Snofox'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
705 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
708 (SELECT player FROM players WHERE nick='Snofox'),
710 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
713 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
717 (SELECT player FROM players WHERE nick='Smiph'),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
723 (SELECT player FROM players WHERE nick='Smiph'),
725 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
731 (SELECT player FROM players WHERE nick='Smiph'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
739 (SELECT player FROM players WHERE nick='Smiph'),
741 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
744 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
745 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
748 (SELECT player FROM players WHERE nick='Oliyzia'),
751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
754 (SELECT player FROM players WHERE nick='Oliyzia'),
756 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
762 (SELECT player FROM players WHERE nick='Oliyzia'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
770 (SELECT player FROM players WHERE nick='Oliyzia'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
775 INSERT INTO groups (tournament, round, parallel) VALUES (
776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
778 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
783 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
786 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
788 UPDATE rounds SET randomsongs=2 WHERE
789 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
791 UPDATE rounds SET chosensongs=1 WHERE
792 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
794 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
798 (SELECT player FROM players WHERE nick='x3mnrj'),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
804 (SELECT player FROM players WHERE nick='x3mnrj'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
812 (SELECT player FROM players WHERE nick='x3mnrj'),
814 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
820 (SELECT player FROM players WHERE nick='x3mnrj'),
822 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
825 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
826 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
829 (SELECT player FROM players WHERE nick='Octu'),
832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
835 (SELECT player FROM players WHERE nick='Octu'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
843 (SELECT player FROM players WHERE nick='Octu'),
845 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
851 (SELECT player FROM players WHERE nick='Octu'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
856 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
857 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
858 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
860 (SELECT player FROM players WHERE nick='Electus'),
863 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
866 (SELECT player FROM players WHERE nick='Electus'),
868 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
874 (SELECT player FROM players WHERE nick='Electus'),
876 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
880 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
882 (SELECT player FROM players WHERE nick='Electus'),
884 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
889 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
891 (SELECT player FROM players WHERE nick='Purity'),
894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
897 (SELECT player FROM players WHERE nick='Purity'),
899 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
905 (SELECT player FROM players WHERE nick='Purity'),
907 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
913 (SELECT player FROM players WHERE nick='Purity'),
915 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
918 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
919 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
922 (SELECT player FROM players WHERE nick='Havok'),
925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
928 (SELECT player FROM players WHERE nick='Havok'),
930 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
936 (SELECT player FROM players WHERE nick='Havok'),
938 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
944 (SELECT player FROM players WHERE nick='Havok'),
946 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
949 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
953 (SELECT player FROM players WHERE nick='Draconia'),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
959 (SELECT player FROM players WHERE nick='Draconia'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
967 (SELECT player FROM players WHERE nick='Draconia'),
969 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
975 (SELECT player FROM players WHERE nick='Draconia'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
980 INSERT INTO groups (tournament, round, parallel) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
983 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
984 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
986 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
988 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
991 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
993 UPDATE rounds SET randomsongs=2 WHERE
994 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
996 UPDATE rounds SET chosensongs=1 WHERE
997 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
999 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
1000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1003 (SELECT player FROM players WHERE nick='Dexter'),
1006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1009 (SELECT player FROM players WHERE nick='Dexter'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1017 (SELECT player FROM players WHERE nick='Dexter'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1022 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1025 (SELECT player FROM players WHERE nick='Dexter'),
1027 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1030 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1031 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1032 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1034 (SELECT player FROM players WHERE nick='Olemann'),
1037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1038 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1040 (SELECT player FROM players WHERE nick='Olemann'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1048 (SELECT player FROM players WHERE nick='Olemann'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1053 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1054 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1056 (SELECT player FROM players WHERE nick='Olemann'),
1058 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1061 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
1062 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1063 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1065 (SELECT player FROM players WHERE nick='Tha Dragon'),
1068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1071 (SELECT player FROM players WHERE nick='Tha Dragon'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1079 (SELECT player FROM players WHERE nick='Tha Dragon'),
1081 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1084 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1087 (SELECT player FROM players WHERE nick='Tha Dragon'),
1089 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1092 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1093 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1096 (SELECT player FROM players WHERE nick='T|na'),
1099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1102 (SELECT player FROM players WHERE nick='T|na'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1110 (SELECT player FROM players WHERE nick='T|na'),
1112 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1115 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1118 (SELECT player FROM players WHERE nick='T|na'),
1120 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1123 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1124 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1125 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1127 (SELECT player FROM players WHERE nick='RiChY'),
1130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1133 (SELECT player FROM players WHERE nick='RiChY'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1141 (SELECT player FROM players WHERE nick='RiChY'),
1143 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1149 (SELECT player FROM players WHERE nick='RiChY'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1154 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1158 (SELECT player FROM players WHERE nick='Daniil'),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1164 (SELECT player FROM players WHERE nick='Daniil'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1172 (SELECT player FROM players WHERE nick='Daniil'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1180 (SELECT player FROM players WHERE nick='Daniil'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1185 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1190 INSERT INTO groups (tournament, round, parallel) VALUES (
1191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1193 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1196 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1198 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1201 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1203 UPDATE rounds SET randomsongs=2 WHERE
1204 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1206 UPDATE rounds SET chosensongs=1 WHERE
1207 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1209 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' 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 1 - 2004'),
1213 (SELECT player FROM players WHERE nick='Smiph'),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1219 (SELECT player FROM players WHERE nick='Smiph'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1227 (SELECT player FROM players WHERE nick='Smiph'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1235 (SELECT player FROM players WHERE nick='Smiph'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1240 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1244 (SELECT player FROM players WHERE nick='Daniil'),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1250 (SELECT player FROM players WHERE nick='Daniil'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1258 (SELECT player FROM players WHERE nick='Daniil'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1266 (SELECT player FROM players WHERE nick='Daniil'),
1268 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1271 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1272 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1273 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1275 (SELECT player FROM players WHERE nick='Snofox'),
1278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1281 (SELECT player FROM players WHERE nick='Snofox'),
1283 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1289 (SELECT player FROM players WHERE nick='Snofox'),
1291 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1297 (SELECT player FROM players WHERE nick='Snofox'),
1299 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1302 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1303 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1306 (SELECT player FROM players WHERE nick='Snute'),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1312 (SELECT player FROM players WHERE nick='Snute'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1320 (SELECT player FROM players WHERE nick='Snute'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1325 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1328 (SELECT player FROM players WHERE nick='Snute'),
1330 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1333 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
1334 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1337 (SELECT player FROM players WHERE nick='Purity'),
1340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1343 (SELECT player FROM players WHERE nick='Purity'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1351 (SELECT player FROM players WHERE nick='Purity'),
1353 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1359 (SELECT player FROM players WHERE nick='Purity'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1364 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1365 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1368 (SELECT player FROM players WHERE nick='DufF'),
1371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1374 (SELECT player FROM players WHERE nick='DufF'),
1376 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1382 (SELECT player FROM players WHERE nick='DufF'),
1384 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1390 (SELECT player FROM players WHERE nick='DufF'),
1392 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1395 INSERT INTO groups (tournament, round, parallel) VALUES (
1396 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1398 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1399 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1401 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
1403 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1406 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1408 UPDATE rounds SET randomsongs=2 WHERE
1409 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1411 UPDATE rounds SET chosensongs=1 WHERE
1412 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1414 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
1415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1418 (SELECT player FROM players WHERE nick='Havok'),
1421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1424 (SELECT player FROM players WHERE nick='Havok'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1432 (SELECT player FROM players WHERE nick='Havok'),
1434 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1440 (SELECT player FROM players WHERE nick='Havok'),
1442 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1445 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
1446 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1447 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1449 (SELECT player FROM players WHERE nick='Jallaman'),
1452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1455 (SELECT player FROM players WHERE nick='Jallaman'),
1457 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1463 (SELECT player FROM players WHERE nick='Jallaman'),
1465 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1471 (SELECT player FROM players WHERE nick='Jallaman'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1476 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1477 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1480 (SELECT player FROM players WHERE nick='Haggar'),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1486 (SELECT player FROM players WHERE nick='Haggar'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1491 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1492 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1494 (SELECT player FROM players WHERE nick='Haggar'),
1496 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1499 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1502 (SELECT player FROM players WHERE nick='Haggar'),
1504 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1507 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1508 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1511 (SELECT player FROM players WHERE nick='T|na'),
1514 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1515 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1517 (SELECT player FROM players WHERE nick='T|na'),
1519 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1522 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1523 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1525 (SELECT player FROM players WHERE nick='T|na'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1533 (SELECT player FROM players WHERE nick='T|na'),
1535 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1538 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1539 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1542 (SELECT player FROM players WHERE nick='OJK'),
1545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1548 (SELECT player FROM players WHERE nick='OJK'),
1550 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1556 (SELECT player FROM players WHERE nick='OJK'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1564 (SELECT player FROM players WHERE nick='OJK'),
1566 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1569 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1570 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1573 (SELECT player FROM players WHERE nick='RiChY'),
1576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1579 (SELECT player FROM players WHERE nick='RiChY'),
1581 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1587 (SELECT player FROM players WHERE nick='RiChY'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1595 (SELECT player FROM players WHERE nick='RiChY'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1600 INSERT INTO groups (tournament, round, parallel) VALUES (
1601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1603 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1604 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1606 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1608 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1613 UPDATE rounds SET randomsongs=2 WHERE
1614 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1616 UPDATE rounds SET chosensongs=1 WHERE
1617 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1619 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1620 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1623 (SELECT player FROM players WHERE nick='Mulefisk'),
1626 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1629 (SELECT player FROM players WHERE nick='Mulefisk'),
1631 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1634 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1635 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1637 (SELECT player FROM players WHERE nick='Mulefisk'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1642 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1643 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1645 (SELECT player FROM players WHERE nick='Mulefisk'),
1647 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1650 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1654 (SELECT player FROM players WHERE nick='Stream'),
1657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1660 (SELECT player FROM players WHERE nick='Stream'),
1662 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1668 (SELECT player FROM players WHERE nick='Stream'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1673 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1676 (SELECT player FROM players WHERE nick='Stream'),
1678 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
1682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1683 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1685 (SELECT player FROM players WHERE nick='Electus'),
1688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1691 (SELECT player FROM players WHERE nick='Electus'),
1693 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1699 (SELECT player FROM players WHERE nick='Electus'),
1701 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1704 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1705 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1707 (SELECT player FROM players WHERE nick='Electus'),
1709 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1712 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
1713 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1714 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1716 (SELECT player FROM players WHERE nick='Spinnvill'),
1719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1722 (SELECT player FROM players WHERE nick='Spinnvill'),
1724 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1730 (SELECT player FROM players WHERE nick='Spinnvill'),
1732 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1735 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1738 (SELECT player FROM players WHERE nick='Spinnvill'),
1740 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1743 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1744 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1747 (SELECT player FROM players WHERE nick='Oliyzia'),
1750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1751 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1753 (SELECT player FROM players WHERE nick='Oliyzia'),
1755 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1761 (SELECT player FROM players WHERE nick='Oliyzia'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1769 (SELECT player FROM players WHERE nick='Oliyzia'),
1771 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1774 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1775 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1778 (SELECT player FROM players WHERE nick='Tom'),
1781 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1782 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1784 (SELECT player FROM players WHERE nick='Tom'),
1786 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1792 (SELECT player FROM players WHERE nick='Tom'),
1794 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1800 (SELECT player FROM players WHERE nick='Tom'),
1802 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1805 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1807 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1810 INSERT INTO groups (tournament, round, parallel) VALUES (
1811 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1813 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1816 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1818 UPDATE rounds SET randomsongs=1 WHERE
1819 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1821 UPDATE rounds SET chosensongs=1 WHERE
1822 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1824 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1828 (SELECT player FROM players WHERE nick='Oliyzia'),
1831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1834 (SELECT player FROM players WHERE nick='Oliyzia'),
1836 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1839 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1842 (SELECT player FROM players WHERE nick='Oliyzia'),
1844 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1847 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1848 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1851 (SELECT player FROM players WHERE nick='Haggar'),
1854 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1857 (SELECT player FROM players WHERE nick='Haggar'),
1859 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1862 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1863 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1865 (SELECT player FROM players WHERE nick='Haggar'),
1867 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1870 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1871 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1874 (SELECT player FROM players WHERE nick='Snofox'),
1877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1880 (SELECT player FROM players WHERE nick='Snofox'),
1882 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1885 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1888 (SELECT player FROM players WHERE nick='Snofox'),
1890 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1893 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1894 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1897 (SELECT player FROM players WHERE nick='RiChY'),
1900 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1901 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1903 (SELECT player FROM players WHERE nick='RiChY'),
1905 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1908 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1909 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1911 (SELECT player FROM players WHERE nick='RiChY'),
1913 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1916 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1917 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1918 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1920 (SELECT player FROM players WHERE nick='Mulefisk'),
1923 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1924 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1926 (SELECT player FROM players WHERE nick='Mulefisk'),
1928 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1931 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1932 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1934 (SELECT player FROM players WHERE nick='Mulefisk'),
1936 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1939 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1940 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1943 (SELECT player FROM players WHERE nick='DufF'),
1946 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1947 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1949 (SELECT player FROM players WHERE nick='DufF'),
1951 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1954 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1955 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1957 (SELECT player FROM players WHERE nick='DufF'),
1959 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1962 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1963 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1964 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1966 (SELECT player FROM players WHERE nick='OJK'),
1969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1970 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1972 (SELECT player FROM players WHERE nick='OJK'),
1974 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1977 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1978 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1980 (SELECT player FROM players WHERE nick='OJK'),
1982 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1985 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1986 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1989 (SELECT player FROM players WHERE nick='Snute'),
1992 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1995 (SELECT player FROM players WHERE nick='Snute'),
1997 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2003 (SELECT player FROM players WHERE nick='Snute'),
2005 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2008 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2009 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2010 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2012 (SELECT player FROM players WHERE nick='Tom'),
2015 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2016 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2018 (SELECT player FROM players WHERE nick='Tom'),
2020 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2023 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2024 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2026 (SELECT player FROM players WHERE nick='Tom'),
2028 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2031 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2033 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2036 INSERT INTO groups (tournament, round, parallel) VALUES (
2037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2039 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2040 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2042 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
2044 UPDATE rounds SET randomsongs=1 WHERE
2045 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2047 UPDATE rounds SET chosensongs=1 WHERE
2048 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2050 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2051 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2052 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2054 (SELECT player FROM players WHERE nick='DufF'),
2057 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2058 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2060 (SELECT player FROM players WHERE nick='DufF'),
2062 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2065 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2068 (SELECT player FROM players WHERE nick='DufF'),
2070 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2073 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2074 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2077 (SELECT player FROM players WHERE nick='Oliyzia'),
2080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2083 (SELECT player FROM players WHERE nick='Oliyzia'),
2085 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2088 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2089 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2091 (SELECT player FROM players WHERE nick='Oliyzia'),
2093 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2096 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2097 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2098 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2100 (SELECT player FROM players WHERE nick='OJK'),
2103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2106 (SELECT player FROM players WHERE nick='OJK'),
2108 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2111 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2114 (SELECT player FROM players WHERE nick='OJK'),
2116 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2119 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2123 (SELECT player FROM players WHERE nick='RiChY'),
2126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2129 (SELECT player FROM players WHERE nick='RiChY'),
2131 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2137 (SELECT player FROM players WHERE nick='RiChY'),
2139 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2142 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2143 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2146 (SELECT player FROM players WHERE nick='Tom'),
2149 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2150 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2152 (SELECT player FROM players WHERE nick='Tom'),
2154 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2160 (SELECT player FROM players WHERE nick='Tom'),
2162 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2165 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2166 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2167 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2169 (SELECT player FROM players WHERE nick='Snofox'),
2172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2173 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2175 (SELECT player FROM players WHERE nick='Snofox'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2180 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2181 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2183 (SELECT player FROM players WHERE nick='Snofox'),
2185 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2188 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2189 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2190 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2192 (SELECT player FROM players WHERE nick='Snute'),
2195 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2198 (SELECT player FROM players WHERE nick='Snute'),
2200 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2204 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2206 (SELECT player FROM players WHERE nick='Snute'),
2208 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2211 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2216 INSERT INTO groups (tournament, round, parallel) VALUES (
2217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2219 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2222 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2224 UPDATE rounds SET randomsongs=1 WHERE
2225 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2227 UPDATE rounds SET chosensongs=1 WHERE
2228 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2230 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2231 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2232 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2234 (SELECT player FROM players WHERE nick='Oliyzia'),
2237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2240 (SELECT player FROM players WHERE nick='Oliyzia'),
2242 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2245 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2248 (SELECT player FROM players WHERE nick='Oliyzia'),
2250 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2253 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2254 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2257 (SELECT player FROM players WHERE nick='Tom'),
2260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2263 (SELECT player FROM players WHERE nick='Tom'),
2265 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2271 (SELECT player FROM players WHERE nick='Tom'),
2273 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2276 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2277 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2280 (SELECT player FROM players WHERE nick='Snute'),
2283 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2286 (SELECT player FROM players WHERE nick='Snute'),
2288 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2291 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2294 (SELECT player FROM players WHERE nick='Snute'),
2296 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2299 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2300 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2303 (SELECT player FROM players WHERE nick='DufF'),
2306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2309 (SELECT player FROM players WHERE nick='DufF'),
2311 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2314 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2315 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2317 (SELECT player FROM players WHERE nick='DufF'),
2319 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2322 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2323 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2324 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2326 (SELECT player FROM players WHERE nick='OJK'),
2329 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2332 (SELECT player FROM players WHERE nick='OJK'),
2334 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2337 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2340 (SELECT player FROM players WHERE nick='OJK'),
2342 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2345 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2347 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2350 INSERT INTO groups (tournament, round, parallel) VALUES (
2351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2353 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2354 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2356 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
2358 UPDATE rounds SET randomsongs=1 WHERE
2359 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2361 UPDATE rounds SET chosensongs=1 WHERE
2362 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2364 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2365 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2368 (SELECT player FROM players WHERE nick='OJK'),
2371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2374 (SELECT player FROM players WHERE nick='OJK'),
2376 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2382 (SELECT player FROM players WHERE nick='OJK'),
2384 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2387 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2388 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2391 (SELECT player FROM players WHERE nick='Oliyzia'),
2394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2397 (SELECT player FROM players WHERE nick='Oliyzia'),
2399 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2405 (SELECT player FROM players WHERE nick='Oliyzia'),
2407 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2411 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2414 (SELECT player FROM players WHERE nick='DufF'),
2417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2420 (SELECT player FROM players WHERE nick='DufF'),
2422 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2425 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2428 (SELECT player FROM players WHERE nick='DufF'),
2430 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2433 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2434 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2435 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2437 (SELECT player FROM players WHERE nick='Snute'),
2440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2443 (SELECT player FROM players WHERE nick='Snute'),
2445 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2448 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2451 (SELECT player FROM players WHERE nick='Snute'),
2453 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2456 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2461 INSERT INTO groups (tournament, round, parallel) VALUES (
2462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2464 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2467 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2469 UPDATE rounds SET randomsongs=1 WHERE
2470 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2472 UPDATE rounds SET chosensongs=1 WHERE
2473 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2475 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2479 (SELECT player FROM players WHERE nick='OJK'),
2482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2485 (SELECT player FROM players WHERE nick='OJK'),
2487 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2490 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2493 (SELECT player FROM players WHERE nick='OJK'),
2495 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2498 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2499 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2502 (SELECT player FROM players WHERE nick='Snute'),
2505 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2508 (SELECT player FROM players WHERE nick='Snute'),
2510 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2513 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2514 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2516 (SELECT player FROM players WHERE nick='Snute'),
2518 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2521 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2522 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2523 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2525 (SELECT player FROM players WHERE nick='DufF'),
2528 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2531 (SELECT player FROM players WHERE nick='DufF'),
2533 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2536 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2539 (SELECT player FROM players WHERE nick='DufF'),
2541 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2544 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2549 INSERT INTO groups (tournament, round, parallel) VALUES (
2550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2552 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2553 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2555 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
2557 UPDATE rounds SET randomsongs=1 WHERE
2558 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2560 UPDATE rounds SET chosensongs=1 WHERE
2561 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2563 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2564 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2565 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2567 (SELECT player FROM players WHERE nick='DufF'),
2570 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2573 (SELECT player FROM players WHERE nick='DufF'),
2575 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2578 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2581 (SELECT player FROM players WHERE nick='DufF'),
2583 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2586 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2587 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2588 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2590 (SELECT player FROM players WHERE nick='Snute'),
2593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2594 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2596 (SELECT player FROM players WHERE nick='Snute'),
2598 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2604 (SELECT player FROM players WHERE nick='Snute'),
2606 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),