2 INSERT INTO tournaments
3 (season, name, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
5 'Challenge Cup 1 - 2004',
6 (SELECT country FROM countries WHERE name='Norway'),
9 (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Candy'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
40 (SELECT player FROM players WHERE nick='Haggar'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
46 (SELECT player FROM players WHERE nick='Haggar'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
53 (SELECT player FROM players WHERE nick='Haggar'),
54 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
57 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
58 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
59 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
61 (SELECT player FROM players WHERE nick='Ylini'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
67 (SELECT player FROM players WHERE nick='Ylini'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
74 (SELECT player FROM players WHERE nick='Ylini'),
75 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
79 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
80 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
82 (SELECT player FROM players WHERE nick='Mulefisk'),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
88 (SELECT player FROM players WHERE nick='Mulefisk'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
92 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
95 (SELECT player FROM players WHERE nick='Mulefisk'),
96 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
100 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
103 (SELECT player FROM players WHERE nick='Slusk'),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
109 (SELECT player FROM players WHERE nick='Slusk'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
116 (SELECT player FROM players WHERE nick='Slusk'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
124 (SELECT player FROM players WHERE nick='Tom'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
130 (SELECT player FROM players WHERE nick='Tom'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
137 (SELECT player FROM players WHERE nick='Tom'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
141 INSERT INTO groups (tournament, round, parallel) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
144 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
145 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
147 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
149 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
154 UPDATE rounds SET randomsongs=2 WHERE
155 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
157 UPDATE rounds SET chosensongs=1 WHERE
158 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
164 (SELECT player FROM players WHERE nick='Golddragon'),
167 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
170 (SELECT player FROM players WHERE nick='Golddragon'),
171 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
177 (SELECT player FROM players WHERE nick='Golddragon'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
185 (SELECT player FROM players WHERE nick='Jallaman'),
188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
191 (SELECT player FROM players WHERE nick='Jallaman'),
192 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
195 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
198 (SELECT player FROM players WHERE nick='Jallaman'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
203 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
204 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
206 (SELECT player FROM players WHERE nick='OJK'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
212 (SELECT player FROM players WHERE nick='OJK'),
213 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
219 (SELECT player FROM players WHERE nick='OJK'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
227 (SELECT player FROM players WHERE nick='Matsi'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
233 (SELECT player FROM players WHERE nick='Matsi'),
234 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
240 (SELECT player FROM players WHERE nick='Matsi'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
245 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
246 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
248 (SELECT player FROM players WHERE nick='Snute'),
251 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
254 (SELECT player FROM players WHERE nick='Snute'),
255 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
261 (SELECT player FROM players WHERE nick='Snute'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
265 INSERT INTO groups (tournament, round, parallel) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
268 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
269 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
271 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
278 UPDATE rounds SET randomsongs=2 WHERE
279 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
281 UPDATE rounds SET chosensongs=1 WHERE
282 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
284 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
285 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
286 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
288 (SELECT player FROM players WHERE nick='tombot'),
291 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
292 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
294 (SELECT player FROM players WHERE nick='tombot'),
295 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
298 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
301 (SELECT player FROM players WHERE nick='tombot'),
302 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
305 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
309 (SELECT player FROM players WHERE nick='Ink'),
312 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
315 (SELECT player FROM players WHERE nick='Ink'),
316 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
319 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
322 (SELECT player FROM players WHERE nick='Ink'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
327 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
328 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
330 (SELECT player FROM players WHERE nick='Stream'),
333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
336 (SELECT player FROM players WHERE nick='Stream'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
343 (SELECT player FROM players WHERE nick='Stream'),
344 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
347 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
348 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
351 (SELECT player FROM players WHERE nick='Spinnvill'),
354 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
357 (SELECT player FROM players WHERE nick='Spinnvill'),
358 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
364 (SELECT player FROM players WHERE nick='Spinnvill'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
368 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
369 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
370 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
372 (SELECT player FROM players WHERE nick='Telc'),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
378 (SELECT player FROM players WHERE nick='Telc'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
385 (SELECT player FROM players WHERE nick='Telc'),
386 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
389 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
390 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
393 (SELECT player FROM players WHERE nick='DufF'),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
399 (SELECT player FROM players WHERE nick='DufF'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
406 (SELECT player FROM players WHERE nick='DufF'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
410 INSERT INTO groups (tournament, round, parallel) VALUES (
411 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
413 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
414 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
416 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
418 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
419 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
421 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
423 UPDATE rounds SET randomsongs=2 WHERE
424 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
426 UPDATE rounds SET chosensongs=1 WHERE
427 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
429 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
430 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
431 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
433 (SELECT player FROM players WHERE nick='Duckling'),
436 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
439 (SELECT player FROM players WHERE nick='Duckling'),
440 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
443 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
444 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
446 (SELECT player FROM players WHERE nick='Duckling'),
447 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
450 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
451 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
454 (SELECT player FROM players WHERE nick='Auran'),
457 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
458 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
460 (SELECT player FROM players WHERE nick='Auran'),
461 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
464 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
467 (SELECT player FROM players WHERE nick='Auran'),
468 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
471 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
472 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
473 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
475 (SELECT player FROM players WHERE nick='Advena'),
478 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
481 (SELECT player FROM players WHERE nick='Advena'),
482 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
485 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
488 (SELECT player FROM players WHERE nick='Advena'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
492 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
494 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
496 (SELECT player FROM players WHERE nick='Snofox'),
499 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
502 (SELECT player FROM players WHERE nick='Snofox'),
503 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
506 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
509 (SELECT player FROM players WHERE nick='Snofox'),
510 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
514 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
517 (SELECT player FROM players WHERE nick='Smiph'),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
523 (SELECT player FROM players WHERE nick='Smiph'),
524 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
530 (SELECT player FROM players WHERE nick='Smiph'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
538 (SELECT player FROM players WHERE nick='Oliyzia'),
541 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
544 (SELECT player FROM players WHERE nick='Oliyzia'),
545 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
551 (SELECT player FROM players WHERE nick='Oliyzia'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
555 INSERT INTO groups (tournament, round, parallel) VALUES (
556 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
558 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
559 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
561 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
563 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
564 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
566 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
568 UPDATE rounds SET randomsongs=2 WHERE
569 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
571 UPDATE rounds SET chosensongs=1 WHERE
572 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
574 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
575 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
576 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
578 (SELECT player FROM players WHERE nick='x3mnrj'),
581 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
584 (SELECT player FROM players WHERE nick='x3mnrj'),
585 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
588 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
591 (SELECT player FROM players WHERE nick='x3mnrj'),
592 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
595 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
597 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
599 (SELECT player FROM players WHERE nick='Octu'),
602 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
605 (SELECT player FROM players WHERE nick='Octu'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
609 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
612 (SELECT player FROM players WHERE nick='Octu'),
613 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
616 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
617 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
618 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
620 (SELECT player FROM players WHERE nick='Electus'),
623 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
626 (SELECT player FROM players WHERE nick='Electus'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
630 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
633 (SELECT player FROM players WHERE nick='Electus'),
634 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
637 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
641 (SELECT player FROM players WHERE nick='Purity'),
644 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
647 (SELECT player FROM players WHERE nick='Purity'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
651 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
652 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
654 (SELECT player FROM players WHERE nick='Purity'),
655 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
658 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
659 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
660 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
662 (SELECT player FROM players WHERE nick='Havok'),
665 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
668 (SELECT player FROM players WHERE nick='Havok'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
672 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
673 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
675 (SELECT player FROM players WHERE nick='Havok'),
676 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
679 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
680 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
681 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
683 (SELECT player FROM players WHERE nick='Draconia'),
686 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
689 (SELECT player FROM players WHERE nick='Draconia'),
690 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
693 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
694 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
696 (SELECT player FROM players WHERE nick='Draconia'),
697 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
700 INSERT INTO groups (tournament, round, parallel) VALUES (
701 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
703 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
704 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
706 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
708 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
709 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
711 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
713 UPDATE rounds SET randomsongs=2 WHERE
714 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
716 UPDATE rounds SET chosensongs=1 WHERE
717 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
719 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
720 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
721 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
723 (SELECT player FROM players WHERE nick='Dexter'),
726 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
729 (SELECT player FROM players WHERE nick='Dexter'),
730 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
733 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
736 (SELECT player FROM players WHERE nick='Dexter'),
737 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
740 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
741 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
742 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
744 (SELECT player FROM players WHERE nick='Olemann'),
747 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
750 (SELECT player FROM players WHERE nick='Olemann'),
751 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
754 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
757 (SELECT player FROM players WHERE nick='Olemann'),
758 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
761 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
762 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
763 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
765 (SELECT player FROM players WHERE nick='Tha Dragon'),
768 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
771 (SELECT player FROM players WHERE nick='Tha Dragon'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
775 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
778 (SELECT player FROM players WHERE nick='Tha Dragon'),
779 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
782 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
784 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
786 (SELECT player FROM players WHERE nick='T|na'),
789 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
792 (SELECT player FROM players WHERE nick='T|na'),
793 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
796 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
799 (SELECT player FROM players WHERE nick='T|na'),
800 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
803 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
804 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
805 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
807 (SELECT player FROM players WHERE nick='RiChY'),
810 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
811 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
813 (SELECT player FROM players WHERE nick='RiChY'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
817 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
820 (SELECT player FROM players WHERE nick='RiChY'),
821 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
824 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
828 (SELECT player FROM players WHERE nick='Daniil'),
831 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
834 (SELECT player FROM players WHERE nick='Daniil'),
835 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
838 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
841 (SELECT player FROM players WHERE nick='Daniil'),
842 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
845 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
847 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
850 INSERT INTO groups (tournament, round, parallel) VALUES (
851 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
853 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
854 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
856 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
858 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
859 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
861 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
863 UPDATE rounds SET randomsongs=2 WHERE
864 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
866 UPDATE rounds SET chosensongs=1 WHERE
867 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
869 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
870 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
871 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
873 (SELECT player FROM players WHERE nick='Smiph'),
876 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
879 (SELECT player FROM players WHERE nick='Smiph'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
883 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
886 (SELECT player FROM players WHERE nick='Smiph'),
887 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
890 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
892 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
894 (SELECT player FROM players WHERE nick='Daniil'),
897 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
900 (SELECT player FROM players WHERE nick='Daniil'),
901 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
904 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
907 (SELECT player FROM players WHERE nick='Daniil'),
908 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
911 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
912 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
913 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
915 (SELECT player FROM players WHERE nick='Snofox'),
918 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
921 (SELECT player FROM players WHERE nick='Snofox'),
922 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
925 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
928 (SELECT player FROM players WHERE nick='Snofox'),
929 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
932 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
934 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
936 (SELECT player FROM players WHERE nick='Snute'),
939 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
940 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
942 (SELECT player FROM players WHERE nick='Snute'),
943 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
946 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
949 (SELECT player FROM players WHERE nick='Snute'),
950 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
953 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
954 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
955 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
957 (SELECT player FROM players WHERE nick='Purity'),
960 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
961 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
963 (SELECT player FROM players WHERE nick='Purity'),
964 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
967 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
968 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
970 (SELECT player FROM players WHERE nick='Purity'),
971 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
974 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
975 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
976 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
978 (SELECT player FROM players WHERE nick='DufF'),
981 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
982 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
984 (SELECT player FROM players WHERE nick='DufF'),
985 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
988 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
989 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
991 (SELECT player FROM players WHERE nick='DufF'),
992 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
995 INSERT INTO groups (tournament, round, parallel) VALUES (
996 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
998 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
999 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
1003 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1004 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1006 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1008 UPDATE rounds SET randomsongs=2 WHERE
1009 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1011 UPDATE rounds SET chosensongs=1 WHERE
1012 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1014 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
1015 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1016 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1018 (SELECT player FROM players WHERE nick='Havok'),
1021 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1022 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1024 (SELECT player FROM players WHERE nick='Havok'),
1025 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1028 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1031 (SELECT player FROM players WHERE nick='Havok'),
1032 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1035 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1039 (SELECT player FROM players WHERE nick='Jallaman'),
1042 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1045 (SELECT player FROM players WHERE nick='Jallaman'),
1046 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1049 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1052 (SELECT player FROM players WHERE nick='Jallaman'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1057 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1058 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1060 (SELECT player FROM players WHERE nick='Haggar'),
1063 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1064 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1066 (SELECT player FROM players WHERE nick='Haggar'),
1067 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1070 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1071 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1073 (SELECT player FROM players WHERE nick='Haggar'),
1074 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1077 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1078 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1079 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1081 (SELECT player FROM players WHERE nick='T|na'),
1084 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1087 (SELECT player FROM players WHERE nick='T|na'),
1088 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1091 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1092 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1094 (SELECT player FROM players WHERE nick='T|na'),
1095 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1098 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1102 (SELECT player FROM players WHERE nick='OJK'),
1105 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1108 (SELECT player FROM players WHERE nick='OJK'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1112 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1115 (SELECT player FROM players WHERE nick='OJK'),
1116 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1119 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1123 (SELECT player FROM players WHERE nick='RiChY'),
1126 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1129 (SELECT player FROM players WHERE nick='RiChY'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1133 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1134 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1136 (SELECT player FROM players WHERE nick='RiChY'),
1137 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1140 INSERT INTO groups (tournament, round, parallel) VALUES (
1141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1143 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1144 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1148 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1149 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1153 UPDATE rounds SET randomsongs=2 WHERE
1154 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1156 UPDATE rounds SET chosensongs=1 WHERE
1157 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1159 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1160 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1161 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1163 (SELECT player FROM players WHERE nick='Mulefisk'),
1166 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1167 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1169 (SELECT player FROM players WHERE nick='Mulefisk'),
1170 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1173 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1174 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1176 (SELECT player FROM players WHERE nick='Mulefisk'),
1177 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1184 (SELECT player FROM players WHERE nick='Stream'),
1187 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1188 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1190 (SELECT player FROM players WHERE nick='Stream'),
1191 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1194 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1195 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1197 (SELECT player FROM players WHERE nick='Stream'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1201 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
1202 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1205 (SELECT player FROM players WHERE nick='Electus'),
1208 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1211 (SELECT player FROM players WHERE nick='Electus'),
1212 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1215 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1216 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1218 (SELECT player FROM players WHERE nick='Electus'),
1219 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
1223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1224 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1226 (SELECT player FROM players WHERE nick='Spinnvill'),
1229 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1230 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1232 (SELECT player FROM players WHERE nick='Spinnvill'),
1233 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1236 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1237 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1239 (SELECT player FROM players WHERE nick='Spinnvill'),
1240 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1243 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1247 (SELECT player FROM players WHERE nick='Oliyzia'),
1250 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1251 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1253 (SELECT player FROM players WHERE nick='Oliyzia'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1257 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1258 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1260 (SELECT player FROM players WHERE nick='Oliyzia'),
1261 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1264 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1265 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1268 (SELECT player FROM players WHERE nick='Tom'),
1271 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1274 (SELECT player FROM players WHERE nick='Tom'),
1275 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1278 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1279 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1281 (SELECT player FROM players WHERE nick='Tom'),
1282 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1285 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1290 INSERT INTO groups (tournament, round, parallel) VALUES (
1291 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1293 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1296 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1298 UPDATE rounds SET randomsongs=1 WHERE
1299 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1301 UPDATE rounds SET chosensongs=1 WHERE
1302 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1304 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1305 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1306 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1308 (SELECT player FROM players WHERE nick='Oliyzia'),
1311 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1312 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1314 (SELECT player FROM players WHERE nick='Oliyzia'),
1315 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1318 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1319 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1322 (SELECT player FROM players WHERE nick='Haggar'),
1325 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1326 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1328 (SELECT player FROM players WHERE nick='Haggar'),
1329 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1332 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1333 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1336 (SELECT player FROM players WHERE nick='Snofox'),
1339 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1340 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1342 (SELECT player FROM players WHERE nick='Snofox'),
1343 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1346 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1347 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1348 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1350 (SELECT player FROM players WHERE nick='RiChY'),
1353 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1354 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1356 (SELECT player FROM players WHERE nick='RiChY'),
1357 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1360 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1361 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1364 (SELECT player FROM players WHERE nick='Mulefisk'),
1367 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1368 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1370 (SELECT player FROM players WHERE nick='Mulefisk'),
1371 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1374 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1375 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1378 (SELECT player FROM players WHERE nick='DufF'),
1381 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1382 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1384 (SELECT player FROM players WHERE nick='DufF'),
1385 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1388 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1389 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1392 (SELECT player FROM players WHERE nick='OJK'),
1395 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1396 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1398 (SELECT player FROM players WHERE nick='OJK'),
1399 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1402 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1406 (SELECT player FROM players WHERE nick='Snute'),
1409 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1410 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1412 (SELECT player FROM players WHERE nick='Snute'),
1413 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1416 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1417 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1420 (SELECT player FROM players WHERE nick='Tom'),
1423 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1424 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1426 (SELECT player FROM players WHERE nick='Tom'),
1427 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1430 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1435 INSERT INTO groups (tournament, round, parallel) VALUES (
1436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1438 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
1443 UPDATE rounds SET randomsongs=1 WHERE
1444 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1446 UPDATE rounds SET chosensongs=1 WHERE
1447 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1449 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1450 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1451 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1453 (SELECT player FROM players WHERE nick='DufF'),
1456 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1457 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1459 (SELECT player FROM players WHERE nick='DufF'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1463 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1465 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1467 (SELECT player FROM players WHERE nick='Oliyzia'),
1470 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1471 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1473 (SELECT player FROM players WHERE nick='Oliyzia'),
1474 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1481 (SELECT player FROM players WHERE nick='OJK'),
1484 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1485 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1487 (SELECT player FROM players WHERE nick='OJK'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1491 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1492 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1493 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1495 (SELECT player FROM players WHERE nick='RiChY'),
1498 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1499 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1501 (SELECT player FROM players WHERE nick='RiChY'),
1502 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1505 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1506 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1509 (SELECT player FROM players WHERE nick='Tom'),
1512 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1513 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1515 (SELECT player FROM players WHERE nick='Tom'),
1516 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1519 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1520 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1523 (SELECT player FROM players WHERE nick='Snofox'),
1526 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1527 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1529 (SELECT player FROM players WHERE nick='Snofox'),
1530 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1533 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1534 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1535 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1537 (SELECT player FROM players WHERE nick='Snute'),
1540 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1541 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1543 (SELECT player FROM players WHERE nick='Snute'),
1544 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1547 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1552 INSERT INTO groups (tournament, round, parallel) VALUES (
1553 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1555 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1556 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1560 UPDATE rounds SET randomsongs=1 WHERE
1561 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1563 UPDATE rounds SET chosensongs=1 WHERE
1564 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1566 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1570 (SELECT player FROM players WHERE nick='Oliyzia'),
1573 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1574 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1576 (SELECT player FROM players WHERE nick='Oliyzia'),
1577 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1580 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1581 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1584 (SELECT player FROM players WHERE nick='Tom'),
1587 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1588 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1590 (SELECT player FROM players WHERE nick='Tom'),
1591 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1594 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1595 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1596 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1598 (SELECT player FROM players WHERE nick='Snute'),
1601 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1602 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1604 (SELECT player FROM players WHERE nick='Snute'),
1605 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1608 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1609 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1612 (SELECT player FROM players WHERE nick='DufF'),
1615 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1616 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1618 (SELECT player FROM players WHERE nick='DufF'),
1619 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1622 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1623 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1626 (SELECT player FROM players WHERE nick='OJK'),
1629 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1630 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1632 (SELECT player FROM players WHERE nick='OJK'),
1633 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1636 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1638 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1641 INSERT INTO groups (tournament, round, parallel) VALUES (
1642 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1644 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1645 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1647 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
1649 UPDATE rounds SET randomsongs=1 WHERE
1650 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1652 UPDATE rounds SET chosensongs=1 WHERE
1653 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1655 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1656 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1657 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1659 (SELECT player FROM players WHERE nick='OJK'),
1662 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1663 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1665 (SELECT player FROM players WHERE nick='OJK'),
1666 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1669 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1670 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1671 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1673 (SELECT player FROM players WHERE nick='Oliyzia'),
1676 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1677 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1679 (SELECT player FROM players WHERE nick='Oliyzia'),
1680 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1683 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1684 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1685 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1687 (SELECT player FROM players WHERE nick='DufF'),
1690 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1691 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1693 (SELECT player FROM players WHERE nick='DufF'),
1694 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1697 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1698 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1699 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1701 (SELECT player FROM players WHERE nick='Snute'),
1704 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1705 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1707 (SELECT player FROM players WHERE nick='Snute'),
1708 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1711 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1716 INSERT INTO groups (tournament, round, parallel) VALUES (
1717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1719 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1720 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1722 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
1724 UPDATE rounds SET randomsongs=1 WHERE
1725 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1727 UPDATE rounds SET chosensongs=1 WHERE
1728 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1730 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1731 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1732 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1734 (SELECT player FROM players WHERE nick='OJK'),
1737 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1738 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1740 (SELECT player FROM players WHERE nick='OJK'),
1741 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1744 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1745 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1746 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1748 (SELECT player FROM players WHERE nick='Snute'),
1751 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1754 (SELECT player FROM players WHERE nick='Snute'),
1755 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1758 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1759 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1760 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1762 (SELECT player FROM players WHERE nick='DufF'),
1765 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1766 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1768 (SELECT player FROM players WHERE nick='DufF'),
1769 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1772 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1774 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1777 INSERT INTO groups (tournament, round, parallel) VALUES (
1778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1780 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1781 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1783 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
1785 UPDATE rounds SET randomsongs=1 WHERE
1786 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1788 UPDATE rounds SET chosensongs=1 WHERE
1789 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1791 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1792 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1793 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1795 (SELECT player FROM players WHERE nick='DufF'),
1798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1801 (SELECT player FROM players WHERE nick='DufF'),
1802 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1805 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1806 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1807 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1809 (SELECT player FROM players WHERE nick='Snute'),
1812 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1813 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1815 (SELECT player FROM players WHERE nick='Snute'),
1816 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),