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 6' 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 6' 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, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
28 (SELECT player FROM players WHERE nick='Oliyzia'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
34 (SELECT player FROM players WHERE nick='OJK'),
36 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 );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
40 (SELECT player FROM players WHERE nick='DufF'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
46 (SELECT player FROM players WHERE nick='RiChY'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
52 (SELECT player FROM players WHERE nick='Havok'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
58 (SELECT player FROM players WHERE nick='Draconia'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='T|na'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='Telc'),
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 6' 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, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='Smiph'),
84 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 );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='Matsi'),
90 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 );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='Spinnvill'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electus' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Electus'),
102 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 );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='Purity'),
108 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 );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
112 (SELECT player FROM players WHERE nick='kjmcw'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
118 (SELECT player FROM players WHERE nick='Advena'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
124 (SELECT player FROM players WHERE nick='DiJam'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
130 (SELECT player FROM players WHERE nick='Tha Dragon'),
132 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 );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
136 (SELECT player FROM players WHERE nick='Suspect'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nevrosert' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nevrosert' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
142 (SELECT player FROM players WHERE nick='Nevrosert'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Private Ryan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Private Ryan' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
148 (SELECT player FROM players WHERE nick='Private Ryan'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
154 (SELECT player FROM players WHERE nick='Haz'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
160 (SELECT player FROM players WHERE nick='Pfxp'),
162 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
167 INSERT INTO groups (tournament, round, parallel) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
170 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
173 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
175 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
178 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
180 UPDATE rounds SET randomsongs=2 WHERE
181 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
183 UPDATE rounds SET chosensongs=1 WHERE
184 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
189 (SELECT player FROM players WHERE nick='Nevrosert'),
192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
195 (SELECT player FROM players WHERE nick='Nevrosert'),
197 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
203 (SELECT player FROM players WHERE nick='Nevrosert'),
205 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
211 (SELECT player FROM players WHERE nick='Nevrosert'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
216 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
219 (SELECT player FROM players WHERE nick='Tha Dragon'),
222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
225 (SELECT player FROM players WHERE nick='Tha Dragon'),
227 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
233 (SELECT player FROM players WHERE nick='Tha Dragon'),
235 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
241 (SELECT player FROM players WHERE nick='Tha Dragon'),
243 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
249 (SELECT player FROM players WHERE nick='Matsi'),
252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
255 (SELECT player FROM players WHERE nick='Matsi'),
257 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
263 (SELECT player FROM players WHERE nick='Matsi'),
265 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
271 (SELECT player FROM players WHERE nick='Matsi'),
273 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
279 (SELECT player FROM players WHERE nick='Smiph'),
282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
285 (SELECT player FROM players WHERE nick='Smiph'),
287 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
293 (SELECT player FROM players WHERE nick='Smiph'),
295 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
301 (SELECT player FROM players WHERE nick='Smiph'),
303 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
309 (SELECT player FROM players WHERE nick='Tom'),
312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
315 (SELECT player FROM players WHERE nick='Tom'),
317 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
323 (SELECT player FROM players WHERE nick='Tom'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
331 (SELECT player FROM players WHERE nick='Tom'),
333 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
336 INSERT INTO groups (tournament, round, parallel) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
339 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
342 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
344 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
347 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
349 UPDATE rounds SET randomsongs=2 WHERE
350 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
352 UPDATE rounds SET chosensongs=1 WHERE
353 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
358 (SELECT player FROM players WHERE nick='DiJam'),
361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
364 (SELECT player FROM players WHERE nick='DiJam'),
366 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
369 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
372 (SELECT player FROM players WHERE nick='DiJam'),
374 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
377 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
378 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
380 (SELECT player FROM players WHERE nick='DiJam'),
382 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
388 (SELECT player FROM players WHERE nick='Pfxp'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
394 (SELECT player FROM players WHERE nick='Pfxp'),
396 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
402 (SELECT player FROM players WHERE nick='Pfxp'),
404 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
410 (SELECT player FROM players WHERE nick='Pfxp'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
418 (SELECT player FROM players WHERE nick='Mulefisk'),
421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
424 (SELECT player FROM players WHERE nick='Mulefisk'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
432 (SELECT player FROM players WHERE nick='Mulefisk'),
434 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
440 (SELECT player FROM players WHERE nick='Mulefisk'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
448 (SELECT player FROM players WHERE nick='RiChY'),
451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
454 (SELECT player FROM players WHERE nick='RiChY'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
462 (SELECT player FROM players WHERE nick='RiChY'),
464 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
470 (SELECT player FROM players WHERE nick='RiChY'),
472 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
478 (SELECT player FROM players WHERE nick='Snute'),
481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
484 (SELECT player FROM players WHERE nick='Snute'),
486 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
492 (SELECT player FROM players WHERE nick='Snute'),
494 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
500 (SELECT player FROM players WHERE nick='Snute'),
502 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
505 INSERT INTO groups (tournament, round, parallel) VALUES (
506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
508 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
511 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
513 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
514 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
516 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
518 UPDATE rounds SET randomsongs=2 WHERE
519 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
521 UPDATE rounds SET chosensongs=1 WHERE
522 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
524 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
527 (SELECT player FROM players WHERE nick='T|na'),
530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
533 (SELECT player FROM players WHERE nick='T|na'),
535 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
541 (SELECT player FROM players WHERE nick='T|na'),
543 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
549 (SELECT player FROM players WHERE nick='T|na'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
554 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
557 (SELECT player FROM players WHERE nick='Private Ryan'),
560 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
563 (SELECT player FROM players WHERE nick='Private Ryan'),
565 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
571 (SELECT player FROM players WHERE nick='Private Ryan'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
579 (SELECT player FROM players WHERE nick='Private Ryan'),
581 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
584 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
587 (SELECT player FROM players WHERE nick='Purity'),
590 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
593 (SELECT player FROM players WHERE nick='Purity'),
595 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
601 (SELECT player FROM players WHERE nick='Purity'),
603 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
609 (SELECT player FROM players WHERE nick='Purity'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
614 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
617 (SELECT player FROM players WHERE nick='Telc'),
620 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
623 (SELECT player FROM players WHERE nick='Telc'),
625 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
631 (SELECT player FROM players WHERE nick='Telc'),
633 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
639 (SELECT player FROM players WHERE nick='Telc'),
641 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
647 (SELECT player FROM players WHERE nick='DufF'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
653 (SELECT player FROM players WHERE nick='DufF'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
661 (SELECT player FROM players WHERE nick='DufF'),
663 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
669 (SELECT player FROM players WHERE nick='DufF'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
674 INSERT INTO groups (tournament, round, parallel) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
677 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
680 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
682 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
683 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
685 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
687 UPDATE rounds SET randomsongs=2 WHERE
688 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
690 UPDATE rounds SET chosensongs=1 WHERE
691 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
693 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
694 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
696 (SELECT player FROM players WHERE nick='Haz'),
699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
702 (SELECT player FROM players WHERE nick='Haz'),
704 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
707 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
710 (SELECT player FROM players WHERE nick='Haz'),
712 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
715 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
716 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
718 (SELECT player FROM players WHERE nick='Haz'),
720 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
723 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
726 (SELECT player FROM players WHERE nick='Advena'),
729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
732 (SELECT player FROM players WHERE nick='Advena'),
734 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
740 (SELECT player FROM players WHERE nick='Advena'),
742 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
748 (SELECT player FROM players WHERE nick='Advena'),
750 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
756 (SELECT player FROM players WHERE nick='Spinnvill'),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
762 (SELECT player FROM players WHERE nick='Spinnvill'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
770 (SELECT player FROM players WHERE nick='Spinnvill'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
778 (SELECT player FROM players WHERE nick='Spinnvill'),
780 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
786 (SELECT player FROM players WHERE nick='Havok'),
789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
792 (SELECT player FROM players WHERE nick='Havok'),
794 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
800 (SELECT player FROM players WHERE nick='Havok'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
808 (SELECT player FROM players WHERE nick='Havok'),
810 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
816 (SELECT player FROM players WHERE nick='Oliyzia'),
819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
822 (SELECT player FROM players WHERE nick='Oliyzia'),
824 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
827 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
828 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
830 (SELECT player FROM players WHERE nick='Oliyzia'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
836 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
838 (SELECT player FROM players WHERE nick='Oliyzia'),
840 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
843 INSERT INTO groups (tournament, round, parallel) VALUES (
844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
846 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
849 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
851 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
854 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
856 UPDATE rounds SET randomsongs=2 WHERE
857 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
859 UPDATE rounds SET chosensongs=1 WHERE
860 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
862 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
863 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
865 (SELECT player FROM players WHERE nick='Suspect'),
868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
871 (SELECT player FROM players WHERE nick='Suspect'),
873 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
876 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
879 (SELECT player FROM players WHERE nick='Suspect'),
881 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
884 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
885 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
887 (SELECT player FROM players WHERE nick='Suspect'),
889 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
892 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
893 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
895 (SELECT player FROM players WHERE nick='OJK'),
898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
901 (SELECT player FROM players WHERE nick='OJK'),
903 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
909 (SELECT player FROM players WHERE nick='OJK'),
911 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
914 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
917 (SELECT player FROM players WHERE nick='OJK'),
919 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
922 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
925 (SELECT player FROM players WHERE nick='Electus'),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
931 (SELECT player FROM players WHERE nick='Electus'),
933 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
939 (SELECT player FROM players WHERE nick='Electus'),
941 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
947 (SELECT player FROM players WHERE nick='Electus'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
952 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
955 (SELECT player FROM players WHERE nick='kjmcw'),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
961 (SELECT player FROM players WHERE nick='kjmcw'),
963 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
969 (SELECT player FROM players WHERE nick='kjmcw'),
971 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
974 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
975 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
977 (SELECT player FROM players WHERE nick='kjmcw'),
979 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
982 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
985 (SELECT player FROM players WHERE nick='Draconia'),
988 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
991 (SELECT player FROM players WHERE nick='Draconia'),
993 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
999 (SELECT player FROM players WHERE nick='Draconia'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1007 (SELECT player FROM players WHERE nick='Draconia'),
1009 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1012 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1014 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1017 INSERT INTO groups (tournament, round, parallel) VALUES (
1018 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1020 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1021 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1023 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1025 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1028 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1030 UPDATE rounds SET randomsongs=2 WHERE
1031 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1033 UPDATE rounds SET chosensongs=1 WHERE
1034 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1039 (SELECT player FROM players WHERE nick='Mulefisk'),
1042 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1045 (SELECT player FROM players WHERE nick='Mulefisk'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1050 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1053 (SELECT player FROM players WHERE nick='Mulefisk'),
1055 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1058 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1059 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1061 (SELECT player FROM players WHERE nick='Mulefisk'),
1063 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1066 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1069 (SELECT player FROM players WHERE nick='Draconia'),
1072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1073 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1075 (SELECT player FROM players WHERE nick='Draconia'),
1077 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1083 (SELECT player FROM players WHERE nick='Draconia'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1088 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1091 (SELECT player FROM players WHERE nick='Draconia'),
1093 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1096 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1099 (SELECT player FROM players WHERE nick='Electus'),
1102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1105 (SELECT player FROM players WHERE nick='Electus'),
1107 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1110 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1113 (SELECT player FROM players WHERE nick='Electus'),
1115 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1121 (SELECT player FROM players WHERE nick='Electus'),
1123 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1129 (SELECT player FROM players WHERE nick='T|na'),
1132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1135 (SELECT player FROM players WHERE nick='T|na'),
1137 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1143 (SELECT player FROM players WHERE nick='T|na'),
1145 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1151 (SELECT player FROM players WHERE nick='T|na'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1156 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1159 (SELECT player FROM players WHERE nick='DufF'),
1162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1163 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1165 (SELECT player FROM players WHERE nick='DufF'),
1167 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1173 (SELECT player FROM players WHERE nick='DufF'),
1175 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1181 (SELECT player FROM players WHERE nick='DufF'),
1183 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1186 INSERT INTO groups (tournament, round, parallel) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1189 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1190 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1192 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
1194 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1197 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
1199 UPDATE rounds SET randomsongs=2 WHERE
1200 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1202 UPDATE rounds SET chosensongs=1 WHERE
1203 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1205 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1208 (SELECT player FROM players WHERE nick='Spinnvill'),
1211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1214 (SELECT player FROM players WHERE nick='Spinnvill'),
1216 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1222 (SELECT player FROM players WHERE nick='Spinnvill'),
1224 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1230 (SELECT player FROM players WHERE nick='Spinnvill'),
1232 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1235 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1238 (SELECT player FROM players WHERE nick='Telc'),
1241 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1244 (SELECT player FROM players WHERE nick='Telc'),
1246 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1249 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1250 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1252 (SELECT player FROM players WHERE nick='Telc'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1257 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1260 (SELECT player FROM players WHERE nick='Telc'),
1262 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1265 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1268 (SELECT player FROM players WHERE nick='RiChY'),
1271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1274 (SELECT player FROM players WHERE nick='RiChY'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1282 (SELECT player FROM players WHERE nick='RiChY'),
1284 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1290 (SELECT player FROM players WHERE nick='RiChY'),
1292 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1298 (SELECT player FROM players WHERE nick='OJK'),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1304 (SELECT player FROM players WHERE nick='OJK'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1312 (SELECT player FROM players WHERE nick='OJK'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1320 (SELECT player FROM players WHERE nick='OJK'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1325 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1328 (SELECT player FROM players WHERE nick='Tom'),
1331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1334 (SELECT player FROM players WHERE nick='Tom'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1339 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1342 (SELECT player FROM players WHERE nick='Tom'),
1344 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1350 (SELECT player FROM players WHERE nick='Tom'),
1352 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1355 INSERT INTO groups (tournament, round, parallel) VALUES (
1356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1358 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
1363 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1366 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
1368 UPDATE rounds SET randomsongs=2 WHERE
1369 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1371 UPDATE rounds SET chosensongs=1 WHERE
1372 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1374 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1377 (SELECT player FROM players WHERE nick='Smiph'),
1380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1383 (SELECT player FROM players WHERE nick='Smiph'),
1385 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1391 (SELECT player FROM players WHERE nick='Smiph'),
1393 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1396 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1399 (SELECT player FROM players WHERE nick='Smiph'),
1401 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1404 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1405 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1407 (SELECT player FROM players WHERE nick='Matsi'),
1410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1413 (SELECT player FROM players WHERE nick='Matsi'),
1415 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1421 (SELECT player FROM players WHERE nick='Matsi'),
1423 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1426 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1427 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1429 (SELECT player FROM players WHERE nick='Matsi'),
1431 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1434 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1435 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1437 (SELECT player FROM players WHERE nick='Havok'),
1440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1443 (SELECT player FROM players WHERE nick='Havok'),
1445 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1448 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1451 (SELECT player FROM players WHERE nick='Havok'),
1453 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1456 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1457 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1459 (SELECT player FROM players WHERE nick='Havok'),
1461 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1467 (SELECT player FROM players WHERE nick='Snute'),
1470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1473 (SELECT player FROM players WHERE nick='Snute'),
1475 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1481 (SELECT player FROM players WHERE nick='Snute'),
1483 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1489 (SELECT player FROM players WHERE nick='Snute'),
1491 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1494 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1497 (SELECT player FROM players WHERE nick='Oliyzia'),
1500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1503 (SELECT player FROM players WHERE nick='Oliyzia'),
1505 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1511 (SELECT player FROM players WHERE nick='Oliyzia'),
1513 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1519 (SELECT player FROM players WHERE nick='Oliyzia'),
1521 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1524 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1529 INSERT INTO groups (tournament, round, parallel) VALUES (
1530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1532 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1535 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
1537 UPDATE rounds SET randomsongs=1 WHERE
1538 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1540 UPDATE rounds SET chosensongs=1 WHERE
1541 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1543 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1544 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1546 (SELECT player FROM players WHERE nick='Havok'),
1549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1552 (SELECT player FROM players WHERE nick='Havok'),
1554 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1558 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1560 (SELECT player FROM players WHERE nick='Havok'),
1562 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1566 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1568 (SELECT player FROM players WHERE nick='Draconia'),
1571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1574 (SELECT player FROM players WHERE nick='Draconia'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1582 (SELECT player FROM players WHERE nick='Draconia'),
1584 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1587 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1588 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1590 (SELECT player FROM players WHERE nick='RiChY'),
1593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1594 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1596 (SELECT player FROM players WHERE nick='RiChY'),
1598 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1604 (SELECT player FROM players WHERE nick='RiChY'),
1606 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1609 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1610 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1612 (SELECT player FROM players WHERE nick='T|na'),
1615 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1618 (SELECT player FROM players WHERE nick='T|na'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1623 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1626 (SELECT player FROM players WHERE nick='T|na'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1631 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1632 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1634 (SELECT player FROM players WHERE nick='OJK'),
1637 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1640 (SELECT player FROM players WHERE nick='OJK'),
1642 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1645 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1646 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1648 (SELECT player FROM players WHERE nick='OJK'),
1650 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1653 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1654 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1656 (SELECT player FROM players WHERE nick='Oliyzia'),
1659 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1660 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1662 (SELECT player FROM players WHERE nick='Oliyzia'),
1664 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1667 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1668 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1670 (SELECT player FROM players WHERE nick='Oliyzia'),
1672 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1675 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1678 (SELECT player FROM players WHERE nick='DufF'),
1681 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1684 (SELECT player FROM players WHERE nick='DufF'),
1686 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1692 (SELECT player FROM players WHERE nick='DufF'),
1694 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1697 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1700 (SELECT player FROM players WHERE nick='Tom'),
1703 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1706 (SELECT player FROM players WHERE nick='Tom'),
1708 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1714 (SELECT player FROM players WHERE nick='Tom'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1719 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1722 (SELECT player FROM players WHERE nick='Snute'),
1725 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1728 (SELECT player FROM players WHERE nick='Snute'),
1730 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1733 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1734 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1736 (SELECT player FROM players WHERE nick='Snute'),
1738 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1741 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1746 INSERT INTO groups (tournament, round, parallel) VALUES (
1747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1749 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1752 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
1754 UPDATE rounds SET randomsongs=1 WHERE
1755 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1757 UPDATE rounds SET chosensongs=1 WHERE
1758 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1760 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1761 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1763 (SELECT player FROM players WHERE nick='Havok'),
1766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1769 (SELECT player FROM players WHERE nick='Havok'),
1771 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1777 (SELECT player FROM players WHERE nick='Havok'),
1779 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1785 (SELECT player FROM players WHERE nick='RiChY'),
1788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1791 (SELECT player FROM players WHERE nick='RiChY'),
1793 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1797 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1799 (SELECT player FROM players WHERE nick='RiChY'),
1801 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1804 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1807 (SELECT player FROM players WHERE nick='Snute'),
1810 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1811 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1813 (SELECT player FROM players WHERE nick='Snute'),
1815 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1821 (SELECT player FROM players WHERE nick='Snute'),
1823 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1826 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1827 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1829 (SELECT player FROM players WHERE nick='DufF'),
1832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1835 (SELECT player FROM players WHERE nick='DufF'),
1837 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1841 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1843 (SELECT player FROM players WHERE nick='DufF'),
1845 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1848 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1851 (SELECT player FROM players WHERE nick='OJK'),
1854 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1857 (SELECT player FROM players WHERE nick='OJK'),
1859 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1862 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1863 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1865 (SELECT player FROM players WHERE nick='OJK'),
1867 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1870 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1871 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1873 (SELECT player FROM players WHERE nick='Tom'),
1876 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1879 (SELECT player FROM players WHERE nick='Tom'),
1881 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1884 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1885 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1887 (SELECT player FROM players WHERE nick='Tom'),
1889 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1892 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1893 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1895 (SELECT player FROM players WHERE nick='Oliyzia'),
1898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1901 (SELECT player FROM players WHERE nick='Oliyzia'),
1903 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1909 (SELECT player FROM players WHERE nick='Oliyzia'),
1911 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1914 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1916 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1919 INSERT INTO groups (tournament, round, parallel) VALUES (
1920 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1922 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1925 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
1927 UPDATE rounds SET randomsongs=1 WHERE
1928 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1930 UPDATE rounds SET chosensongs=1 WHERE
1931 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1936 (SELECT player FROM players WHERE nick='OJK'),
1939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1940 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1942 (SELECT player FROM players WHERE nick='OJK'),
1944 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1948 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1950 (SELECT player FROM players WHERE nick='OJK'),
1952 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1955 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1956 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1958 (SELECT player FROM players WHERE nick='DufF'),
1961 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1962 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1964 (SELECT player FROM players WHERE nick='DufF'),
1966 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1970 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1972 (SELECT player FROM players WHERE nick='DufF'),
1974 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1977 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1978 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1980 (SELECT player FROM players WHERE nick='Oliyzia'),
1983 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1984 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1986 (SELECT player FROM players WHERE nick='Oliyzia'),
1988 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
1991 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1992 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1994 (SELECT player FROM players WHERE nick='Oliyzia'),
1996 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1999 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2000 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2002 (SELECT player FROM players WHERE nick='Tom'),
2005 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2006 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2008 (SELECT player FROM players WHERE nick='Tom'),
2010 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
2013 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2014 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2016 (SELECT player FROM players WHERE nick='Tom'),
2018 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2021 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2022 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2024 (SELECT player FROM players WHERE nick='Snute'),
2027 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2028 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2030 (SELECT player FROM players WHERE nick='Snute'),
2032 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
2035 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2036 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2038 (SELECT player FROM players WHERE nick='Snute'),
2040 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2043 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2045 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2048 INSERT INTO groups (tournament, round, parallel) VALUES (
2049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2051 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2052 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2054 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
2056 UPDATE rounds SET randomsongs=1 WHERE
2057 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2059 UPDATE rounds SET chosensongs=1 WHERE
2060 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2062 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2063 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2065 (SELECT player FROM players WHERE nick='Oliyzia'),
2068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2071 (SELECT player FROM players WHERE nick='Oliyzia'),
2073 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2079 (SELECT player FROM players WHERE nick='Oliyzia'),
2081 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2084 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2085 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2087 (SELECT player FROM players WHERE nick='OJK'),
2090 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2091 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2093 (SELECT player FROM players WHERE nick='OJK'),
2095 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2098 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2099 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2101 (SELECT player FROM players WHERE nick='OJK'),
2103 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2106 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2107 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2109 (SELECT player FROM players WHERE nick='Tom'),
2112 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2113 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2115 (SELECT player FROM players WHERE nick='Tom'),
2117 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2120 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2123 (SELECT player FROM players WHERE nick='Tom'),
2125 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
2128 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2129 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2131 (SELECT player FROM players WHERE nick='Snute'),
2134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2137 (SELECT player FROM players WHERE nick='Snute'),
2139 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2142 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2145 (SELECT player FROM players WHERE nick='Snute'),
2147 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2150 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2155 INSERT INTO groups (tournament, round, parallel) VALUES (
2156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2158 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2161 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
2163 UPDATE rounds SET randomsongs=1 WHERE
2164 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2166 UPDATE rounds SET chosensongs=1 WHERE
2167 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2169 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2172 (SELECT player FROM players WHERE nick='Oliyzia'),
2175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2178 (SELECT player FROM players WHERE nick='Oliyzia'),
2180 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2186 (SELECT player FROM players WHERE nick='Oliyzia'),
2188 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2191 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2194 (SELECT player FROM players WHERE nick='Tom'),
2197 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2200 (SELECT player FROM players WHERE nick='Tom'),
2202 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2205 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2208 (SELECT player FROM players WHERE nick='Tom'),
2210 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2213 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2216 (SELECT player FROM players WHERE nick='Snute'),
2219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2222 (SELECT player FROM players WHERE nick='Snute'),
2224 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2227 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2230 (SELECT player FROM players WHERE nick='Snute'),
2232 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2235 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2240 INSERT INTO groups (tournament, round, parallel) VALUES (
2241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2243 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2244 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2246 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
2248 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2251 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2253 UPDATE rounds SET randomsongs=2 WHERE
2254 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2256 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2259 (SELECT player FROM players WHERE nick='Snute'),
2262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2265 (SELECT player FROM players WHERE nick='Snute'),
2267 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2273 (SELECT player FROM players WHERE nick='Snute'),
2275 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2278 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2281 (SELECT player FROM players WHERE nick='Tom'),
2284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2287 (SELECT player FROM players WHERE nick='Tom'),
2289 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
2292 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2295 (SELECT player FROM players WHERE nick='Tom'),
2297 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),