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 3' 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 3' 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, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
28 (SELECT player FROM players WHERE nick='Daniil'),
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 3' 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, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
40 (SELECT player FROM players WHERE nick='Oliyzia'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
46 (SELECT player FROM players WHERE nick='Telc'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
52 (SELECT player FROM players WHERE nick='Yeye'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
58 (SELECT player FROM players WHERE nick='Slusk'),
60 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 );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='Draconia'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='kjmcw'),
72 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 );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
76 (SELECT player FROM players WHERE nick='Mulefisk'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='Lejordet'),
84 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 );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='Vampyro'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='Matsi'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Havok'),
102 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 );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='Smiph'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Suspect' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Suspect' NOT IN ( SELECT nick FROM players );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
112 (SELECT player FROM players WHERE nick='Suspect'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
118 (SELECT player FROM players WHERE nick='Purity'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
124 (SELECT player FROM players WHERE nick='Spinnvill'),
126 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
131 INSERT INTO groups (tournament, round, parallel) VALUES (
132 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
134 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
137 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
139 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
142 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
144 UPDATE rounds SET randomsongs=2 WHERE
145 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
147 UPDATE rounds SET chosensongs=1 WHERE
148 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
150 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
153 (SELECT player FROM players WHERE nick='Smiph'),
156 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
159 (SELECT player FROM players WHERE nick='Smiph'),
161 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
164 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
167 (SELECT player FROM players WHERE nick='Smiph'),
169 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
173 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
175 (SELECT player FROM players WHERE nick='Smiph'),
177 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
180 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
181 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
183 (SELECT player FROM players WHERE nick='Lejordet'),
186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
189 (SELECT player FROM players WHERE nick='Lejordet'),
191 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
197 (SELECT player FROM players WHERE nick='Lejordet'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
205 (SELECT player FROM players WHERE nick='Lejordet'),
207 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
211 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
213 (SELECT player FROM players WHERE nick='Draconia'),
216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
219 (SELECT player FROM players WHERE nick='Draconia'),
221 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
227 (SELECT player FROM players WHERE nick='Draconia'),
229 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
235 (SELECT player FROM players WHERE nick='Draconia'),
237 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
243 (SELECT player FROM players WHERE nick='DufF'),
246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
249 (SELECT player FROM players WHERE nick='DufF'),
251 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
257 (SELECT player FROM players WHERE nick='DufF'),
259 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
265 (SELECT player FROM players WHERE nick='DufF'),
267 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
270 INSERT INTO groups (tournament, round, parallel) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
276 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
278 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
281 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
283 UPDATE rounds SET randomsongs=2 WHERE
284 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
286 UPDATE rounds SET chosensongs=1 WHERE
287 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
289 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
292 (SELECT player FROM players WHERE nick='Purity'),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
298 (SELECT player FROM players WHERE nick='Purity'),
300 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
306 (SELECT player FROM players WHERE nick='Purity'),
308 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
311 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
312 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
314 (SELECT player FROM players WHERE nick='Purity'),
316 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
319 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
322 (SELECT player FROM players WHERE nick='Mulefisk'),
325 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
328 (SELECT player FROM players WHERE nick='Mulefisk'),
330 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
333 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
336 (SELECT player FROM players WHERE nick='Mulefisk'),
338 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
344 (SELECT player FROM players WHERE nick='Mulefisk'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
352 (SELECT player FROM players WHERE nick='Havok'),
355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
358 (SELECT player FROM players WHERE nick='Havok'),
360 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
366 (SELECT player FROM players WHERE nick='Havok'),
368 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
374 (SELECT player FROM players WHERE nick='Havok'),
376 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
382 (SELECT player FROM players WHERE nick='Oliyzia'),
385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
388 (SELECT player FROM players WHERE nick='Oliyzia'),
390 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
396 (SELECT player FROM players WHERE nick='Oliyzia'),
398 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
401 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
404 (SELECT player FROM players WHERE nick='Oliyzia'),
406 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
409 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
412 (SELECT player FROM players WHERE nick='Daniil'),
415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
418 (SELECT player FROM players WHERE nick='Daniil'),
420 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
426 (SELECT player FROM players WHERE nick='Daniil'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
434 (SELECT player FROM players WHERE nick='Daniil'),
436 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
439 INSERT INTO groups (tournament, round, parallel) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
442 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
443 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
445 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
447 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
450 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
452 UPDATE rounds SET randomsongs=2 WHERE
453 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
455 UPDATE rounds SET chosensongs=1 WHERE
456 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
458 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
459 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
461 (SELECT player FROM players WHERE nick='Spinnvill'),
464 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
467 (SELECT player FROM players WHERE nick='Spinnvill'),
469 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
472 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
473 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
475 (SELECT player FROM players WHERE nick='Spinnvill'),
477 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
480 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
483 (SELECT player FROM players WHERE nick='Spinnvill'),
485 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
488 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
489 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
491 (SELECT player FROM players WHERE nick='Matsi'),
494 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
497 (SELECT player FROM players WHERE nick='Matsi'),
499 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
502 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
503 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
505 (SELECT player FROM players WHERE nick='Matsi'),
507 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
511 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
513 (SELECT player FROM players WHERE nick='Matsi'),
515 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
518 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
521 (SELECT player FROM players WHERE nick='kjmcw'),
524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
527 (SELECT player FROM players WHERE nick='kjmcw'),
529 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
532 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
535 (SELECT player FROM players WHERE nick='kjmcw'),
537 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
543 (SELECT player FROM players WHERE nick='kjmcw'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
548 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
551 (SELECT player FROM players WHERE nick='Slusk'),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
557 (SELECT player FROM players WHERE nick='Slusk'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
565 (SELECT player FROM players WHERE nick='Slusk'),
567 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
570 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
573 (SELECT player FROM players WHERE nick='Slusk'),
575 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
581 (SELECT player FROM players WHERE nick='Tom'),
584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
587 (SELECT player FROM players WHERE nick='Tom'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
595 (SELECT player FROM players WHERE nick='Tom'),
597 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
603 (SELECT player FROM players WHERE nick='Tom'),
605 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
608 INSERT INTO groups (tournament, round, parallel) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
611 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
612 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
614 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
616 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
619 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
621 UPDATE rounds SET randomsongs=2 WHERE
622 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
624 UPDATE rounds SET chosensongs=1 WHERE
625 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
627 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
630 (SELECT player FROM players WHERE nick='Suspect'),
633 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
636 (SELECT player FROM players WHERE nick='Suspect'),
638 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
641 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
644 (SELECT player FROM players WHERE nick='Suspect'),
646 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
649 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
650 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
652 (SELECT player FROM players WHERE nick='Suspect'),
654 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
657 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
660 (SELECT player FROM players WHERE nick='Vampyro'),
663 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
666 (SELECT player FROM players WHERE nick='Vampyro'),
668 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
671 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
672 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
674 (SELECT player FROM players WHERE nick='Vampyro'),
676 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
679 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
680 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
682 (SELECT player FROM players WHERE nick='Vampyro'),
684 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
687 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
690 (SELECT player FROM players WHERE nick='Yeye'),
693 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
694 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
696 (SELECT player FROM players WHERE nick='Yeye'),
698 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
701 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
702 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
704 (SELECT player FROM players WHERE nick='Yeye'),
706 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
709 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
710 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
712 (SELECT player FROM players WHERE nick='Yeye'),
714 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
717 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
718 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
720 (SELECT player FROM players WHERE nick='Telc'),
723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
726 (SELECT player FROM players WHERE nick='Telc'),
728 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
732 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
734 (SELECT player FROM players WHERE nick='Telc'),
736 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
739 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
740 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
742 (SELECT player FROM players WHERE nick='Telc'),
744 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
747 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
748 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
750 (SELECT player FROM players WHERE nick='Snute'),
753 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
756 (SELECT player FROM players WHERE nick='Snute'),
758 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
761 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
762 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
764 (SELECT player FROM players WHERE nick='Snute'),
766 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
769 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
770 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
772 (SELECT player FROM players WHERE nick='Snute'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
777 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
782 INSERT INTO groups (tournament, round, parallel) VALUES (
783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
785 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
786 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
788 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
790 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
793 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
795 UPDATE rounds SET randomsongs=2 WHERE
796 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
798 UPDATE rounds SET chosensongs=1 WHERE
799 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
801 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
804 (SELECT player FROM players WHERE nick='Slusk'),
807 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
810 (SELECT player FROM players WHERE nick='Slusk'),
812 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
815 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
818 (SELECT player FROM players WHERE nick='Slusk'),
820 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
823 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
824 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
826 (SELECT player FROM players WHERE nick='Slusk'),
828 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
831 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
834 (SELECT player FROM players WHERE nick='kjmcw'),
837 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
840 (SELECT player FROM players WHERE nick='kjmcw'),
842 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
845 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
848 (SELECT player FROM players WHERE nick='kjmcw'),
850 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
853 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
856 (SELECT player FROM players WHERE nick='kjmcw'),
858 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
861 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
864 (SELECT player FROM players WHERE nick='DufF'),
867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
870 (SELECT player FROM players WHERE nick='DufF'),
872 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
878 (SELECT player FROM players WHERE nick='DufF'),
880 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
886 (SELECT player FROM players WHERE nick='DufF'),
888 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
894 (SELECT player FROM players WHERE nick='Snute'),
897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
900 (SELECT player FROM players WHERE nick='Snute'),
902 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
908 (SELECT player FROM players WHERE nick='Snute'),
910 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
916 (SELECT player FROM players WHERE nick='Snute'),
918 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
921 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
924 (SELECT player FROM players WHERE nick='Daniil'),
927 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
930 (SELECT player FROM players WHERE nick='Daniil'),
932 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
935 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
936 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
938 (SELECT player FROM players WHERE nick='Daniil'),
940 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
946 (SELECT player FROM players WHERE nick='Daniil'),
948 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
951 INSERT INTO groups (tournament, round, parallel) VALUES (
952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
954 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
955 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
957 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
959 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
962 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
964 UPDATE rounds SET randomsongs=2 WHERE
965 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
967 UPDATE rounds SET chosensongs=1 WHERE
968 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
970 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
973 (SELECT player FROM players WHERE nick='Mulefisk'),
976 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
979 (SELECT player FROM players WHERE nick='Mulefisk'),
981 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
984 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
985 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
987 (SELECT player FROM players WHERE nick='Mulefisk'),
989 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
992 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
995 (SELECT player FROM players WHERE nick='Mulefisk'),
997 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1003 (SELECT player FROM players WHERE nick='Telc'),
1006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1009 (SELECT player FROM players WHERE nick='Telc'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1017 (SELECT player FROM players WHERE nick='Telc'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1022 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1025 (SELECT player FROM players WHERE nick='Telc'),
1027 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1030 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1031 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1033 (SELECT player FROM players WHERE nick='Oliyzia'),
1036 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1039 (SELECT player FROM players WHERE nick='Oliyzia'),
1041 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1044 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1045 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1047 (SELECT player FROM players WHERE nick='Oliyzia'),
1049 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1052 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1053 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1055 (SELECT player FROM players WHERE nick='Oliyzia'),
1057 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1060 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1063 (SELECT player FROM players WHERE nick='Yeye'),
1066 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1069 (SELECT player FROM players WHERE nick='Yeye'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1074 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1077 (SELECT player FROM players WHERE nick='Yeye'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1082 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1083 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1085 (SELECT player FROM players WHERE nick='Yeye'),
1087 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1090 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1091 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1093 (SELECT player FROM players WHERE nick='Tom'),
1096 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1099 (SELECT player FROM players WHERE nick='Tom'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1104 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1107 (SELECT player FROM players WHERE nick='Tom'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1112 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1115 (SELECT player FROM players WHERE nick='Tom'),
1117 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1123 (SELECT player FROM players WHERE nick='Draconia'),
1126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1129 (SELECT player FROM players WHERE nick='Draconia'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1137 (SELECT player FROM players WHERE nick='Draconia'),
1139 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1142 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1145 (SELECT player FROM players WHERE nick='Draconia'),
1147 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1150 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1155 INSERT INTO groups (tournament, round, parallel) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1158 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1161 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
1163 UPDATE rounds SET randomsongs=1 WHERE
1164 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1166 UPDATE rounds SET chosensongs=1 WHERE
1167 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1169 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1172 (SELECT player FROM players WHERE nick='Daniil'),
1175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1178 (SELECT player FROM players WHERE nick='Daniil'),
1180 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1186 (SELECT player FROM players WHERE nick='Daniil'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1191 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1194 (SELECT player FROM players WHERE nick='Telc'),
1197 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1200 (SELECT player FROM players WHERE nick='Telc'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1205 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1208 (SELECT player FROM players WHERE nick='Telc'),
1210 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1213 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1216 (SELECT player FROM players WHERE nick='DufF'),
1219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1222 (SELECT player FROM players WHERE nick='DufF'),
1224 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1230 (SELECT player FROM players WHERE nick='DufF'),
1232 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1235 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1238 (SELECT player FROM players WHERE nick='Oliyzia'),
1241 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1244 (SELECT player FROM players WHERE nick='Oliyzia'),
1246 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1249 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1250 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1252 (SELECT player FROM players WHERE nick='Oliyzia'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1257 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1260 (SELECT player FROM players WHERE nick='Snute'),
1263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1266 (SELECT player FROM players WHERE nick='Snute'),
1268 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1274 (SELECT player FROM players WHERE nick='Snute'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1279 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1282 (SELECT player FROM players WHERE nick='Tom'),
1285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1286 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1288 (SELECT player FROM players WHERE nick='Tom'),
1290 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1294 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1296 (SELECT player FROM players WHERE nick='Tom'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1301 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1306 INSERT INTO groups (tournament, round, parallel) VALUES (
1307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1309 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1312 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
1314 UPDATE rounds SET randomsongs=1 WHERE
1315 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1317 UPDATE rounds SET chosensongs=1 WHERE
1318 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1320 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1323 (SELECT player FROM players WHERE nick='Oliyzia'),
1326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1329 (SELECT player FROM players WHERE nick='Oliyzia'),
1331 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1337 (SELECT player FROM players WHERE nick='Oliyzia'),
1339 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1342 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1345 (SELECT player FROM players WHERE nick='DufF'),
1348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1351 (SELECT player FROM players WHERE nick='DufF'),
1353 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1359 (SELECT player FROM players WHERE nick='DufF'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1367 (SELECT player FROM players WHERE nick='Daniil'),
1370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1371 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1373 (SELECT player FROM players WHERE nick='Daniil'),
1375 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1378 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1381 (SELECT player FROM players WHERE nick='Daniil'),
1383 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1386 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1387 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1389 (SELECT player FROM players WHERE nick='Tom'),
1392 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1393 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1395 (SELECT player FROM players WHERE nick='Tom'),
1397 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1400 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1401 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1403 (SELECT player FROM players WHERE nick='Tom'),
1405 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1408 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1409 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1411 (SELECT player FROM players WHERE nick='Snute'),
1414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1417 (SELECT player FROM players WHERE nick='Snute'),
1419 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1425 (SELECT player FROM players WHERE nick='Snute'),
1427 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1430 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1435 INSERT INTO groups (tournament, round, parallel) VALUES (
1436 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1438 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
1443 UPDATE rounds SET randomsongs=1 WHERE
1444 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1446 UPDATE rounds SET chosensongs=1 WHERE
1447 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1449 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1452 (SELECT player FROM players WHERE nick='DufF'),
1455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1458 (SELECT player FROM players WHERE nick='DufF'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1466 (SELECT player FROM players WHERE nick='DufF'),
1468 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1471 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1472 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1474 (SELECT player FROM players WHERE nick='Daniil'),
1477 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1480 (SELECT player FROM players WHERE nick='Daniil'),
1482 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1488 (SELECT player FROM players WHERE nick='Daniil'),
1490 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1496 (SELECT player FROM players WHERE nick='Tom'),
1499 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1502 (SELECT player FROM players WHERE nick='Tom'),
1504 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1510 (SELECT player FROM players WHERE nick='Tom'),
1512 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1515 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1518 (SELECT player FROM players WHERE nick='Snute'),
1521 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1524 (SELECT player FROM players WHERE nick='Snute'),
1526 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1532 (SELECT player FROM players WHERE nick='Snute'),
1534 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1537 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1542 INSERT INTO groups (tournament, round, parallel) VALUES (
1543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1545 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1548 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1550 UPDATE rounds SET randomsongs=1 WHERE
1551 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1553 UPDATE rounds SET chosensongs=1 WHERE
1554 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1556 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1557 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1559 (SELECT player FROM players WHERE nick='Daniil'),
1562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1563 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1565 (SELECT player FROM players WHERE nick='Daniil'),
1567 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1570 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1571 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1573 (SELECT player FROM players WHERE nick='Daniil'),
1575 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1581 (SELECT player FROM players WHERE nick='Snute'),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1587 (SELECT player FROM players WHERE nick='Snute'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1595 (SELECT player FROM players WHERE nick='Snute'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1600 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1603 (SELECT player FROM players WHERE nick='Tom'),
1606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1609 (SELECT player FROM players WHERE nick='Tom'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1617 (SELECT player FROM players WHERE nick='Tom'),
1619 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1622 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1627 INSERT INTO groups (tournament, round, parallel) VALUES (
1628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1630 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1633 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
1635 UPDATE rounds SET randomsongs=1 WHERE
1636 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1638 UPDATE rounds SET chosensongs=1 WHERE
1639 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1641 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1644 (SELECT player FROM players WHERE nick='Tom'),
1647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1650 (SELECT player FROM players WHERE nick='Tom'),
1652 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1655 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1658 (SELECT player FROM players WHERE nick='Tom'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1663 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1666 (SELECT player FROM players WHERE nick='Snute'),
1669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1672 (SELECT player FROM players WHERE nick='Snute'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1680 (SELECT player FROM players WHERE nick='Snute'),
1682 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),