2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
5 'Challenge Cup 1 - 2004',
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
16 (SELECT player FROM players WHERE nick='Snute'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
22 (SELECT player FROM players WHERE nick='DufF'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
28 (SELECT player FROM players WHERE nick='OJK'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
34 (SELECT player FROM players WHERE nick='Oliyzia'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
40 (SELECT player FROM players WHERE nick='Tom'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
46 (SELECT player FROM players WHERE nick='Snofox'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
52 (SELECT player FROM players WHERE nick='RiChY'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
58 (SELECT player FROM players WHERE nick='Haggar'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
64 (SELECT player FROM players WHERE nick='Mulefisk'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
70 (SELECT player FROM players WHERE nick='Daniil'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
76 (SELECT player FROM players WHERE nick='T|na'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
82 (SELECT player FROM players WHERE nick='Stream'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
88 (SELECT player FROM players WHERE nick='Purity'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
94 (SELECT player FROM players WHERE nick='Spinnvill'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
100 (SELECT player FROM players WHERE nick='Jallaman'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
106 (SELECT player FROM players WHERE nick='Smiph'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
112 (SELECT player FROM players WHERE nick='Electus'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
118 (SELECT player FROM players WHERE nick='Havok'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
124 (SELECT player FROM players WHERE nick='Dexter'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
130 (SELECT player FROM players WHERE nick='Draconia'),
132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
136 (SELECT player FROM players WHERE nick='Advena'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
142 (SELECT player FROM players WHERE nick='Slusk'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
148 (SELECT player FROM players WHERE nick='Telc'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
154 (SELECT player FROM players WHERE nick='Matsi'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
160 (SELECT player FROM players WHERE nick='Olemann'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
166 (SELECT player FROM players WHERE nick='Duckling'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
172 (SELECT player FROM players WHERE nick='Ylini'),
174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
178 (SELECT player FROM players WHERE nick='Golddragon'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
184 (SELECT player FROM players WHERE nick='tombot'),
186 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
190 (SELECT player FROM players WHERE nick='x3mnrj'),
192 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
193 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
196 (SELECT player FROM players WHERE nick='Tha Dragon'),
198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
199 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
202 (SELECT player FROM players WHERE nick='Octu'),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
205 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
208 (SELECT player FROM players WHERE nick='Ink'),
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
211 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
214 (SELECT player FROM players WHERE nick='Auran'),
216 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
221 INSERT INTO groups (tournament, round, parallel) VALUES (
222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
224 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
227 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
229 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
232 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
234 UPDATE rounds SET randomsongs=2 WHERE
235 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
237 UPDATE rounds SET chosensongs=1 WHERE
238 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
243 (SELECT player FROM players WHERE nick='Haggar'),
246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
249 (SELECT player FROM players WHERE nick='Haggar'),
251 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
257 (SELECT player FROM players WHERE nick='Haggar'),
259 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
265 (SELECT player FROM players WHERE nick='Haggar'),
267 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
270 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
273 (SELECT player FROM players WHERE nick='Ylini'),
276 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
279 (SELECT player FROM players WHERE nick='Ylini'),
281 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
287 (SELECT player FROM players WHERE nick='Ylini'),
289 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
292 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
295 (SELECT player FROM players WHERE nick='Ylini'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
300 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
303 (SELECT player FROM players WHERE nick='Mulefisk'),
306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
309 (SELECT player FROM players WHERE nick='Mulefisk'),
311 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
314 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
317 (SELECT player FROM players WHERE nick='Mulefisk'),
319 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
322 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
323 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
325 (SELECT player FROM players WHERE nick='Mulefisk'),
327 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
330 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
333 (SELECT player FROM players WHERE nick='Slusk'),
336 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
339 (SELECT player FROM players WHERE nick='Slusk'),
341 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
344 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
347 (SELECT player FROM players WHERE nick='Slusk'),
349 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
352 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
353 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
355 (SELECT player FROM players WHERE nick='Slusk'),
357 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
360 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
363 (SELECT player FROM players WHERE nick='Tom'),
366 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
369 (SELECT player FROM players WHERE nick='Tom'),
371 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
377 (SELECT player FROM players WHERE nick='Tom'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
382 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
385 (SELECT player FROM players WHERE nick='Tom'),
387 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
390 INSERT INTO groups (tournament, round, parallel) VALUES (
391 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
393 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
396 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
398 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
401 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
403 UPDATE rounds SET randomsongs=2 WHERE
404 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
406 UPDATE rounds SET chosensongs=1 WHERE
407 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
409 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
412 (SELECT player FROM players WHERE nick='Golddragon'),
415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
418 (SELECT player FROM players WHERE nick='Golddragon'),
420 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
426 (SELECT player FROM players WHERE nick='Golddragon'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
434 (SELECT player FROM players WHERE nick='Golddragon'),
436 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
442 (SELECT player FROM players WHERE nick='Jallaman'),
445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
448 (SELECT player FROM players WHERE nick='Jallaman'),
450 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
456 (SELECT player FROM players WHERE nick='Jallaman'),
458 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
464 (SELECT player FROM players WHERE nick='Jallaman'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
469 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
472 (SELECT player FROM players WHERE nick='OJK'),
475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
478 (SELECT player FROM players WHERE nick='OJK'),
480 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
486 (SELECT player FROM players WHERE nick='OJK'),
488 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
491 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
492 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
494 (SELECT player FROM players WHERE nick='OJK'),
496 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
499 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
502 (SELECT player FROM players WHERE nick='Matsi'),
505 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
508 (SELECT player FROM players WHERE nick='Matsi'),
510 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
513 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
514 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
516 (SELECT player FROM players WHERE nick='Matsi'),
518 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
521 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
524 (SELECT player FROM players WHERE nick='Matsi'),
526 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
529 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
532 (SELECT player FROM players WHERE nick='Snute'),
535 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
538 (SELECT player FROM players WHERE nick='Snute'),
540 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
543 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
544 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
546 (SELECT player FROM players WHERE nick='Snute'),
548 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
551 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
554 (SELECT player FROM players WHERE nick='Snute'),
556 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
559 INSERT INTO groups (tournament, round, parallel) VALUES (
560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
562 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
565 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
567 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
570 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
572 UPDATE rounds SET randomsongs=2 WHERE
573 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
575 UPDATE rounds SET chosensongs=1 WHERE
576 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
581 (SELECT player FROM players WHERE nick='tombot'),
584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
587 (SELECT player FROM players WHERE nick='tombot'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
595 (SELECT player FROM players WHERE nick='tombot'),
597 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
603 (SELECT player FROM players WHERE nick='tombot'),
605 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
608 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
611 (SELECT player FROM players WHERE nick='Ink'),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
617 (SELECT player FROM players WHERE nick='Ink'),
619 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
622 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
625 (SELECT player FROM players WHERE nick='Ink'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
630 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
633 (SELECT player FROM players WHERE nick='Ink'),
635 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
641 (SELECT player FROM players WHERE nick='Stream'),
644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
647 (SELECT player FROM players WHERE nick='Stream'),
649 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
655 (SELECT player FROM players WHERE nick='Stream'),
657 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
663 (SELECT player FROM players WHERE nick='Stream'),
665 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
668 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
671 (SELECT player FROM players WHERE nick='Spinnvill'),
674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
677 (SELECT player FROM players WHERE nick='Spinnvill'),
679 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
682 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
683 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
685 (SELECT player FROM players WHERE nick='Spinnvill'),
687 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
690 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
691 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
693 (SELECT player FROM players WHERE nick='Spinnvill'),
695 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
698 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
701 (SELECT player FROM players WHERE nick='Telc'),
704 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
705 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
707 (SELECT player FROM players WHERE nick='Telc'),
709 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
712 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
713 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
715 (SELECT player FROM players WHERE nick='Telc'),
717 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
723 (SELECT player FROM players WHERE nick='Telc'),
725 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
728 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
731 (SELECT player FROM players WHERE nick='DufF'),
734 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
735 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
737 (SELECT player FROM players WHERE nick='DufF'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
742 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
745 (SELECT player FROM players WHERE nick='DufF'),
747 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
751 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
753 (SELECT player FROM players WHERE nick='DufF'),
755 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
758 INSERT INTO groups (tournament, round, parallel) VALUES (
759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
761 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
762 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
764 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
766 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
769 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
771 UPDATE rounds SET randomsongs=2 WHERE
772 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
774 UPDATE rounds SET chosensongs=1 WHERE
775 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
777 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
780 (SELECT player FROM players WHERE nick='Duckling'),
783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
786 (SELECT player FROM players WHERE nick='Duckling'),
788 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
794 (SELECT player FROM players WHERE nick='Duckling'),
796 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
799 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
802 (SELECT player FROM players WHERE nick='Duckling'),
804 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
807 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
810 (SELECT player FROM players WHERE nick='Auran'),
813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
816 (SELECT player FROM players WHERE nick='Auran'),
818 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
824 (SELECT player FROM players WHERE nick='Auran'),
826 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
829 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
832 (SELECT player FROM players WHERE nick='Auran'),
834 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
840 (SELECT player FROM players WHERE nick='Advena'),
843 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
846 (SELECT player FROM players WHERE nick='Advena'),
848 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
851 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
854 (SELECT player FROM players WHERE nick='Advena'),
856 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
862 (SELECT player FROM players WHERE nick='Advena'),
864 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
867 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
870 (SELECT player FROM players WHERE nick='Snofox'),
873 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
874 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
876 (SELECT player FROM players WHERE nick='Snofox'),
878 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
881 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
882 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
884 (SELECT player FROM players WHERE nick='Snofox'),
886 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
889 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
890 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
892 (SELECT player FROM players WHERE nick='Snofox'),
894 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
900 (SELECT player FROM players WHERE nick='Smiph'),
903 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
904 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
906 (SELECT player FROM players WHERE nick='Smiph'),
908 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
911 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
914 (SELECT player FROM players WHERE nick='Smiph'),
916 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
919 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
922 (SELECT player FROM players WHERE nick='Smiph'),
924 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
927 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
930 (SELECT player FROM players WHERE nick='Oliyzia'),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
936 (SELECT player FROM players WHERE nick='Oliyzia'),
938 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
944 (SELECT player FROM players WHERE nick='Oliyzia'),
946 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
949 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
950 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
952 (SELECT player FROM players WHERE nick='Oliyzia'),
954 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
957 INSERT INTO groups (tournament, round, parallel) VALUES (
958 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
960 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
961 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
963 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
965 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
968 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
970 UPDATE rounds SET randomsongs=2 WHERE
971 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
973 UPDATE rounds SET chosensongs=1 WHERE
974 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
976 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
979 (SELECT player FROM players WHERE nick='x3mnrj'),
982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
985 (SELECT player FROM players WHERE nick='x3mnrj'),
987 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
990 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
991 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
993 (SELECT player FROM players WHERE nick='x3mnrj'),
995 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
998 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1001 (SELECT player FROM players WHERE nick='x3mnrj'),
1003 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1006 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1009 (SELECT player FROM players WHERE nick='Octu'),
1012 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1015 (SELECT player FROM players WHERE nick='Octu'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1020 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1021 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1023 (SELECT player FROM players WHERE nick='Octu'),
1025 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1031 (SELECT player FROM players WHERE nick='Octu'),
1033 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1039 (SELECT player FROM players WHERE nick='Electus'),
1042 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1045 (SELECT player FROM players WHERE nick='Electus'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1050 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1053 (SELECT player FROM players WHERE nick='Electus'),
1055 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1058 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1059 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1061 (SELECT player FROM players WHERE nick='Electus'),
1063 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1066 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1069 (SELECT player FROM players WHERE nick='Purity'),
1072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1073 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1075 (SELECT player FROM players WHERE nick='Purity'),
1077 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1083 (SELECT player FROM players WHERE nick='Purity'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1088 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1091 (SELECT player FROM players WHERE nick='Purity'),
1093 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1096 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1099 (SELECT player FROM players WHERE nick='Havok'),
1102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1105 (SELECT player FROM players WHERE nick='Havok'),
1107 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1110 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1113 (SELECT player FROM players WHERE nick='Havok'),
1115 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1121 (SELECT player FROM players WHERE nick='Havok'),
1123 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1129 (SELECT player FROM players WHERE nick='Draconia'),
1132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1135 (SELECT player FROM players WHERE nick='Draconia'),
1137 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1143 (SELECT player FROM players WHERE nick='Draconia'),
1145 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1151 (SELECT player FROM players WHERE nick='Draconia'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1156 INSERT INTO groups (tournament, round, parallel) VALUES (
1157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1159 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1160 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1162 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1164 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1167 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1169 UPDATE rounds SET randomsongs=2 WHERE
1170 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1172 UPDATE rounds SET chosensongs=1 WHERE
1173 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1175 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1178 (SELECT player FROM players WHERE nick='Dexter'),
1181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1184 (SELECT player FROM players WHERE nick='Dexter'),
1186 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1190 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1192 (SELECT player FROM players WHERE nick='Dexter'),
1194 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1197 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1200 (SELECT player FROM players WHERE nick='Dexter'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1205 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1208 (SELECT player FROM players WHERE nick='Olemann'),
1211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1214 (SELECT player FROM players WHERE nick='Olemann'),
1216 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1222 (SELECT player FROM players WHERE nick='Olemann'),
1224 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1230 (SELECT player FROM players WHERE nick='Olemann'),
1232 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1235 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1238 (SELECT player FROM players WHERE nick='Tha Dragon'),
1241 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1244 (SELECT player FROM players WHERE nick='Tha Dragon'),
1246 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1249 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1250 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1252 (SELECT player FROM players WHERE nick='Tha Dragon'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1257 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1260 (SELECT player FROM players WHERE nick='Tha Dragon'),
1262 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1265 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1268 (SELECT player FROM players WHERE nick='T|na'),
1271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1274 (SELECT player FROM players WHERE nick='T|na'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1282 (SELECT player FROM players WHERE nick='T|na'),
1284 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1290 (SELECT player FROM players WHERE nick='T|na'),
1292 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1298 (SELECT player FROM players WHERE nick='RiChY'),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1304 (SELECT player FROM players WHERE nick='RiChY'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1312 (SELECT player FROM players WHERE nick='RiChY'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1320 (SELECT player FROM players WHERE nick='RiChY'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1325 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1328 (SELECT player FROM players WHERE nick='Daniil'),
1331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1334 (SELECT player FROM players WHERE nick='Daniil'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1339 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1342 (SELECT player FROM players WHERE nick='Daniil'),
1344 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1350 (SELECT player FROM players WHERE nick='Daniil'),
1352 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1355 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1360 INSERT INTO groups (tournament, round, parallel) VALUES (
1361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1363 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1366 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1368 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1371 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1373 UPDATE rounds SET randomsongs=2 WHERE
1374 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1376 UPDATE rounds SET chosensongs=1 WHERE
1377 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1382 (SELECT player FROM players WHERE nick='Smiph'),
1385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1388 (SELECT player FROM players WHERE nick='Smiph'),
1390 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1396 (SELECT player FROM players WHERE nick='Smiph'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1401 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1404 (SELECT player FROM players WHERE nick='Smiph'),
1406 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1409 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1412 (SELECT player FROM players WHERE nick='Daniil'),
1415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1418 (SELECT player FROM players WHERE nick='Daniil'),
1420 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1426 (SELECT player FROM players WHERE nick='Daniil'),
1428 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1434 (SELECT player FROM players WHERE nick='Daniil'),
1436 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1442 (SELECT player FROM players WHERE nick='Snofox'),
1445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1448 (SELECT player FROM players WHERE nick='Snofox'),
1450 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1456 (SELECT player FROM players WHERE nick='Snofox'),
1458 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1464 (SELECT player FROM players WHERE nick='Snofox'),
1466 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1469 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1472 (SELECT player FROM players WHERE nick='Snute'),
1475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1478 (SELECT player FROM players WHERE nick='Snute'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1486 (SELECT player FROM players WHERE nick='Snute'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1491 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1492 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1494 (SELECT player FROM players WHERE nick='Snute'),
1496 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1499 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1502 (SELECT player FROM players WHERE nick='Purity'),
1505 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1508 (SELECT player FROM players WHERE nick='Purity'),
1510 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1513 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1514 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1516 (SELECT player FROM players WHERE nick='Purity'),
1518 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1521 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1524 (SELECT player FROM players WHERE nick='Purity'),
1526 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1529 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1532 (SELECT player FROM players WHERE nick='DufF'),
1535 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1538 (SELECT player FROM players WHERE nick='DufF'),
1540 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1543 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1544 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1546 (SELECT player FROM players WHERE nick='DufF'),
1548 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1551 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1554 (SELECT player FROM players WHERE nick='DufF'),
1556 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1559 INSERT INTO groups (tournament, round, parallel) VALUES (
1560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1562 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1565 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
1567 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1570 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1572 UPDATE rounds SET randomsongs=2 WHERE
1573 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1575 UPDATE rounds SET chosensongs=1 WHERE
1576 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1581 (SELECT player FROM players WHERE nick='Havok'),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1587 (SELECT player FROM players WHERE nick='Havok'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1595 (SELECT player FROM players WHERE nick='Havok'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1603 (SELECT player FROM players WHERE nick='Havok'),
1605 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1608 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1611 (SELECT player FROM players WHERE nick='Jallaman'),
1614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1617 (SELECT player FROM players WHERE nick='Jallaman'),
1619 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1622 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1623 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1625 (SELECT player FROM players WHERE nick='Jallaman'),
1627 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1630 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1633 (SELECT player FROM players WHERE nick='Jallaman'),
1635 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1641 (SELECT player FROM players WHERE nick='Haggar'),
1644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1647 (SELECT player FROM players WHERE nick='Haggar'),
1649 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1655 (SELECT player FROM players WHERE nick='Haggar'),
1657 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1663 (SELECT player FROM players WHERE nick='Haggar'),
1665 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1668 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1671 (SELECT player FROM players WHERE nick='T|na'),
1674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1677 (SELECT player FROM players WHERE nick='T|na'),
1679 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1682 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1683 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1685 (SELECT player FROM players WHERE nick='T|na'),
1687 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1690 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1691 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1693 (SELECT player FROM players WHERE nick='T|na'),
1695 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1698 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1701 (SELECT player FROM players WHERE nick='OJK'),
1704 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1705 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1707 (SELECT player FROM players WHERE nick='OJK'),
1709 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1712 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1713 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1715 (SELECT player FROM players WHERE nick='OJK'),
1717 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1723 (SELECT player FROM players WHERE nick='OJK'),
1725 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1728 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1731 (SELECT player FROM players WHERE nick='RiChY'),
1734 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1735 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1737 (SELECT player FROM players WHERE nick='RiChY'),
1739 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1742 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1745 (SELECT player FROM players WHERE nick='RiChY'),
1747 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1751 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1753 (SELECT player FROM players WHERE nick='RiChY'),
1755 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1758 INSERT INTO groups (tournament, round, parallel) VALUES (
1759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1761 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1762 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1764 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1766 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1769 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1771 UPDATE rounds SET randomsongs=2 WHERE
1772 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1774 UPDATE rounds SET chosensongs=1 WHERE
1775 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1777 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1780 (SELECT player FROM players WHERE nick='Mulefisk'),
1783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1786 (SELECT player FROM players WHERE nick='Mulefisk'),
1788 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1794 (SELECT player FROM players WHERE nick='Mulefisk'),
1796 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1799 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1800 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1802 (SELECT player FROM players WHERE nick='Mulefisk'),
1804 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1807 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1810 (SELECT player FROM players WHERE nick='Stream'),
1813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1816 (SELECT player FROM players WHERE nick='Stream'),
1818 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1824 (SELECT player FROM players WHERE nick='Stream'),
1826 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1829 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1830 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1832 (SELECT player FROM players WHERE nick='Stream'),
1834 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1840 (SELECT player FROM players WHERE nick='Electus'),
1843 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1846 (SELECT player FROM players WHERE nick='Electus'),
1848 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1851 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1854 (SELECT player FROM players WHERE nick='Electus'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1862 (SELECT player FROM players WHERE nick='Electus'),
1864 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1867 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1870 (SELECT player FROM players WHERE nick='Spinnvill'),
1873 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1874 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1876 (SELECT player FROM players WHERE nick='Spinnvill'),
1878 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1881 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1882 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1884 (SELECT player FROM players WHERE nick='Spinnvill'),
1886 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1889 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1890 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1892 (SELECT player FROM players WHERE nick='Spinnvill'),
1894 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1900 (SELECT player FROM players WHERE nick='Oliyzia'),
1903 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1904 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1906 (SELECT player FROM players WHERE nick='Oliyzia'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1911 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1912 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1914 (SELECT player FROM players WHERE nick='Oliyzia'),
1916 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1919 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1922 (SELECT player FROM players WHERE nick='Oliyzia'),
1924 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1927 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1930 (SELECT player FROM players WHERE nick='Tom'),
1933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1936 (SELECT player FROM players WHERE nick='Tom'),
1938 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1944 (SELECT player FROM players WHERE nick='Tom'),
1946 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1949 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1950 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1952 (SELECT player FROM players WHERE nick='Tom'),
1954 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1957 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1962 INSERT INTO groups (tournament, round, parallel) VALUES (
1963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1965 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1968 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1970 UPDATE rounds SET randomsongs=1 WHERE
1971 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1973 UPDATE rounds SET chosensongs=1 WHERE
1974 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
1976 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1979 (SELECT player FROM players WHERE nick='Oliyzia'),
1982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1985 (SELECT player FROM players WHERE nick='Oliyzia'),
1987 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1990 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1991 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
1993 (SELECT player FROM players WHERE nick='Oliyzia'),
1995 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1998 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2001 (SELECT player FROM players WHERE nick='Haggar'),
2004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2007 (SELECT player FROM players WHERE nick='Haggar'),
2009 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2012 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2015 (SELECT player FROM players WHERE nick='Haggar'),
2017 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2020 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2021 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2023 (SELECT player FROM players WHERE nick='Snofox'),
2026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2027 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2029 (SELECT player FROM players WHERE nick='Snofox'),
2031 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2037 (SELECT player FROM players WHERE nick='Snofox'),
2039 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2045 (SELECT player FROM players WHERE nick='RiChY'),
2048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2051 (SELECT player FROM players WHERE nick='RiChY'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2059 (SELECT player FROM players WHERE nick='RiChY'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2067 (SELECT player FROM players WHERE nick='Mulefisk'),
2070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2071 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2073 (SELECT player FROM players WHERE nick='Mulefisk'),
2075 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2079 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2081 (SELECT player FROM players WHERE nick='Mulefisk'),
2083 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2086 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2087 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2089 (SELECT player FROM players WHERE nick='DufF'),
2092 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2093 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2095 (SELECT player FROM players WHERE nick='DufF'),
2097 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2100 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2101 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2103 (SELECT player FROM players WHERE nick='DufF'),
2105 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2111 (SELECT player FROM players WHERE nick='OJK'),
2114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2115 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2117 (SELECT player FROM players WHERE nick='OJK'),
2119 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2125 (SELECT player FROM players WHERE nick='OJK'),
2127 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2133 (SELECT player FROM players WHERE nick='Snute'),
2136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2139 (SELECT player FROM players WHERE nick='Snute'),
2141 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2147 (SELECT player FROM players WHERE nick='Snute'),
2149 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2152 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2155 (SELECT player FROM players WHERE nick='Tom'),
2158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2161 (SELECT player FROM players WHERE nick='Tom'),
2163 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2167 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2169 (SELECT player FROM players WHERE nick='Tom'),
2171 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2174 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2179 INSERT INTO groups (tournament, round, parallel) VALUES (
2180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2182 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2185 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
2187 UPDATE rounds SET randomsongs=1 WHERE
2188 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2190 UPDATE rounds SET chosensongs=1 WHERE
2191 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2193 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2196 (SELECT player FROM players WHERE nick='DufF'),
2199 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2202 (SELECT player FROM players WHERE nick='DufF'),
2204 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2207 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2210 (SELECT player FROM players WHERE nick='DufF'),
2212 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2215 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2218 (SELECT player FROM players WHERE nick='Oliyzia'),
2221 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2224 (SELECT player FROM players WHERE nick='Oliyzia'),
2226 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2232 (SELECT player FROM players WHERE nick='Oliyzia'),
2234 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2237 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2240 (SELECT player FROM players WHERE nick='OJK'),
2243 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2244 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2246 (SELECT player FROM players WHERE nick='OJK'),
2248 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2251 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2252 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2254 (SELECT player FROM players WHERE nick='OJK'),
2256 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2259 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2262 (SELECT player FROM players WHERE nick='RiChY'),
2265 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2268 (SELECT player FROM players WHERE nick='RiChY'),
2270 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2273 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2276 (SELECT player FROM players WHERE nick='RiChY'),
2278 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2281 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2284 (SELECT player FROM players WHERE nick='Tom'),
2287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2290 (SELECT player FROM players WHERE nick='Tom'),
2292 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2298 (SELECT player FROM players WHERE nick='Tom'),
2300 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
2303 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2306 (SELECT player FROM players WHERE nick='Snofox'),
2309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2312 (SELECT player FROM players WHERE nick='Snofox'),
2314 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2320 (SELECT player FROM players WHERE nick='Snofox'),
2322 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2325 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2328 (SELECT player FROM players WHERE nick='Snute'),
2331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2334 (SELECT player FROM players WHERE nick='Snute'),
2336 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
2339 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2342 (SELECT player FROM players WHERE nick='Snute'),
2344 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2347 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2352 INSERT INTO groups (tournament, round, parallel) VALUES (
2353 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2355 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2358 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2360 UPDATE rounds SET randomsongs=1 WHERE
2361 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2363 UPDATE rounds SET chosensongs=1 WHERE
2364 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2369 (SELECT player FROM players WHERE nick='Oliyzia'),
2372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2375 (SELECT player FROM players WHERE nick='Oliyzia'),
2377 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2383 (SELECT player FROM players WHERE nick='Oliyzia'),
2385 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2388 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2391 (SELECT player FROM players WHERE nick='Tom'),
2394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2397 (SELECT player FROM players WHERE nick='Tom'),
2399 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2405 (SELECT player FROM players WHERE nick='Tom'),
2407 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2410 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2413 (SELECT player FROM players WHERE nick='Snute'),
2416 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2419 (SELECT player FROM players WHERE nick='Snute'),
2421 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2424 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2427 (SELECT player FROM players WHERE nick='Snute'),
2429 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2432 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2433 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2435 (SELECT player FROM players WHERE nick='DufF'),
2438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2441 (SELECT player FROM players WHERE nick='DufF'),
2443 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2446 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2447 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2449 (SELECT player FROM players WHERE nick='DufF'),
2451 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2454 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2455 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2457 (SELECT player FROM players WHERE nick='OJK'),
2460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2463 (SELECT player FROM players WHERE nick='OJK'),
2465 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2471 (SELECT player FROM players WHERE nick='OJK'),
2473 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2476 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2481 INSERT INTO groups (tournament, round, parallel) VALUES (
2482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2484 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2487 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
2489 UPDATE rounds SET randomsongs=1 WHERE
2490 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2492 UPDATE rounds SET chosensongs=1 WHERE
2493 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2498 (SELECT player FROM players WHERE nick='OJK'),
2501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2504 (SELECT player FROM players WHERE nick='OJK'),
2506 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2512 (SELECT player FROM players WHERE nick='OJK'),
2514 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2517 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2520 (SELECT player FROM players WHERE nick='Oliyzia'),
2523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2526 (SELECT player FROM players WHERE nick='Oliyzia'),
2528 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2534 (SELECT player FROM players WHERE nick='Oliyzia'),
2536 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2539 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2542 (SELECT player FROM players WHERE nick='DufF'),
2545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2548 (SELECT player FROM players WHERE nick='DufF'),
2550 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2556 (SELECT player FROM players WHERE nick='DufF'),
2558 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2561 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2564 (SELECT player FROM players WHERE nick='Snute'),
2567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2570 (SELECT player FROM players WHERE nick='Snute'),
2572 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
2575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2578 (SELECT player FROM players WHERE nick='Snute'),
2580 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2583 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2588 INSERT INTO groups (tournament, round, parallel) VALUES (
2589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2591 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2592 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2594 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2596 UPDATE rounds SET randomsongs=1 WHERE
2597 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2599 UPDATE rounds SET chosensongs=1 WHERE
2600 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2605 (SELECT player FROM players WHERE nick='OJK'),
2608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2611 (SELECT player FROM players WHERE nick='OJK'),
2613 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2619 (SELECT player FROM players WHERE nick='OJK'),
2621 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2624 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2627 (SELECT player FROM players WHERE nick='Snute'),
2630 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2633 (SELECT player FROM players WHERE nick='Snute'),
2635 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2641 (SELECT player FROM players WHERE nick='Snute'),
2643 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2649 (SELECT player FROM players WHERE nick='DufF'),
2652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2655 (SELECT player FROM players WHERE nick='DufF'),
2657 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2663 (SELECT player FROM players WHERE nick='DufF'),
2665 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2668 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2673 INSERT INTO groups (tournament, round, parallel) VALUES (
2674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2676 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2679 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
2681 UPDATE rounds SET randomsongs=1 WHERE
2682 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2684 UPDATE rounds SET chosensongs=1 WHERE
2685 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND
2687 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2690 (SELECT player FROM players WHERE nick='DufF'),
2693 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2694 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2696 (SELECT player FROM players WHERE nick='DufF'),
2698 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2701 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2702 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2704 (SELECT player FROM players WHERE nick='DufF'),
2706 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2709 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2710 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2712 (SELECT player FROM players WHERE nick='Snute'),
2715 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2716 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2718 (SELECT player FROM players WHERE nick='Snute'),
2720 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
2726 (SELECT player FROM players WHERE nick='Snute'),
2728 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),