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 scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
60 (SELECT player FROM players WHERE nick='Haggar'),
61 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
64 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
65 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
66 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
68 (SELECT player FROM players WHERE nick='Ylini'),
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('Healing Vision (Angelic Mix)')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
81 (SELECT player FROM players WHERE nick='Ylini'),
82 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
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='Ylini'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
93 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
94 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
96 (SELECT player FROM players WHERE nick='Mulefisk'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
102 (SELECT player FROM players WHERE nick='Mulefisk'),
103 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
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='Mulefisk'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
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='Mulefisk'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' 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='Slusk'),
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='Slusk'),
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='Slusk'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
144 (SELECT player FROM players WHERE nick='Slusk'),
145 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
152 (SELECT player FROM players WHERE nick='Tom'),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
158 (SELECT player FROM players WHERE nick='Tom'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
165 (SELECT player FROM players WHERE nick='Tom'),
166 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
172 (SELECT player FROM players WHERE nick='Tom'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
176 INSERT INTO groups (tournament, round, parallel) VALUES (
177 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
179 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
180 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
182 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
184 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
189 UPDATE rounds SET randomsongs=2 WHERE
190 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
192 UPDATE rounds SET chosensongs=1 WHERE
193 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
195 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
199 (SELECT player FROM players WHERE nick='Golddragon'),
202 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
205 (SELECT player FROM players WHERE nick='Golddragon'),
206 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
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='Golddragon'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
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='Golddragon'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' 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='Jallaman'),
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='Jallaman'),
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='Jallaman'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
247 (SELECT player FROM players WHERE nick='Jallaman'),
248 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
255 (SELECT player FROM players WHERE nick='OJK'),
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='OJK'),
262 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
268 (SELECT player FROM players WHERE nick='OJK'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
275 (SELECT player FROM players WHERE nick='OJK'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
283 (SELECT player FROM players WHERE nick='Matsi'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
289 (SELECT player FROM players WHERE nick='Matsi'),
290 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
296 (SELECT player FROM players WHERE nick='Matsi'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
303 (SELECT player FROM players WHERE nick='Matsi'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
311 (SELECT player FROM players WHERE nick='Snute'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
317 (SELECT player FROM players WHERE nick='Snute'),
318 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
324 (SELECT player FROM players WHERE nick='Snute'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
331 (SELECT player FROM players WHERE nick='Snute'),
332 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
335 INSERT INTO groups (tournament, round, parallel) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
338 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
339 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
341 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
343 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
348 UPDATE rounds SET randomsongs=2 WHERE
349 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
351 UPDATE rounds SET chosensongs=1 WHERE
352 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
354 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
358 (SELECT player FROM players WHERE nick='tombot'),
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='tombot'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
368 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
371 (SELECT player FROM players WHERE nick='tombot'),
372 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
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='tombot'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
382 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
386 (SELECT player FROM players WHERE nick='Ink'),
389 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
392 (SELECT player FROM players WHERE nick='Ink'),
393 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
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='Ink'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
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='Ink'),
407 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
411 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
414 (SELECT player FROM players WHERE nick='Stream'),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
420 (SELECT player FROM players WHERE nick='Stream'),
421 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
427 (SELECT player FROM players WHERE nick='Stream'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
431 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
434 (SELECT player FROM players WHERE nick='Stream'),
435 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
442 (SELECT player FROM players WHERE nick='Spinnvill'),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
448 (SELECT player FROM players WHERE nick='Spinnvill'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
452 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
455 (SELECT player FROM players WHERE nick='Spinnvill'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
459 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
462 (SELECT player FROM players WHERE nick='Spinnvill'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
470 (SELECT player FROM players WHERE nick='Telc'),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
476 (SELECT player FROM players WHERE nick='Telc'),
477 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
483 (SELECT player FROM players WHERE nick='Telc'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
490 (SELECT player FROM players WHERE nick='Telc'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
498 (SELECT player FROM players WHERE nick='DufF'),
501 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
504 (SELECT player FROM players WHERE nick='DufF'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
508 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
511 (SELECT player FROM players WHERE nick='DufF'),
512 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
515 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
518 (SELECT player FROM players WHERE nick='DufF'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
522 INSERT INTO groups (tournament, round, parallel) VALUES (
523 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
525 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
526 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
528 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
530 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
531 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
533 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
535 UPDATE rounds SET randomsongs=2 WHERE
536 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
538 UPDATE rounds SET chosensongs=1 WHERE
539 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
541 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
542 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
545 (SELECT player FROM players WHERE nick='Duckling'),
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='Duckling'),
552 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
555 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
556 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
558 (SELECT player FROM players WHERE nick='Duckling'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
562 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
565 (SELECT player FROM players WHERE nick='Duckling'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
569 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
570 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
571 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
573 (SELECT player FROM players WHERE nick='Auran'),
576 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
579 (SELECT player FROM players WHERE nick='Auran'),
580 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
586 (SELECT player FROM players WHERE nick='Auran'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
590 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
593 (SELECT player FROM players WHERE nick='Auran'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
599 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
601 (SELECT player FROM players WHERE nick='Advena'),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
607 (SELECT player FROM players WHERE nick='Advena'),
608 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
614 (SELECT player FROM players WHERE nick='Advena'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
618 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
619 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
621 (SELECT player FROM players WHERE nick='Advena'),
622 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
625 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
629 (SELECT player FROM players WHERE nick='Snofox'),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
635 (SELECT player FROM players WHERE nick='Snofox'),
636 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
639 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
642 (SELECT player FROM players WHERE nick='Snofox'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
646 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
649 (SELECT player FROM players WHERE nick='Snofox'),
650 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
653 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
654 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
657 (SELECT player FROM players WHERE nick='Smiph'),
660 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
663 (SELECT player FROM players WHERE nick='Smiph'),
664 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
667 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
668 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
670 (SELECT player FROM players WHERE nick='Smiph'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
674 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
677 (SELECT player FROM players WHERE nick='Smiph'),
678 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
685 (SELECT player FROM players WHERE nick='Oliyzia'),
688 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
691 (SELECT player FROM players WHERE nick='Oliyzia'),
692 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
695 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
698 (SELECT player FROM players WHERE nick='Oliyzia'),
699 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
702 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
703 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
705 (SELECT player FROM players WHERE nick='Oliyzia'),
706 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
709 INSERT INTO groups (tournament, round, parallel) VALUES (
710 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
712 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
715 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
717 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
718 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
720 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
722 UPDATE rounds SET randomsongs=2 WHERE
723 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
725 UPDATE rounds SET chosensongs=1 WHERE
726 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
728 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
729 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
730 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
732 (SELECT player FROM players WHERE nick='x3mnrj'),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
738 (SELECT player FROM players WHERE nick='x3mnrj'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
742 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
743 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
745 (SELECT player FROM players WHERE nick='x3mnrj'),
746 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
749 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
752 (SELECT player FROM players WHERE nick='x3mnrj'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
756 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
757 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
758 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
760 (SELECT player FROM players WHERE nick='Octu'),
763 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
764 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
766 (SELECT player FROM players WHERE nick='Octu'),
767 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
770 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
773 (SELECT player FROM players WHERE nick='Octu'),
774 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
777 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
780 (SELECT player FROM players WHERE nick='Octu'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
788 (SELECT player FROM players WHERE nick='Electus'),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
794 (SELECT player FROM players WHERE nick='Electus'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
801 (SELECT player FROM players WHERE nick='Electus'),
802 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
805 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
806 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
808 (SELECT player FROM players WHERE nick='Electus'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
812 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
816 (SELECT player FROM players WHERE nick='Purity'),
819 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
822 (SELECT player FROM players WHERE nick='Purity'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
826 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
829 (SELECT player FROM players WHERE nick='Purity'),
830 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
833 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
834 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
836 (SELECT player FROM players WHERE nick='Purity'),
837 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
840 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
841 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
844 (SELECT player FROM players WHERE nick='Havok'),
847 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
850 (SELECT player FROM players WHERE nick='Havok'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
854 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
855 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
857 (SELECT player FROM players WHERE nick='Havok'),
858 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
861 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
864 (SELECT player FROM players WHERE nick='Havok'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
868 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
869 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
872 (SELECT player FROM players WHERE nick='Draconia'),
875 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
878 (SELECT player FROM players WHERE nick='Draconia'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
882 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
885 (SELECT player FROM players WHERE nick='Draconia'),
886 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
889 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
890 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
892 (SELECT player FROM players WHERE nick='Draconia'),
893 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
896 INSERT INTO groups (tournament, round, parallel) VALUES (
897 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
899 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
900 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
902 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
904 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
907 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
909 UPDATE rounds SET randomsongs=2 WHERE
910 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
912 UPDATE rounds SET chosensongs=1 WHERE
913 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
915 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
916 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
917 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
919 (SELECT player FROM players WHERE nick='Dexter'),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
925 (SELECT player FROM players WHERE nick='Dexter'),
926 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
929 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
930 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
932 (SELECT player FROM players WHERE nick='Dexter'),
933 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
936 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
939 (SELECT player FROM players WHERE nick='Dexter'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
943 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
944 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
945 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
947 (SELECT player FROM players WHERE nick='Olemann'),
950 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
953 (SELECT player FROM players WHERE nick='Olemann'),
954 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
957 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
960 (SELECT player FROM players WHERE nick='Olemann'),
961 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
964 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
967 (SELECT player FROM players WHERE nick='Olemann'),
968 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
971 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
972 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
973 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
975 (SELECT player FROM players WHERE nick='Tha Dragon'),
978 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
981 (SELECT player FROM players WHERE nick='Tha Dragon'),
982 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
985 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
986 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
988 (SELECT player FROM players WHERE nick='Tha Dragon'),
989 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
992 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
993 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
995 (SELECT player FROM players WHERE nick='Tha Dragon'),
996 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
999 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1001 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1003 (SELECT player FROM players WHERE nick='T|na'),
1006 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1009 (SELECT player FROM players WHERE nick='T|na'),
1010 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1013 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1014 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1016 (SELECT player FROM players WHERE nick='T|na'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1020 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1021 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1023 (SELECT player FROM players WHERE nick='T|na'),
1024 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1027 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1028 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1031 (SELECT player FROM players WHERE nick='RiChY'),
1034 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1037 (SELECT player FROM players WHERE nick='RiChY'),
1038 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1041 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1042 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1044 (SELECT player FROM players WHERE nick='RiChY'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1048 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1051 (SELECT player FROM players WHERE nick='RiChY'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1055 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1056 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1059 (SELECT player FROM players WHERE nick='Daniil'),
1062 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1063 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1065 (SELECT player FROM players WHERE nick='Daniil'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1069 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1070 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1072 (SELECT player FROM players WHERE nick='Daniil'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1076 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1079 (SELECT player FROM players WHERE nick='Daniil'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1083 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1088 INSERT INTO groups (tournament, round, parallel) VALUES (
1089 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1091 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1092 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1094 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1096 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1097 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1099 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1101 UPDATE rounds SET randomsongs=2 WHERE
1102 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1104 UPDATE rounds SET chosensongs=1 WHERE
1105 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1107 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1109 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1111 (SELECT player FROM players WHERE nick='Smiph'),
1114 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1115 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1117 (SELECT player FROM players WHERE nick='Smiph'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1121 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1124 (SELECT player FROM players WHERE nick='Smiph'),
1125 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1128 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1129 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1131 (SELECT player FROM players WHERE nick='Smiph'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1135 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1136 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1137 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1139 (SELECT player FROM players WHERE nick='Daniil'),
1142 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1145 (SELECT player FROM players WHERE nick='Daniil'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1149 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1152 (SELECT player FROM players WHERE nick='Daniil'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1156 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1157 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1159 (SELECT player FROM players WHERE nick='Daniil'),
1160 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1163 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1164 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1165 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1167 (SELECT player FROM players WHERE nick='Snofox'),
1170 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1173 (SELECT player FROM players WHERE nick='Snofox'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1177 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1180 (SELECT player FROM players WHERE nick='Snofox'),
1181 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1184 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1187 (SELECT player FROM players WHERE nick='Snofox'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1193 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1195 (SELECT player FROM players WHERE nick='Snute'),
1198 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1199 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1201 (SELECT player FROM players WHERE nick='Snute'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1205 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1206 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1208 (SELECT player FROM players WHERE nick='Snute'),
1209 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1212 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1213 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1215 (SELECT player FROM players WHERE nick='Snute'),
1216 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1219 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
1220 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1221 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1223 (SELECT player FROM players WHERE nick='Purity'),
1226 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1227 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1229 (SELECT player FROM players WHERE nick='Purity'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1233 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1234 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1236 (SELECT player FROM players WHERE nick='Purity'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1240 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1241 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1243 (SELECT player FROM players WHERE nick='Purity'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1247 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1248 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1251 (SELECT player FROM players WHERE nick='DufF'),
1254 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1257 (SELECT player FROM players WHERE nick='DufF'),
1258 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1261 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1262 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1264 (SELECT player FROM players WHERE nick='DufF'),
1265 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1268 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1269 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1271 (SELECT player FROM players WHERE nick='DufF'),
1272 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1275 INSERT INTO groups (tournament, round, parallel) VALUES (
1276 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1278 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1279 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1281 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
1283 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1284 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1286 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1288 UPDATE rounds SET randomsongs=2 WHERE
1289 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1291 UPDATE rounds SET chosensongs=1 WHERE
1292 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1294 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
1295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1296 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1298 (SELECT player FROM players WHERE nick='Havok'),
1301 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1304 (SELECT player FROM players WHERE nick='Havok'),
1305 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1308 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1311 (SELECT player FROM players WHERE nick='Havok'),
1312 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1315 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1316 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1318 (SELECT player FROM players WHERE nick='Havok'),
1319 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1322 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
1323 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1324 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1326 (SELECT player FROM players WHERE nick='Jallaman'),
1329 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1330 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1332 (SELECT player FROM players WHERE nick='Jallaman'),
1333 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1336 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1339 (SELECT player FROM players WHERE nick='Jallaman'),
1340 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1343 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1346 (SELECT player FROM players WHERE nick='Jallaman'),
1347 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1350 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1351 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1352 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1354 (SELECT player FROM players WHERE nick='Haggar'),
1357 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1360 (SELECT player FROM players WHERE nick='Haggar'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1364 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1367 (SELECT player FROM players WHERE nick='Haggar'),
1368 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1371 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1372 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1374 (SELECT player FROM players WHERE nick='Haggar'),
1375 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1378 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1380 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1382 (SELECT player FROM players WHERE nick='T|na'),
1385 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1388 (SELECT player FROM players WHERE nick='T|na'),
1389 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1392 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1393 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1395 (SELECT player FROM players WHERE nick='T|na'),
1396 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1399 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1402 (SELECT player FROM players WHERE nick='T|na'),
1403 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1406 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1407 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1408 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1410 (SELECT player FROM players WHERE nick='OJK'),
1413 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1416 (SELECT player FROM players WHERE nick='OJK'),
1417 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1420 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1421 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1423 (SELECT player FROM players WHERE nick='OJK'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1427 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1428 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1430 (SELECT player FROM players WHERE nick='OJK'),
1431 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1434 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1435 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1436 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1438 (SELECT player FROM players WHERE nick='RiChY'),
1441 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1444 (SELECT player FROM players WHERE nick='RiChY'),
1445 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1448 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1449 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1451 (SELECT player FROM players WHERE nick='RiChY'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1455 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1458 (SELECT player FROM players WHERE nick='RiChY'),
1459 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1462 INSERT INTO groups (tournament, round, parallel) VALUES (
1463 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1465 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1466 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1468 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1470 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1471 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1475 UPDATE rounds SET randomsongs=2 WHERE
1476 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1478 UPDATE rounds SET chosensongs=1 WHERE
1479 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1481 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1483 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1485 (SELECT player FROM players WHERE nick='Mulefisk'),
1488 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1489 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1491 (SELECT player FROM players WHERE nick='Mulefisk'),
1492 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1495 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1498 (SELECT player FROM players WHERE nick='Mulefisk'),
1499 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1502 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1503 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1505 (SELECT player FROM players WHERE nick='Mulefisk'),
1506 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1509 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1510 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1511 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1513 (SELECT player FROM players WHERE nick='Stream'),
1516 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1519 (SELECT player FROM players WHERE nick='Stream'),
1520 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1523 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1526 (SELECT player FROM players WHERE nick='Stream'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1530 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1531 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1533 (SELECT player FROM players WHERE nick='Stream'),
1534 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1537 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
1538 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1539 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1541 (SELECT player FROM players WHERE nick='Electus'),
1544 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1545 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1547 (SELECT player FROM players WHERE nick='Electus'),
1548 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1551 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1554 (SELECT player FROM players WHERE nick='Electus'),
1555 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1558 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1559 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1561 (SELECT player FROM players WHERE nick='Electus'),
1562 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1565 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
1566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1567 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1569 (SELECT player FROM players WHERE nick='Spinnvill'),
1572 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1573 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1575 (SELECT player FROM players WHERE nick='Spinnvill'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1579 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1582 (SELECT player FROM players WHERE nick='Spinnvill'),
1583 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1586 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1587 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1589 (SELECT player FROM players WHERE nick='Spinnvill'),
1590 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1593 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1594 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1595 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1597 (SELECT player FROM players WHERE nick='Oliyzia'),
1600 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1601 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1603 (SELECT player FROM players WHERE nick='Oliyzia'),
1604 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1607 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1608 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1610 (SELECT player FROM players WHERE nick='Oliyzia'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1614 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1615 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1617 (SELECT player FROM players WHERE nick='Oliyzia'),
1618 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1621 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1622 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1623 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1625 (SELECT player FROM players WHERE nick='Tom'),
1628 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1629 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1631 (SELECT player FROM players WHERE nick='Tom'),
1632 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1635 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1636 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1638 (SELECT player FROM players WHERE nick='Tom'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1642 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1643 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1645 (SELECT player FROM players WHERE nick='Tom'),
1646 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1649 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1651 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1654 INSERT INTO groups (tournament, round, parallel) VALUES (
1655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1657 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1658 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1662 UPDATE rounds SET randomsongs=1 WHERE
1663 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1665 UPDATE rounds SET chosensongs=1 WHERE
1666 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1668 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1669 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1670 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1672 (SELECT player FROM players WHERE nick='Oliyzia'),
1675 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1676 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1678 (SELECT player FROM players WHERE nick='Oliyzia'),
1679 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1682 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1685 (SELECT player FROM players WHERE nick='Oliyzia'),
1686 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1689 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1690 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1691 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1693 (SELECT player FROM players WHERE nick='Haggar'),
1696 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1699 (SELECT player FROM players WHERE nick='Haggar'),
1700 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1703 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1704 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1706 (SELECT player FROM players WHERE nick='Haggar'),
1707 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1710 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1711 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1712 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1714 (SELECT player FROM players WHERE nick='Snofox'),
1717 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1718 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1720 (SELECT player FROM players WHERE nick='Snofox'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1724 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1725 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1727 (SELECT player FROM players WHERE nick='Snofox'),
1728 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1731 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1732 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1733 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1735 (SELECT player FROM players WHERE nick='RiChY'),
1738 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1741 (SELECT player FROM players WHERE nick='RiChY'),
1742 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1745 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1746 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1748 (SELECT player FROM players WHERE nick='RiChY'),
1749 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1752 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1754 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1756 (SELECT player FROM players WHERE nick='Mulefisk'),
1759 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1760 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1762 (SELECT player FROM players WHERE nick='Mulefisk'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1766 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1769 (SELECT player FROM players WHERE nick='Mulefisk'),
1770 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1773 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1774 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1775 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1777 (SELECT player FROM players WHERE nick='DufF'),
1780 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1781 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1783 (SELECT player FROM players WHERE nick='DufF'),
1784 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1787 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1788 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1790 (SELECT player FROM players WHERE nick='DufF'),
1791 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1794 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1796 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1798 (SELECT player FROM players WHERE nick='OJK'),
1801 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1802 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1804 (SELECT player FROM players WHERE nick='OJK'),
1805 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1808 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1811 (SELECT player FROM players WHERE nick='OJK'),
1812 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1815 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1816 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1817 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1819 (SELECT player FROM players WHERE nick='Snute'),
1822 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1823 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1825 (SELECT player FROM players WHERE nick='Snute'),
1826 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1829 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1830 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1832 (SELECT player FROM players WHERE nick='Snute'),
1833 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1836 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1838 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1840 (SELECT player FROM players WHERE nick='Tom'),
1843 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1844 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1846 (SELECT player FROM players WHERE nick='Tom'),
1847 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1850 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1851 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1853 (SELECT player FROM players WHERE nick='Tom'),
1854 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1857 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1859 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1862 INSERT INTO groups (tournament, round, parallel) VALUES (
1863 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1865 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1866 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1868 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
1870 UPDATE rounds SET randomsongs=1 WHERE
1871 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1873 UPDATE rounds SET chosensongs=1 WHERE
1874 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
1876 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1877 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1878 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1880 (SELECT player FROM players WHERE nick='DufF'),
1883 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1886 (SELECT player FROM players WHERE nick='DufF'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1890 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1893 (SELECT player FROM players WHERE nick='DufF'),
1894 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1897 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1899 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1901 (SELECT player FROM players WHERE nick='Oliyzia'),
1904 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1907 (SELECT player FROM players WHERE nick='Oliyzia'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1911 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1912 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1914 (SELECT player FROM players WHERE nick='Oliyzia'),
1915 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1918 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1919 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1920 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1922 (SELECT player FROM players WHERE nick='OJK'),
1925 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1928 (SELECT player FROM players WHERE nick='OJK'),
1929 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1932 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1933 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1935 (SELECT player FROM players WHERE nick='OJK'),
1936 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1939 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1940 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1941 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1943 (SELECT player FROM players WHERE nick='RiChY'),
1946 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1949 (SELECT player FROM players WHERE nick='RiChY'),
1950 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1953 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1956 (SELECT player FROM players WHERE nick='RiChY'),
1957 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1960 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1961 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1962 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1964 (SELECT player FROM players WHERE nick='Tom'),
1967 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1968 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1970 (SELECT player FROM players WHERE nick='Tom'),
1971 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1974 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1975 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1977 (SELECT player FROM players WHERE nick='Tom'),
1978 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
1981 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1982 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1983 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1985 (SELECT player FROM players WHERE nick='Snofox'),
1988 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1989 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1991 (SELECT player FROM players WHERE nick='Snofox'),
1992 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1995 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1996 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
1998 (SELECT player FROM players WHERE nick='Snofox'),
1999 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2002 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2003 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2004 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2006 (SELECT player FROM players WHERE nick='Snute'),
2009 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2010 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2012 (SELECT player FROM players WHERE nick='Snute'),
2013 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2016 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2017 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2019 (SELECT player FROM players WHERE nick='Snute'),
2020 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2023 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2025 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2028 INSERT INTO groups (tournament, round, parallel) VALUES (
2029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2031 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2032 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2034 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2036 UPDATE rounds SET randomsongs=1 WHERE
2037 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2039 UPDATE rounds SET chosensongs=1 WHERE
2040 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2042 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2043 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2044 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2046 (SELECT player FROM players WHERE nick='Oliyzia'),
2049 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2052 (SELECT player FROM players WHERE nick='Oliyzia'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2056 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2059 (SELECT player FROM players WHERE nick='Oliyzia'),
2060 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2063 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
2064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2065 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2067 (SELECT player FROM players WHERE nick='Tom'),
2070 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2071 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2073 (SELECT player FROM players WHERE nick='Tom'),
2074 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2077 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2078 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2080 (SELECT player FROM players WHERE nick='Tom'),
2081 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2084 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2085 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2086 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2088 (SELECT player FROM players WHERE nick='Snute'),
2091 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2092 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2094 (SELECT player FROM players WHERE nick='Snute'),
2095 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2098 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2099 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2101 (SELECT player FROM players WHERE nick='Snute'),
2102 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2105 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2106 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2109 (SELECT player FROM players WHERE nick='DufF'),
2112 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2115 (SELECT player FROM players WHERE nick='DufF'),
2116 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2119 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2120 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2122 (SELECT player FROM players WHERE nick='DufF'),
2123 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2127 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2130 (SELECT player FROM players WHERE nick='OJK'),
2133 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2134 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2136 (SELECT player FROM players WHERE nick='OJK'),
2137 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2140 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2143 (SELECT player FROM players WHERE nick='OJK'),
2144 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2147 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2149 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2152 INSERT INTO groups (tournament, round, parallel) VALUES (
2153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2155 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2158 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
2160 UPDATE rounds SET randomsongs=1 WHERE
2161 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2163 UPDATE rounds SET chosensongs=1 WHERE
2164 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2166 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2170 (SELECT player FROM players WHERE nick='OJK'),
2173 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2174 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2176 (SELECT player FROM players WHERE nick='OJK'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2180 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2181 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2183 (SELECT player FROM players WHERE nick='OJK'),
2184 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2187 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2188 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2191 (SELECT player FROM players WHERE nick='Oliyzia'),
2194 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2195 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2197 (SELECT player FROM players WHERE nick='Oliyzia'),
2198 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2201 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2202 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2204 (SELECT player FROM players WHERE nick='Oliyzia'),
2205 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2208 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2209 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2212 (SELECT player FROM players WHERE nick='DufF'),
2215 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2216 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2218 (SELECT player FROM players WHERE nick='DufF'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2222 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2223 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2225 (SELECT player FROM players WHERE nick='DufF'),
2226 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2229 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2230 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2233 (SELECT player FROM players WHERE nick='Snute'),
2236 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2237 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2239 (SELECT player FROM players WHERE nick='Snute'),
2240 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2243 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2244 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2246 (SELECT player FROM players WHERE nick='Snute'),
2247 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2250 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2255 INSERT INTO groups (tournament, round, parallel) VALUES (
2256 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2258 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2261 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2263 UPDATE rounds SET randomsongs=1 WHERE
2264 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2266 UPDATE rounds SET chosensongs=1 WHERE
2267 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2269 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2270 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2271 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2273 (SELECT player FROM players WHERE nick='OJK'),
2276 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2277 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2279 (SELECT player FROM players WHERE nick='OJK'),
2280 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2283 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2284 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2286 (SELECT player FROM players WHERE nick='OJK'),
2287 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
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 name='Challenge Cup 1 - 2004'),
2294 (SELECT player FROM players WHERE nick='Snute'),
2297 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2298 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2300 (SELECT player FROM players WHERE nick='Snute'),
2301 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2304 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2307 (SELECT player FROM players WHERE nick='Snute'),
2308 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2311 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2315 (SELECT player FROM players WHERE nick='DufF'),
2318 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2319 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2321 (SELECT player FROM players WHERE nick='DufF'),
2322 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2325 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2326 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2328 (SELECT player FROM players WHERE nick='DufF'),
2329 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2332 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2337 INSERT INTO groups (tournament, round, parallel) VALUES (
2338 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2340 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2343 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
2345 UPDATE rounds SET randomsongs=1 WHERE
2346 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2348 UPDATE rounds SET chosensongs=1 WHERE
2349 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004') AND
2351 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2352 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2353 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2355 (SELECT player FROM players WHERE nick='DufF'),
2358 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2359 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2361 (SELECT player FROM players WHERE nick='DufF'),
2362 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2365 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2366 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2368 (SELECT player FROM players WHERE nick='DufF'),
2369 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2372 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2373 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2374 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2376 (SELECT player FROM players WHERE nick='Snute'),
2379 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2380 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2382 (SELECT player FROM players WHERE nick='Snute'),
2383 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2386 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2387 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 1 - 2004'),
2389 (SELECT player FROM players WHERE nick='Snute'),
2390 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),