2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
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, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
16 (SELECT player FROM players WHERE nick='Tom'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
28 (SELECT player FROM players WHERE nick='Th0rny'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
34 (SELECT player FROM players WHERE nick='DufF'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
40 (SELECT player FROM players WHERE nick='Draconia'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
46 (SELECT player FROM players WHERE nick='Daniil'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
52 (SELECT player FROM players WHERE nick='Slusk'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
58 (SELECT player FROM players WHERE nick='Telc'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='RiChY'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='Yeye'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
76 (SELECT player FROM players WHERE nick='kjmcw'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='Mulefisk'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='Lejordet'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='Havok'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Oliyzia'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='Vampyro'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'TheKnight' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'TheKnight' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
112 (SELECT player FROM players WHERE nick='TheKnight'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' 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' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
118 (SELECT player FROM players WHERE nick='Smiph'),
120 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
125 INSERT INTO groups (tournament, round, parallel) VALUES (
126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
128 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
129 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
131 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
133 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
136 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
138 UPDATE rounds SET randomsongs=2 WHERE
139 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
141 UPDATE rounds SET chosensongs=1 WHERE
142 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
144 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
147 (SELECT player FROM players WHERE nick='Oliyzia'),
150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
153 (SELECT player FROM players WHERE nick='Oliyzia'),
155 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
161 (SELECT player FROM players WHERE nick='Oliyzia'),
163 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
167 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
169 (SELECT player FROM players WHERE nick='Oliyzia'),
171 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
174 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
177 (SELECT player FROM players WHERE nick='Th0rny'),
180 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
181 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
183 (SELECT player FROM players WHERE nick='Th0rny'),
185 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
191 (SELECT player FROM players WHERE nick='Th0rny'),
193 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
196 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
197 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
199 (SELECT player FROM players WHERE nick='Th0rny'),
201 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
204 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
207 (SELECT player FROM players WHERE nick='kjmcw'),
210 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
211 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
213 (SELECT player FROM players WHERE nick='kjmcw'),
215 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
218 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
219 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
221 (SELECT player FROM players WHERE nick='kjmcw'),
223 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
226 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
227 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
229 (SELECT player FROM players WHERE nick='kjmcw'),
231 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
234 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
237 (SELECT player FROM players WHERE nick='DufF'),
240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
243 (SELECT player FROM players WHERE nick='DufF'),
245 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
251 (SELECT player FROM players WHERE nick='DufF'),
253 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
259 (SELECT player FROM players WHERE nick='DufF'),
261 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
264 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
267 (SELECT player FROM players WHERE nick='Draconia'),
270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
273 (SELECT player FROM players WHERE nick='Draconia'),
275 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
281 (SELECT player FROM players WHERE nick='Draconia'),
283 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
289 (SELECT player FROM players WHERE nick='Draconia'),
291 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
294 INSERT INTO groups (tournament, round, parallel) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
297 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
298 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
300 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
302 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
305 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
307 UPDATE rounds SET randomsongs=2 WHERE
308 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
310 UPDATE rounds SET chosensongs=1 WHERE
311 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
313 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
316 (SELECT player FROM players WHERE nick='Daniil'),
319 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
322 (SELECT player FROM players WHERE nick='Daniil'),
324 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
327 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
330 (SELECT player FROM players WHERE nick='Daniil'),
332 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
335 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
336 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
338 (SELECT player FROM players WHERE nick='Daniil'),
340 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
343 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
346 (SELECT player FROM players WHERE nick='Vampyro'),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
352 (SELECT player FROM players WHERE nick='Vampyro'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
360 (SELECT player FROM players WHERE nick='Vampyro'),
362 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
365 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
368 (SELECT player FROM players WHERE nick='Vampyro'),
370 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
373 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
376 (SELECT player FROM players WHERE nick='Havok'),
379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
382 (SELECT player FROM players WHERE nick='Havok'),
384 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
390 (SELECT player FROM players WHERE nick='Havok'),
392 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
395 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
396 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
398 (SELECT player FROM players WHERE nick='Havok'),
400 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
406 (SELECT player FROM players WHERE nick='Slusk'),
409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
412 (SELECT player FROM players WHERE nick='Slusk'),
414 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
420 (SELECT player FROM players WHERE nick='Slusk'),
422 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
425 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
428 (SELECT player FROM players WHERE nick='Slusk'),
430 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
433 INSERT INTO groups (tournament, round, parallel) VALUES (
434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
436 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
439 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
441 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
444 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
446 UPDATE rounds SET randomsongs=2 WHERE
447 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
449 UPDATE rounds SET chosensongs=1 WHERE
450 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
452 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
455 (SELECT player FROM players WHERE nick='Telc'),
458 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
459 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
461 (SELECT player FROM players WHERE nick='Telc'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
466 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
467 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
469 (SELECT player FROM players WHERE nick='Telc'),
471 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
475 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
477 (SELECT player FROM players WHERE nick='Telc'),
479 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
485 (SELECT player FROM players WHERE nick='Yeye'),
488 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
489 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
491 (SELECT player FROM players WHERE nick='Yeye'),
493 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
499 (SELECT player FROM players WHERE nick='Yeye'),
501 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
504 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
507 (SELECT player FROM players WHERE nick='Yeye'),
509 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
512 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
515 (SELECT player FROM players WHERE nick='Lejordet'),
518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
521 (SELECT player FROM players WHERE nick='Lejordet'),
523 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
527 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
529 (SELECT player FROM players WHERE nick='Lejordet'),
531 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
534 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
535 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
537 (SELECT player FROM players WHERE nick='Lejordet'),
539 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
542 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
545 (SELECT player FROM players WHERE nick='TheKnight'),
548 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
551 (SELECT player FROM players WHERE nick='TheKnight'),
553 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
556 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
557 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
559 (SELECT player FROM players WHERE nick='TheKnight'),
561 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
564 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
565 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
567 (SELECT player FROM players WHERE nick='TheKnight'),
569 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
572 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
575 (SELECT player FROM players WHERE nick='Snute'),
578 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
581 (SELECT player FROM players WHERE nick='Snute'),
583 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
587 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
589 (SELECT player FROM players WHERE nick='Snute'),
591 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
597 (SELECT player FROM players WHERE nick='Snute'),
599 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
602 INSERT INTO groups (tournament, round, parallel) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
605 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
606 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
608 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
610 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
613 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
615 UPDATE rounds SET randomsongs=2 WHERE
616 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
618 UPDATE rounds SET chosensongs=1 WHERE
619 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
621 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
624 (SELECT player FROM players WHERE nick='RiChY'),
627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
630 (SELECT player FROM players WHERE nick='RiChY'),
632 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
638 (SELECT player FROM players WHERE nick='RiChY'),
640 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
646 (SELECT player FROM players WHERE nick='RiChY'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
654 (SELECT player FROM players WHERE nick='Mulefisk'),
657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
660 (SELECT player FROM players WHERE nick='Mulefisk'),
662 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
668 (SELECT player FROM players WHERE nick='Mulefisk'),
670 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
673 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
676 (SELECT player FROM players WHERE nick='Mulefisk'),
678 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
681 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
684 (SELECT player FROM players WHERE nick='Smiph'),
687 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
690 (SELECT player FROM players WHERE nick='Smiph'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
695 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
698 (SELECT player FROM players WHERE nick='Smiph'),
700 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
703 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
706 (SELECT player FROM players WHERE nick='Smiph'),
708 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
711 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
714 (SELECT player FROM players WHERE nick='Tom'),
717 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
718 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
720 (SELECT player FROM players WHERE nick='Tom'),
722 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
725 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
728 (SELECT player FROM players WHERE nick='Tom'),
730 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
733 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
736 (SELECT player FROM players WHERE nick='Tom'),
738 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
741 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
746 INSERT INTO groups (tournament, round, parallel) VALUES (
747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
749 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
752 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
754 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
757 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
759 UPDATE rounds SET randomsongs=2 WHERE
760 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
762 UPDATE rounds SET chosensongs=1 WHERE
763 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
765 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
768 (SELECT player FROM players WHERE nick='Daniil'),
771 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
774 (SELECT player FROM players WHERE nick='Daniil'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
779 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
782 (SELECT player FROM players WHERE nick='Daniil'),
784 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
787 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
790 (SELECT player FROM players WHERE nick='Daniil'),
792 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
798 (SELECT player FROM players WHERE nick='Telc'),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
804 (SELECT player FROM players WHERE nick='Telc'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
812 (SELECT player FROM players WHERE nick='Telc'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
820 (SELECT player FROM players WHERE nick='Telc'),
822 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
828 (SELECT player FROM players WHERE nick='DufF'),
831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
834 (SELECT player FROM players WHERE nick='DufF'),
836 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
839 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
842 (SELECT player FROM players WHERE nick='DufF'),
844 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
847 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
850 (SELECT player FROM players WHERE nick='DufF'),
852 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
855 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
858 (SELECT player FROM players WHERE nick='Yeye'),
861 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
864 (SELECT player FROM players WHERE nick='Yeye'),
866 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
872 (SELECT player FROM players WHERE nick='Yeye'),
874 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
880 (SELECT player FROM players WHERE nick='Yeye'),
882 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
885 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
888 (SELECT player FROM players WHERE nick='Tom'),
891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
894 (SELECT player FROM players WHERE nick='Tom'),
896 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
899 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
902 (SELECT player FROM players WHERE nick='Tom'),
904 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
907 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
908 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
910 (SELECT player FROM players WHERE nick='Tom'),
912 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
915 INSERT INTO groups (tournament, round, parallel) VALUES (
916 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
918 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
919 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
921 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
923 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
924 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
926 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
928 UPDATE rounds SET randomsongs=2 WHERE
929 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
931 UPDATE rounds SET chosensongs=1 WHERE
932 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
934 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
937 (SELECT player FROM players WHERE nick='Draconia'),
940 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
943 (SELECT player FROM players WHERE nick='Draconia'),
945 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
951 (SELECT player FROM players WHERE nick='Draconia'),
953 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
959 (SELECT player FROM players WHERE nick='Draconia'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
964 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
967 (SELECT player FROM players WHERE nick='Slusk'),
970 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
973 (SELECT player FROM players WHERE nick='Slusk'),
975 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
981 (SELECT player FROM players WHERE nick='Slusk'),
983 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
989 (SELECT player FROM players WHERE nick='Slusk'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
994 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
997 (SELECT player FROM players WHERE nick='RiChY'),
1000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1003 (SELECT player FROM players WHERE nick='RiChY'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1008 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1011 (SELECT player FROM players WHERE nick='RiChY'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1016 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1017 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1019 (SELECT player FROM players WHERE nick='RiChY'),
1021 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1024 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1027 (SELECT player FROM players WHERE nick='Snute'),
1030 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1031 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1033 (SELECT player FROM players WHERE nick='Snute'),
1035 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1038 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1039 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1041 (SELECT player FROM players WHERE nick='Snute'),
1043 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1046 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1047 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1049 (SELECT player FROM players WHERE nick='Snute'),
1051 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1055 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1057 (SELECT player FROM players WHERE nick='Th0rny'),
1060 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1063 (SELECT player FROM players WHERE nick='Th0rny'),
1065 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1071 (SELECT player FROM players WHERE nick='Th0rny'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1079 (SELECT player FROM players WHERE nick='Th0rny'),
1081 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1084 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1089 INSERT INTO groups (tournament, round, parallel) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1092 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1093 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1095 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1097 UPDATE rounds SET randomsongs=1 WHERE
1098 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1100 UPDATE rounds SET chosensongs=1 WHERE
1101 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1103 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1106 (SELECT player FROM players WHERE nick='DufF'),
1109 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1112 (SELECT player FROM players WHERE nick='DufF'),
1114 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1120 (SELECT player FROM players WHERE nick='DufF'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1125 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1128 (SELECT player FROM players WHERE nick='Draconia'),
1131 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1132 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1134 (SELECT player FROM players WHERE nick='Draconia'),
1136 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1139 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1142 (SELECT player FROM players WHERE nick='Draconia'),
1144 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1147 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1150 (SELECT player FROM players WHERE nick='Th0rny'),
1153 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1156 (SELECT player FROM players WHERE nick='Th0rny'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1164 (SELECT player FROM players WHERE nick='Th0rny'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1169 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1172 (SELECT player FROM players WHERE nick='Tom'),
1175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1178 (SELECT player FROM players WHERE nick='Tom'),
1180 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1186 (SELECT player FROM players WHERE nick='Tom'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1191 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1194 (SELECT player FROM players WHERE nick='Snute'),
1197 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1200 (SELECT player FROM players WHERE nick='Snute'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1205 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1208 (SELECT player FROM players WHERE nick='Snute'),
1210 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1213 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1218 INSERT INTO groups (tournament, round, parallel) VALUES (
1219 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1221 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1224 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
1226 UPDATE rounds SET randomsongs=1 WHERE
1227 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1229 UPDATE rounds SET chosensongs=1 WHERE
1230 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1232 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1235 (SELECT player FROM players WHERE nick='Draconia'),
1238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1241 (SELECT player FROM players WHERE nick='Draconia'),
1243 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1249 (SELECT player FROM players WHERE nick='Draconia'),
1251 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1254 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1257 (SELECT player FROM players WHERE nick='DufF'),
1260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1263 (SELECT player FROM players WHERE nick='DufF'),
1265 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1271 (SELECT player FROM players WHERE nick='DufF'),
1273 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1279 (SELECT player FROM players WHERE nick='Th0rny'),
1282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1285 (SELECT player FROM players WHERE nick='Th0rny'),
1287 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1293 (SELECT player FROM players WHERE nick='Th0rny'),
1295 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1298 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1301 (SELECT player FROM players WHERE nick='Snute'),
1304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1307 (SELECT player FROM players WHERE nick='Snute'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1315 (SELECT player FROM players WHERE nick='Snute'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1320 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1323 (SELECT player FROM players WHERE nick='Tom'),
1326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1329 (SELECT player FROM players WHERE nick='Tom'),
1331 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
1334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1337 (SELECT player FROM players WHERE nick='Tom'),
1339 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1342 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1347 INSERT INTO groups (tournament, round, parallel) VALUES (
1348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1350 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1353 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
1355 UPDATE rounds SET randomsongs=1 WHERE
1356 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1358 UPDATE rounds SET chosensongs=1 WHERE
1359 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1361 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1364 (SELECT player FROM players WHERE nick='DufF'),
1367 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1368 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1370 (SELECT player FROM players WHERE nick='DufF'),
1372 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
1375 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1376 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1378 (SELECT player FROM players WHERE nick='DufF'),
1380 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1384 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1386 (SELECT player FROM players WHERE nick='Snute'),
1389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1392 (SELECT player FROM players WHERE nick='Snute'),
1394 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
1397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1400 (SELECT player FROM players WHERE nick='Snute'),
1402 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1405 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1408 (SELECT player FROM players WHERE nick='Th0rny'),
1411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1414 (SELECT player FROM players WHERE nick='Th0rny'),
1416 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
1419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1422 (SELECT player FROM players WHERE nick='Th0rny'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1430 (SELECT player FROM players WHERE nick='Tom'),
1433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1436 (SELECT player FROM players WHERE nick='Tom'),
1438 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
1441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1444 (SELECT player FROM players WHERE nick='Tom'),
1446 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1449 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1451 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1454 INSERT INTO groups (tournament, round, parallel) VALUES (
1455 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1457 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
1462 UPDATE rounds SET randomsongs=1 WHERE
1463 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1465 UPDATE rounds SET chosensongs=1 WHERE
1466 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1468 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1471 (SELECT player FROM players WHERE nick='Th0rny'),
1474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1475 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1477 (SELECT player FROM players WHERE nick='Th0rny'),
1479 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1485 (SELECT player FROM players WHERE nick='Th0rny'),
1487 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1490 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1493 (SELECT player FROM players WHERE nick='Snute'),
1496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1499 (SELECT player FROM players WHERE nick='Snute'),
1501 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1504 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1507 (SELECT player FROM players WHERE nick='Snute'),
1509 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1512 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1515 (SELECT player FROM players WHERE nick='Tom'),
1518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1521 (SELECT player FROM players WHERE nick='Tom'),
1523 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1527 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1529 (SELECT player FROM players WHERE nick='Tom'),
1531 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1534 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1539 INSERT INTO groups (tournament, round, parallel) VALUES (
1540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1542 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1545 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
1547 UPDATE rounds SET randomsongs=1 WHERE
1548 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1550 UPDATE rounds SET chosensongs=1 WHERE
1551 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1553 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1556 (SELECT player FROM players WHERE nick='Tom'),
1559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1562 (SELECT player FROM players WHERE nick='Tom'),
1564 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1570 (SELECT player FROM players WHERE nick='Tom'),
1572 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1575 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1578 (SELECT player FROM players WHERE nick='Snute'),
1581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1582 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1584 (SELECT player FROM players WHERE nick='Snute'),
1586 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1589 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1590 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1592 (SELECT player FROM players WHERE nick='Snute'),
1594 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),