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 tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
57 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
58 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
60 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
61 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
63 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
66 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
69 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
70 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
72 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
75 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
76 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
78 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
79 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
81 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
82 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
84 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
85 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
87 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
88 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
90 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
93 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
95 28, 'Golddragon', 28);
96 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
99 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
102 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
104 31, 'Tha Dragon', 25);
105 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
108 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
111 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
114 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
119 INSERT INTO groups (tournament, round, parallel) VALUES (
120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
122 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
125 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
127 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
130 (SELECT song FROM songs WHERE lower(title)=lower('Candy'))
132 UPDATE rounds SET randomsongs=2 WHERE
133 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
135 UPDATE rounds SET chosensongs=1 WHERE
136 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
139 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
142 (SELECT player FROM players WHERE nick='Haggar'),
145 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
148 (SELECT player FROM players WHERE nick='Haggar'),
150 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
153 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
154 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
156 (SELECT player FROM players WHERE nick='Haggar'),
158 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
164 (SELECT player FROM players WHERE nick='Haggar'),
166 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
169 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
170 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
173 (SELECT player FROM players WHERE nick='Ylini'),
176 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
177 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
179 (SELECT player FROM players WHERE nick='Ylini'),
181 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
184 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
185 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
187 (SELECT player FROM players WHERE nick='Ylini'),
189 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
195 (SELECT player FROM players WHERE nick='Ylini'),
197 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
200 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
201 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
202 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
204 (SELECT player FROM players WHERE nick='Mulefisk'),
207 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
210 (SELECT player FROM players WHERE nick='Mulefisk'),
212 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
215 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
218 (SELECT player FROM players WHERE nick='Mulefisk'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
223 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
226 (SELECT player FROM players WHERE nick='Mulefisk'),
228 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
231 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
232 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
235 (SELECT player FROM players WHERE nick='Slusk'),
238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
241 (SELECT player FROM players WHERE nick='Slusk'),
243 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
249 (SELECT player FROM players WHERE nick='Slusk'),
251 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
257 (SELECT player FROM players WHERE nick='Slusk'),
259 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
262 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
263 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
266 (SELECT player FROM players WHERE nick='Tom'),
269 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
270 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
272 (SELECT player FROM players WHERE nick='Tom'),
274 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
277 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
280 (SELECT player FROM players WHERE nick='Tom'),
282 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
286 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
288 (SELECT player FROM players WHERE nick='Tom'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
293 INSERT INTO groups (tournament, round, parallel) VALUES (
294 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
296 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
299 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
301 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
306 UPDATE rounds SET randomsongs=2 WHERE
307 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
309 UPDATE rounds SET chosensongs=1 WHERE
310 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
312 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
313 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
316 (SELECT player FROM players WHERE nick='Golddragon'),
319 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
322 (SELECT player FROM players WHERE nick='Golddragon'),
324 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
327 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
330 (SELECT player FROM players WHERE nick='Golddragon'),
332 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
335 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
338 (SELECT player FROM players WHERE nick='Golddragon'),
340 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
343 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
344 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
347 (SELECT player FROM players WHERE nick='Jallaman'),
350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
353 (SELECT player FROM players WHERE nick='Jallaman'),
355 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
361 (SELECT player FROM players WHERE nick='Jallaman'),
363 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
366 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
369 (SELECT player FROM players WHERE nick='Jallaman'),
371 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
374 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
375 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
376 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
378 (SELECT player FROM players WHERE nick='OJK'),
381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
384 (SELECT player FROM players WHERE nick='OJK'),
386 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
392 (SELECT player FROM players WHERE nick='OJK'),
394 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
400 (SELECT player FROM players WHERE nick='OJK'),
402 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
405 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
406 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
409 (SELECT player FROM players WHERE nick='Matsi'),
412 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
413 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
415 (SELECT player FROM players WHERE nick='Matsi'),
417 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
420 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
421 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
423 (SELECT player FROM players WHERE nick='Matsi'),
425 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
431 (SELECT player FROM players WHERE nick='Matsi'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
436 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
437 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
440 (SELECT player FROM players WHERE nick='Snute'),
443 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
444 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
446 (SELECT player FROM players WHERE nick='Snute'),
448 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
454 (SELECT player FROM players WHERE nick='Snute'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
462 (SELECT player FROM players WHERE nick='Snute'),
464 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
467 INSERT INTO groups (tournament, round, parallel) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
470 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
473 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
475 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
478 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
480 UPDATE rounds SET randomsongs=2 WHERE
481 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
483 UPDATE rounds SET chosensongs=1 WHERE
484 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
486 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
487 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
490 (SELECT player FROM players WHERE nick='tombot'),
493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
496 (SELECT player FROM players WHERE nick='tombot'),
498 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
504 (SELECT player FROM players WHERE nick='tombot'),
506 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
512 (SELECT player FROM players WHERE nick='tombot'),
514 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
517 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
518 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
521 (SELECT player FROM players WHERE nick='Ink'),
524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
527 (SELECT player FROM players WHERE nick='Ink'),
529 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
532 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
535 (SELECT player FROM players WHERE nick='Ink'),
537 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
543 (SELECT player FROM players WHERE nick='Ink'),
545 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
548 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
549 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
552 (SELECT player FROM players WHERE nick='Stream'),
555 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
558 (SELECT player FROM players WHERE nick='Stream'),
560 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
563 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
564 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
566 (SELECT player FROM players WHERE nick='Stream'),
568 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
574 (SELECT player FROM players WHERE nick='Stream'),
576 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
579 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
580 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
583 (SELECT player FROM players WHERE nick='Spinnvill'),
586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
587 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
589 (SELECT player FROM players WHERE nick='Spinnvill'),
591 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
597 (SELECT player FROM players WHERE nick='Spinnvill'),
599 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
605 (SELECT player FROM players WHERE nick='Spinnvill'),
607 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
610 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
611 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
612 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
614 (SELECT player FROM players WHERE nick='Telc'),
617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
618 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
620 (SELECT player FROM players WHERE nick='Telc'),
622 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
625 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
626 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
628 (SELECT player FROM players WHERE nick='Telc'),
630 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
633 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
636 (SELECT player FROM players WHERE nick='Telc'),
638 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
641 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
642 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
643 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
645 (SELECT player FROM players WHERE nick='DufF'),
648 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
649 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
651 (SELECT player FROM players WHERE nick='DufF'),
653 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
656 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
659 (SELECT player FROM players WHERE nick='DufF'),
661 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
665 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
667 (SELECT player FROM players WHERE nick='DufF'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
672 INSERT INTO groups (tournament, round, parallel) VALUES (
673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
675 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
678 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
680 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
685 UPDATE rounds SET randomsongs=2 WHERE
686 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
688 UPDATE rounds SET chosensongs=1 WHERE
689 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
691 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
692 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
695 (SELECT player FROM players WHERE nick='Duckling'),
698 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
701 (SELECT player FROM players WHERE nick='Duckling'),
703 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
709 (SELECT player FROM players WHERE nick='Duckling'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
717 (SELECT player FROM players WHERE nick='Duckling'),
719 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
722 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
723 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
726 (SELECT player FROM players WHERE nick='Auran'),
729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
732 (SELECT player FROM players WHERE nick='Auran'),
734 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
740 (SELECT player FROM players WHERE nick='Auran'),
742 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
748 (SELECT player FROM players WHERE nick='Auran'),
750 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
753 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
754 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
757 (SELECT player FROM players WHERE nick='Advena'),
760 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
761 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
763 (SELECT player FROM players WHERE nick='Advena'),
765 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
768 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
769 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
771 (SELECT player FROM players WHERE nick='Advena'),
773 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
776 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
779 (SELECT player FROM players WHERE nick='Advena'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
788 (SELECT player FROM players WHERE nick='Snofox'),
791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
794 (SELECT player FROM players WHERE nick='Snofox'),
796 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
799 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
802 (SELECT player FROM players WHERE nick='Snofox'),
804 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
807 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
810 (SELECT player FROM players WHERE nick='Snofox'),
812 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
815 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
816 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
817 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
819 (SELECT player FROM players WHERE nick='Smiph'),
822 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
823 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
825 (SELECT player FROM players WHERE nick='Smiph'),
827 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
830 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
833 (SELECT player FROM players WHERE nick='Smiph'),
835 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
841 (SELECT player FROM players WHERE nick='Smiph'),
843 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
846 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
847 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
850 (SELECT player FROM players WHERE nick='Oliyzia'),
853 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
856 (SELECT player FROM players WHERE nick='Oliyzia'),
858 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
861 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
864 (SELECT player FROM players WHERE nick='Oliyzia'),
866 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
872 (SELECT player FROM players WHERE nick='Oliyzia'),
874 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
877 INSERT INTO groups (tournament, round, parallel) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
880 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
881 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
883 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
885 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
888 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
890 UPDATE rounds SET randomsongs=2 WHERE
891 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
893 UPDATE rounds SET chosensongs=1 WHERE
894 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
896 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
900 (SELECT player FROM players WHERE nick='x3mnrj'),
903 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
904 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
906 (SELECT player FROM players WHERE nick='x3mnrj'),
908 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
911 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
914 (SELECT player FROM players WHERE nick='x3mnrj'),
916 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
919 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
922 (SELECT player FROM players WHERE nick='x3mnrj'),
924 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
927 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
928 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
931 (SELECT player FROM players WHERE nick='Octu'),
934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
937 (SELECT player FROM players WHERE nick='Octu'),
939 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
942 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
945 (SELECT player FROM players WHERE nick='Octu'),
947 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
953 (SELECT player FROM players WHERE nick='Octu'),
955 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
958 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
959 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
962 (SELECT player FROM players WHERE nick='Electus'),
965 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
968 (SELECT player FROM players WHERE nick='Electus'),
970 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
973 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
976 (SELECT player FROM players WHERE nick='Electus'),
978 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
981 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
984 (SELECT player FROM players WHERE nick='Electus'),
986 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
989 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
990 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
991 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
993 (SELECT player FROM players WHERE nick='Purity'),
996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
999 (SELECT player FROM players WHERE nick='Purity'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1007 (SELECT player FROM players WHERE nick='Purity'),
1009 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1012 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1015 (SELECT player FROM players WHERE nick='Purity'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1020 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
1021 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1022 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1024 (SELECT player FROM players WHERE nick='Havok'),
1027 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1028 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1030 (SELECT player FROM players WHERE nick='Havok'),
1032 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1035 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1036 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1038 (SELECT player FROM players WHERE nick='Havok'),
1040 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1043 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1044 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1046 (SELECT player FROM players WHERE nick='Havok'),
1048 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1051 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
1052 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1053 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1055 (SELECT player FROM players WHERE nick='Draconia'),
1058 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1059 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1061 (SELECT player FROM players WHERE nick='Draconia'),
1063 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1066 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1069 (SELECT player FROM players WHERE nick='Draconia'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1074 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1077 (SELECT player FROM players WHERE nick='Draconia'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1082 INSERT INTO groups (tournament, round, parallel) VALUES (
1083 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1085 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1088 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1090 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1091 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1093 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1095 UPDATE rounds SET randomsongs=2 WHERE
1096 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1098 UPDATE rounds SET chosensongs=1 WHERE
1099 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1101 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
1102 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1105 (SELECT player FROM players WHERE nick='Dexter'),
1108 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1111 (SELECT player FROM players WHERE nick='Dexter'),
1113 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1116 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1119 (SELECT player FROM players WHERE nick='Dexter'),
1121 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1124 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1125 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1127 (SELECT player FROM players WHERE nick='Dexter'),
1129 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1133 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1136 (SELECT player FROM players WHERE nick='Olemann'),
1139 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1142 (SELECT player FROM players WHERE nick='Olemann'),
1144 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1147 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1150 (SELECT player FROM players WHERE nick='Olemann'),
1152 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1155 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1158 (SELECT player FROM players WHERE nick='Olemann'),
1160 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1163 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
1164 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1167 (SELECT player FROM players WHERE nick='Tha Dragon'),
1170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1173 (SELECT player FROM players WHERE nick='Tha Dragon'),
1175 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1181 (SELECT player FROM players WHERE nick='Tha Dragon'),
1183 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1189 (SELECT player FROM players WHERE nick='Tha Dragon'),
1191 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1194 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1195 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1198 (SELECT player FROM players WHERE nick='T|na'),
1201 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1202 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1204 (SELECT player FROM players WHERE nick='T|na'),
1206 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1209 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1212 (SELECT player FROM players WHERE nick='T|na'),
1214 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1220 (SELECT player FROM players WHERE nick='T|na'),
1222 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1225 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1226 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1227 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1229 (SELECT player FROM players WHERE nick='RiChY'),
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='RiChY'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1243 (SELECT player FROM players WHERE nick='RiChY'),
1245 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1251 (SELECT player FROM players WHERE nick='RiChY'),
1253 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1256 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1257 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1260 (SELECT player FROM players WHERE nick='Daniil'),
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('Memories')),
1271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1274 (SELECT player FROM players WHERE nick='Daniil'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1282 (SELECT player FROM players WHERE nick='Daniil'),
1284 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1287 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1292 INSERT INTO groups (tournament, round, parallel) VALUES (
1293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1295 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1300 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1303 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1305 UPDATE rounds SET randomsongs=2 WHERE
1306 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1308 UPDATE rounds SET chosensongs=1 WHERE
1309 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1311 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1315 (SELECT player FROM players WHERE nick='Smiph'),
1318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1321 (SELECT player FROM players WHERE nick='Smiph'),
1323 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1329 (SELECT player FROM players WHERE nick='Smiph'),
1331 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1337 (SELECT player FROM players WHERE nick='Smiph'),
1339 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1342 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1343 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1346 (SELECT player FROM players WHERE nick='Daniil'),
1349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1352 (SELECT player FROM players WHERE nick='Daniil'),
1354 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1360 (SELECT player FROM players WHERE nick='Daniil'),
1362 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1365 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1368 (SELECT player FROM players WHERE nick='Daniil'),
1370 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1373 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1374 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1377 (SELECT player FROM players WHERE nick='Snofox'),
1380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1383 (SELECT player FROM players WHERE nick='Snofox'),
1385 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1391 (SELECT player FROM players WHERE nick='Snofox'),
1393 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1396 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1399 (SELECT player FROM players WHERE nick='Snofox'),
1401 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1404 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1405 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1408 (SELECT player FROM players WHERE nick='Snute'),
1411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1414 (SELECT player FROM players WHERE nick='Snute'),
1416 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1422 (SELECT player FROM players WHERE nick='Snute'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1427 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1430 (SELECT player FROM players WHERE nick='Snute'),
1432 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1435 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
1436 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1439 (SELECT player FROM players WHERE nick='Purity'),
1442 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1443 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1445 (SELECT player FROM players WHERE nick='Purity'),
1447 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1450 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1451 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1453 (SELECT player FROM players WHERE nick='Purity'),
1455 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1458 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1459 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1461 (SELECT player FROM players WHERE nick='Purity'),
1463 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1470 (SELECT player FROM players WHERE nick='DufF'),
1473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1474 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1476 (SELECT player FROM players WHERE nick='DufF'),
1478 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1484 (SELECT player FROM players WHERE nick='DufF'),
1486 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1492 (SELECT player FROM players WHERE nick='DufF'),
1494 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1497 INSERT INTO groups (tournament, round, parallel) VALUES (
1498 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1500 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1503 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
1505 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1510 UPDATE rounds SET randomsongs=2 WHERE
1511 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1513 UPDATE rounds SET chosensongs=1 WHERE
1514 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1516 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
1517 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1520 (SELECT player FROM players WHERE nick='Havok'),
1523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1526 (SELECT player FROM players WHERE nick='Havok'),
1528 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1534 (SELECT player FROM players WHERE nick='Havok'),
1536 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1542 (SELECT player FROM players WHERE nick='Havok'),
1544 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1547 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
1548 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1551 (SELECT player FROM players WHERE nick='Jallaman'),
1554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1557 (SELECT player FROM players WHERE nick='Jallaman'),
1559 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1565 (SELECT player FROM players WHERE nick='Jallaman'),
1567 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1570 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1573 (SELECT player FROM players WHERE nick='Jallaman'),
1575 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1578 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1579 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1582 (SELECT player FROM players WHERE nick='Haggar'),
1585 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1586 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1588 (SELECT player FROM players WHERE nick='Haggar'),
1590 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1594 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1596 (SELECT player FROM players WHERE nick='Haggar'),
1598 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1604 (SELECT player FROM players WHERE nick='Haggar'),
1606 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1609 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1610 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1613 (SELECT player FROM players WHERE nick='T|na'),
1616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1619 (SELECT player FROM players WHERE nick='T|na'),
1621 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1627 (SELECT player FROM players WHERE nick='T|na'),
1629 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1632 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1635 (SELECT player FROM players WHERE nick='T|na'),
1637 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1640 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1641 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1644 (SELECT player FROM players WHERE nick='OJK'),
1647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1650 (SELECT player FROM players WHERE nick='OJK'),
1652 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1655 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1658 (SELECT player FROM players WHERE nick='OJK'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1663 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1666 (SELECT player FROM players WHERE nick='OJK'),
1668 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1671 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1672 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1675 (SELECT player FROM players WHERE nick='RiChY'),
1678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1681 (SELECT player FROM players WHERE nick='RiChY'),
1683 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1686 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1689 (SELECT player FROM players WHERE nick='RiChY'),
1691 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1694 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1697 (SELECT player FROM players WHERE nick='RiChY'),
1699 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1702 INSERT INTO groups (tournament, round, parallel) VALUES (
1703 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1705 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1708 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1710 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1711 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1713 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1715 UPDATE rounds SET randomsongs=2 WHERE
1716 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1718 UPDATE rounds SET chosensongs=1 WHERE
1719 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1725 (SELECT player FROM players WHERE nick='Mulefisk'),
1728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1731 (SELECT player FROM players WHERE nick='Mulefisk'),
1733 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1739 (SELECT player FROM players WHERE nick='Mulefisk'),
1741 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1744 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1747 (SELECT player FROM players WHERE nick='Mulefisk'),
1749 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1752 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1756 (SELECT player FROM players WHERE nick='Stream'),
1759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1762 (SELECT player FROM players WHERE nick='Stream'),
1764 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1770 (SELECT player FROM players WHERE nick='Stream'),
1772 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1778 (SELECT player FROM players WHERE nick='Stream'),
1780 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1783 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
1784 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1785 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1787 (SELECT player FROM players WHERE nick='Electus'),
1790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1793 (SELECT player FROM players WHERE nick='Electus'),
1795 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1799 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1801 (SELECT player FROM players WHERE nick='Electus'),
1803 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1806 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1807 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1809 (SELECT player FROM players WHERE nick='Electus'),
1811 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1814 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
1815 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1818 (SELECT player FROM players WHERE nick='Spinnvill'),
1821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1824 (SELECT player FROM players WHERE nick='Spinnvill'),
1826 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1829 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1832 (SELECT player FROM players WHERE nick='Spinnvill'),
1834 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1837 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1840 (SELECT player FROM players WHERE nick='Spinnvill'),
1842 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1845 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1846 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1849 (SELECT player FROM players WHERE nick='Oliyzia'),
1852 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1853 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1855 (SELECT player FROM players WHERE nick='Oliyzia'),
1857 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1863 (SELECT player FROM players WHERE nick='Oliyzia'),
1865 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1871 (SELECT player FROM players WHERE nick='Oliyzia'),
1873 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1876 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1877 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1880 (SELECT player FROM players WHERE nick='Tom'),
1883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1886 (SELECT player FROM players WHERE nick='Tom'),
1888 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1894 (SELECT player FROM players WHERE nick='Tom'),
1896 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1899 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1902 (SELECT player FROM players WHERE nick='Tom'),
1904 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1907 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1909 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1912 INSERT INTO groups (tournament, round, parallel) VALUES (
1913 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1915 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1916 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1920 UPDATE rounds SET randomsongs=1 WHERE
1921 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1923 UPDATE rounds SET chosensongs=1 WHERE
1924 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1926 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1927 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1930 (SELECT player FROM players WHERE nick='Oliyzia'),
1933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1936 (SELECT player FROM players WHERE nick='Oliyzia'),
1938 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1944 (SELECT player FROM players WHERE nick='Oliyzia'),
1946 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1949 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1953 (SELECT player FROM players WHERE nick='Haggar'),
1956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1959 (SELECT player FROM players WHERE nick='Haggar'),
1961 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1967 (SELECT player FROM players WHERE nick='Haggar'),
1969 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1972 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1973 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1976 (SELECT player FROM players WHERE nick='Snofox'),
1979 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1980 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1982 (SELECT player FROM players WHERE nick='Snofox'),
1984 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1990 (SELECT player FROM players WHERE nick='Snofox'),
1992 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1995 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1996 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1999 (SELECT player FROM players WHERE nick='RiChY'),
2002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2003 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2005 (SELECT player FROM players WHERE nick='RiChY'),
2007 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2010 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2013 (SELECT player FROM players WHERE nick='RiChY'),
2015 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2018 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
2019 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2020 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2022 (SELECT player FROM players WHERE nick='Mulefisk'),
2025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2028 (SELECT player FROM players WHERE nick='Mulefisk'),
2030 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2036 (SELECT player FROM players WHERE nick='Mulefisk'),
2038 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2041 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2045 (SELECT player FROM players WHERE nick='DufF'),
2048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2051 (SELECT player FROM players WHERE nick='DufF'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2059 (SELECT player FROM players WHERE nick='DufF'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2064 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2065 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2066 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2068 (SELECT player FROM players WHERE nick='OJK'),
2071 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2072 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2074 (SELECT player FROM players WHERE nick='OJK'),
2076 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2079 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2080 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2082 (SELECT player FROM players WHERE nick='OJK'),
2084 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2087 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2088 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2089 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2091 (SELECT player FROM players WHERE nick='Snute'),
2094 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2095 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2097 (SELECT player FROM players WHERE nick='Snute'),
2099 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2105 (SELECT player FROM players WHERE nick='Snute'),
2107 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2110 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2111 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2114 (SELECT player FROM players WHERE nick='Tom'),
2117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2120 (SELECT player FROM players WHERE nick='Tom'),
2122 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2128 (SELECT player FROM players WHERE nick='Tom'),
2130 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2133 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2138 INSERT INTO groups (tournament, round, parallel) VALUES (
2139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2141 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2142 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2144 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
2146 UPDATE rounds SET randomsongs=1 WHERE
2147 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2149 UPDATE rounds SET chosensongs=1 WHERE
2150 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2152 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2153 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2154 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2156 (SELECT player FROM players WHERE nick='DufF'),
2159 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2160 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2162 (SELECT player FROM players WHERE nick='DufF'),
2164 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2170 (SELECT player FROM players WHERE nick='DufF'),
2172 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2175 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2176 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2177 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2179 (SELECT player FROM players WHERE nick='Oliyzia'),
2182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2185 (SELECT player FROM players WHERE nick='Oliyzia'),
2187 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2193 (SELECT player FROM players WHERE nick='Oliyzia'),
2195 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2199 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2202 (SELECT player FROM players WHERE nick='OJK'),
2205 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2208 (SELECT player FROM players WHERE nick='OJK'),
2210 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2213 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2216 (SELECT player FROM players WHERE nick='OJK'),
2218 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2221 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2222 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2225 (SELECT player FROM players WHERE nick='RiChY'),
2228 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2231 (SELECT player FROM players WHERE nick='RiChY'),
2233 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2236 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2239 (SELECT player FROM players WHERE nick='RiChY'),
2241 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2245 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2248 (SELECT player FROM players WHERE nick='Tom'),
2251 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2252 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2254 (SELECT player FROM players WHERE nick='Tom'),
2256 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2259 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2262 (SELECT player FROM players WHERE nick='Tom'),
2264 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2267 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2268 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2271 (SELECT player FROM players WHERE nick='Snofox'),
2274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2275 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2277 (SELECT player FROM players WHERE nick='Snofox'),
2279 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2285 (SELECT player FROM players WHERE nick='Snofox'),
2287 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2290 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2291 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2294 (SELECT player FROM players WHERE nick='Snute'),
2297 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2298 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2300 (SELECT player FROM players WHERE nick='Snute'),
2302 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2305 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2306 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2308 (SELECT player FROM players WHERE nick='Snute'),
2310 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2313 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2315 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2318 INSERT INTO groups (tournament, round, parallel) VALUES (
2319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2321 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2324 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2326 UPDATE rounds SET randomsongs=1 WHERE
2327 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2329 UPDATE rounds SET chosensongs=1 WHERE
2330 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2332 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2333 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2336 (SELECT player FROM players WHERE nick='Oliyzia'),
2339 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2342 (SELECT player FROM players WHERE nick='Oliyzia'),
2344 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2350 (SELECT player FROM players WHERE nick='Oliyzia'),
2352 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2355 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2356 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2359 (SELECT player FROM players WHERE nick='Tom'),
2362 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2363 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2365 (SELECT player FROM players WHERE nick='Tom'),
2367 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2371 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2373 (SELECT player FROM players WHERE nick='Tom'),
2375 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2378 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2382 (SELECT player FROM players WHERE nick='Snute'),
2385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2388 (SELECT player FROM players WHERE nick='Snute'),
2390 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2396 (SELECT player FROM players WHERE nick='Snute'),
2398 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2401 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2402 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2405 (SELECT player FROM players WHERE nick='DufF'),
2408 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2409 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2411 (SELECT player FROM players WHERE nick='DufF'),
2413 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2416 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2419 (SELECT player FROM players WHERE nick='DufF'),
2421 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2424 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2425 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2428 (SELECT player FROM players WHERE nick='OJK'),
2431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2434 (SELECT player FROM players WHERE nick='OJK'),
2436 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2439 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2442 (SELECT player FROM players WHERE nick='OJK'),
2444 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2447 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2452 INSERT INTO groups (tournament, round, parallel) VALUES (
2453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2455 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2458 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
2460 UPDATE rounds SET randomsongs=1 WHERE
2461 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2463 UPDATE rounds SET chosensongs=1 WHERE
2464 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2470 (SELECT player FROM players WHERE nick='OJK'),
2473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2474 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2476 (SELECT player FROM players WHERE nick='OJK'),
2478 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2484 (SELECT player FROM players WHERE nick='OJK'),
2486 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2489 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2490 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2493 (SELECT player FROM players WHERE nick='Oliyzia'),
2496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2499 (SELECT player FROM players WHERE nick='Oliyzia'),
2501 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2504 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2507 (SELECT player FROM players WHERE nick='Oliyzia'),
2509 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2512 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2513 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2514 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2516 (SELECT player FROM players WHERE nick='DufF'),
2519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2522 (SELECT player FROM players WHERE nick='DufF'),
2524 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2528 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2530 (SELECT player FROM players WHERE nick='DufF'),
2532 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2535 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2536 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2539 (SELECT player FROM players WHERE nick='Snute'),
2542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2545 (SELECT player FROM players WHERE nick='Snute'),
2547 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2550 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2553 (SELECT player FROM players WHERE nick='Snute'),
2555 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2558 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2563 INSERT INTO groups (tournament, round, parallel) VALUES (
2564 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2566 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2569 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2571 UPDATE rounds SET randomsongs=1 WHERE
2572 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2574 UPDATE rounds SET chosensongs=1 WHERE
2575 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2577 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2581 (SELECT player FROM players WHERE nick='OJK'),
2584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2587 (SELECT player FROM players WHERE nick='OJK'),
2589 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2595 (SELECT player FROM players WHERE nick='OJK'),
2597 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2600 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2601 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2604 (SELECT player FROM players WHERE nick='Snute'),
2607 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2608 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2610 (SELECT player FROM players WHERE nick='Snute'),
2612 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2615 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2618 (SELECT player FROM players WHERE nick='Snute'),
2620 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2623 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2624 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2627 (SELECT player FROM players WHERE nick='DufF'),
2630 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2633 (SELECT player FROM players WHERE nick='DufF'),
2635 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2641 (SELECT player FROM players WHERE nick='DufF'),
2643 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2646 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2651 INSERT INTO groups (tournament, round, parallel) VALUES (
2652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2654 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2657 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
2659 UPDATE rounds SET randomsongs=1 WHERE
2660 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2662 UPDATE rounds SET chosensongs=1 WHERE
2663 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2665 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2666 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2669 (SELECT player FROM players WHERE nick='DufF'),
2672 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2675 (SELECT player FROM players WHERE nick='DufF'),
2677 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2683 (SELECT player FROM players WHERE nick='DufF'),
2685 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2688 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2689 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2692 (SELECT player FROM players WHERE nick='Snute'),
2695 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2698 (SELECT player FROM players WHERE nick='Snute'),
2700 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2703 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2706 (SELECT player FROM players WHERE nick='Snute'),
2708 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),