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, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
16 (SELECT player FROM players WHERE nick='Snute'),
18 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 );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
22 (SELECT player FROM players WHERE nick='Tom'),
24 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 );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
28 (SELECT player FROM players WHERE nick='DufF'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
34 (SELECT player FROM players WHERE nick='Daniil'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
40 (SELECT player FROM players WHERE nick='Oliyzia'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 8' 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, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
52 (SELECT player FROM players WHERE nick='T|na'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
58 (SELECT player FROM players WHERE nick='Snofox'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='Draconia'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='Smiph'),
72 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 );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
76 (SELECT player FROM players WHERE nick='Pfxp'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='Stream'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='ViD'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='Jallaman'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Spinnvill'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='Slusk'),
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 8' 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, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
118 (SELECT player FROM players WHERE nick='Purity'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
124 (SELECT player FROM players WHERE nick='Havok'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Benny' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
130 (SELECT player FROM players WHERE nick='Benny'),
132 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 );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
136 (SELECT player FROM players WHERE nick='Nevrosert'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
142 (SELECT player FROM players WHERE nick='Haggar'),
144 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 );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
148 (SELECT player FROM players WHERE nick='Haz'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
154 (SELECT player FROM players WHERE nick='Lejordet'),
156 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 );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
160 (SELECT player FROM players WHERE nick='Matsi'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
166 (SELECT player FROM players WHERE nick='Golddragon'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
172 (SELECT player FROM players WHERE nick='Ylini'),
174 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 );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
178 (SELECT player FROM players WHERE nick='Tha Dragon'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
184 (SELECT player FROM players WHERE nick='Jannemor'),
186 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Liquid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Liquid' NOT IN ( SELECT nick FROM players );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
190 (SELECT player FROM players WHERE nick='Liquid'),
192 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
197 INSERT INTO groups (tournament, round, parallel) VALUES (
198 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
200 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
203 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
205 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
208 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
210 UPDATE rounds SET randomsongs=2 WHERE
211 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
213 UPDATE rounds SET chosensongs=1 WHERE
214 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
216 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
219 (SELECT player FROM players WHERE nick='Ylini'),
222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
225 (SELECT player FROM players WHERE nick='Ylini'),
227 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
233 (SELECT player FROM players WHERE nick='Ylini'),
235 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
239 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
241 (SELECT player FROM players WHERE nick='Ylini'),
243 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
249 (SELECT player FROM players WHERE nick='Nevrosert'),
252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
255 (SELECT player FROM players WHERE nick='Nevrosert'),
257 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
263 (SELECT player FROM players WHERE nick='Nevrosert'),
265 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
271 (SELECT player FROM players WHERE nick='Nevrosert'),
273 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
279 (SELECT player FROM players WHERE nick='Spinnvill'),
282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
285 (SELECT player FROM players WHERE nick='Spinnvill'),
287 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
293 (SELECT player FROM players WHERE nick='Spinnvill'),
295 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
301 (SELECT player FROM players WHERE nick='Spinnvill'),
303 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
309 (SELECT player FROM players WHERE nick='Slusk'),
312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
315 (SELECT player FROM players WHERE nick='Slusk'),
317 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
323 (SELECT player FROM players WHERE nick='Slusk'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
331 (SELECT player FROM players WHERE nick='Slusk'),
333 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
339 (SELECT player FROM players WHERE nick='Tom'),
342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
345 (SELECT player FROM players WHERE nick='Tom'),
347 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
353 (SELECT player FROM players WHERE nick='Tom'),
355 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
361 (SELECT player FROM players WHERE nick='Tom'),
363 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
366 INSERT INTO groups (tournament, round, parallel) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
369 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
372 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
374 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
377 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
379 UPDATE rounds SET randomsongs=2 WHERE
380 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
382 UPDATE rounds SET chosensongs=1 WHERE
383 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
388 (SELECT player FROM players WHERE nick='Benny'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
394 (SELECT player FROM players WHERE nick='Benny'),
396 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
402 (SELECT player FROM players WHERE nick='Benny'),
404 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
410 (SELECT player FROM players WHERE nick='Benny'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
418 (SELECT player FROM players WHERE nick='Stream'),
421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
424 (SELECT player FROM players WHERE nick='Stream'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
432 (SELECT player FROM players WHERE nick='Stream'),
434 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
440 (SELECT player FROM players WHERE nick='Stream'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
448 (SELECT player FROM players WHERE nick='Purity'),
451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
454 (SELECT player FROM players WHERE nick='Purity'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
462 (SELECT player FROM players WHERE nick='Purity'),
464 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
470 (SELECT player FROM players WHERE nick='Purity'),
472 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
478 (SELECT player FROM players WHERE nick='Matsi'),
481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
484 (SELECT player FROM players WHERE nick='Matsi'),
486 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
492 (SELECT player FROM players WHERE nick='Matsi'),
494 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
500 (SELECT player FROM players WHERE nick='Matsi'),
502 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
505 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
508 (SELECT player FROM players WHERE nick='Snute'),
511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
512 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
514 (SELECT player FROM players WHERE nick='Snute'),
516 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
522 (SELECT player FROM players WHERE nick='Snute'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
530 (SELECT player FROM players WHERE nick='Snute'),
532 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
535 INSERT INTO groups (tournament, round, parallel) VALUES (
536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
538 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
541 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
543 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
544 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
546 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
548 UPDATE rounds SET randomsongs=2 WHERE
549 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
551 UPDATE rounds SET chosensongs=1 WHERE
552 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
554 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
557 (SELECT player FROM players WHERE nick='Jallaman'),
560 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
563 (SELECT player FROM players WHERE nick='Jallaman'),
565 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
571 (SELECT player FROM players WHERE nick='Jallaman'),
573 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
579 (SELECT player FROM players WHERE nick='Jallaman'),
581 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
584 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
587 (SELECT player FROM players WHERE nick='Jannemor'),
590 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
593 (SELECT player FROM players WHERE nick='Jannemor'),
595 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
601 (SELECT player FROM players WHERE nick='Jannemor'),
603 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
609 (SELECT player FROM players WHERE nick='Jannemor'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
614 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
617 (SELECT player FROM players WHERE nick='Lejordet'),
620 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
623 (SELECT player FROM players WHERE nick='Lejordet'),
625 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
631 (SELECT player FROM players WHERE nick='Lejordet'),
633 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
639 (SELECT player FROM players WHERE nick='Lejordet'),
641 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
647 (SELECT player FROM players WHERE nick='Smiph'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
653 (SELECT player FROM players WHERE nick='Smiph'),
655 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
661 (SELECT player FROM players WHERE nick='Smiph'),
663 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
669 (SELECT player FROM players WHERE nick='Smiph'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
677 (SELECT player FROM players WHERE nick='DufF'),
680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
683 (SELECT player FROM players WHERE nick='DufF'),
685 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
691 (SELECT player FROM players WHERE nick='DufF'),
693 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
697 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
699 (SELECT player FROM players WHERE nick='DufF'),
701 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
704 INSERT INTO groups (tournament, round, parallel) VALUES (
705 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
707 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
710 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
712 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
713 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
715 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
717 UPDATE rounds SET randomsongs=2 WHERE
718 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
720 UPDATE rounds SET chosensongs=1 WHERE
721 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
723 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
726 (SELECT player FROM players WHERE nick='Golddragon'),
729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
732 (SELECT player FROM players WHERE nick='Golddragon'),
734 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
740 (SELECT player FROM players WHERE nick='Golddragon'),
742 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
748 (SELECT player FROM players WHERE nick='Golddragon'),
750 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
756 (SELECT player FROM players WHERE nick='Haz'),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
762 (SELECT player FROM players WHERE nick='Haz'),
764 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
770 (SELECT player FROM players WHERE nick='Haz'),
772 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
778 (SELECT player FROM players WHERE nick='Haz'),
780 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
786 (SELECT player FROM players WHERE nick='Snofox'),
789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
792 (SELECT player FROM players WHERE nick='Snofox'),
794 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
800 (SELECT player FROM players WHERE nick='Snofox'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
808 (SELECT player FROM players WHERE nick='Snofox'),
810 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
816 (SELECT player FROM players WHERE nick='Daniil'),
819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
822 (SELECT player FROM players WHERE nick='Daniil'),
824 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
827 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
828 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
830 (SELECT player FROM players WHERE nick='Daniil'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
836 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
838 (SELECT player FROM players WHERE nick='Daniil'),
840 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
846 (SELECT player FROM players WHERE nick='Oliyzia'),
849 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
850 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
852 (SELECT player FROM players WHERE nick='Oliyzia'),
854 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
858 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
860 (SELECT player FROM players WHERE nick='Oliyzia'),
862 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
866 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
868 (SELECT player FROM players WHERE nick='Oliyzia'),
870 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
873 INSERT INTO groups (tournament, round, parallel) VALUES (
874 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
876 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
879 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
881 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
882 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
884 (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
886 UPDATE rounds SET randomsongs=2 WHERE
887 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
889 UPDATE rounds SET chosensongs=1 WHERE
890 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
892 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
893 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
895 (SELECT player FROM players WHERE nick='Haggar'),
898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
901 (SELECT player FROM players WHERE nick='Haggar'),
903 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
909 (SELECT player FROM players WHERE nick='Haggar'),
911 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
914 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
917 (SELECT player FROM players WHERE nick='Haggar'),
919 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
922 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
925 (SELECT player FROM players WHERE nick='Tha Dragon'),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
931 (SELECT player FROM players WHERE nick='Tha Dragon'),
933 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
939 (SELECT player FROM players WHERE nick='Tha Dragon'),
941 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
947 (SELECT player FROM players WHERE nick='Tha Dragon'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
952 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
955 (SELECT player FROM players WHERE nick='ViD'),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
961 (SELECT player FROM players WHERE nick='ViD'),
963 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
969 (SELECT player FROM players WHERE nick='ViD'),
971 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
974 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
975 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
977 (SELECT player FROM players WHERE nick='ViD'),
979 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
982 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
985 (SELECT player FROM players WHERE nick='RiChY'),
988 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
991 (SELECT player FROM players WHERE nick='RiChY'),
993 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
999 (SELECT player FROM players WHERE nick='RiChY'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
1004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1007 (SELECT player FROM players WHERE nick='RiChY'),
1009 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1015 (SELECT player FROM players WHERE nick='Draconia'),
1018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1021 (SELECT player FROM players WHERE nick='Draconia'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1027 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1029 (SELECT player FROM players WHERE nick='Draconia'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
1034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1037 (SELECT player FROM players WHERE nick='Draconia'),
1039 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1042 INSERT INTO groups (tournament, round, parallel) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1045 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1048 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1050 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1053 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1055 UPDATE rounds SET randomsongs=2 WHERE
1056 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1058 UPDATE rounds SET chosensongs=1 WHERE
1059 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1061 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1062 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1064 (SELECT player FROM players WHERE nick='Liquid'),
1067 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1068 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1070 (SELECT player FROM players WHERE nick='Liquid'),
1072 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1075 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1076 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1078 (SELECT player FROM players WHERE nick='Liquid'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1083 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1084 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1086 (SELECT player FROM players WHERE nick='Liquid'),
1088 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1091 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1092 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1094 (SELECT player FROM players WHERE nick='Pfxp'),
1097 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1098 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1100 (SELECT player FROM players WHERE nick='Pfxp'),
1102 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1108 (SELECT player FROM players WHERE nick='Pfxp'),
1110 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1116 (SELECT player FROM players WHERE nick='Pfxp'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1124 (SELECT player FROM players WHERE nick='T|na'),
1127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1130 (SELECT player FROM players WHERE nick='T|na'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1138 (SELECT player FROM players WHERE nick='T|na'),
1140 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1146 (SELECT player FROM players WHERE nick='T|na'),
1148 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1151 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1154 (SELECT player FROM players WHERE nick='Havok'),
1157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1160 (SELECT player FROM players WHERE nick='Havok'),
1162 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1165 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1168 (SELECT player FROM players WHERE nick='Havok'),
1170 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1176 (SELECT player FROM players WHERE nick='Havok'),
1178 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1184 (SELECT player FROM players WHERE nick='kjmcw'),
1187 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1190 (SELECT player FROM players WHERE nick='kjmcw'),
1192 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1195 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1198 (SELECT player FROM players WHERE nick='kjmcw'),
1200 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1204 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1206 (SELECT player FROM players WHERE nick='kjmcw'),
1208 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1211 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1216 INSERT INTO groups (tournament, round, parallel) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1219 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1222 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1224 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1227 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1229 UPDATE rounds SET randomsongs=2 WHERE
1230 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1232 UPDATE rounds SET chosensongs=1 WHERE
1233 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1235 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1238 (SELECT player FROM players WHERE nick='Jallaman'),
1241 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1244 (SELECT player FROM players WHERE nick='Jallaman'),
1246 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1249 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1250 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1252 (SELECT player FROM players WHERE nick='Jallaman'),
1254 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1257 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1260 (SELECT player FROM players WHERE nick='Jallaman'),
1262 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1265 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1268 (SELECT player FROM players WHERE nick='Draconia'),
1271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1274 (SELECT player FROM players WHERE nick='Draconia'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1282 (SELECT player FROM players WHERE nick='Draconia'),
1284 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1290 (SELECT player FROM players WHERE nick='Draconia'),
1292 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1298 (SELECT player FROM players WHERE nick='Smiph'),
1301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1304 (SELECT player FROM players WHERE nick='Smiph'),
1306 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1312 (SELECT player FROM players WHERE nick='Smiph'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1320 (SELECT player FROM players WHERE nick='Smiph'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1325 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1328 (SELECT player FROM players WHERE nick='Slusk'),
1331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1334 (SELECT player FROM players WHERE nick='Slusk'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1339 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1340 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1342 (SELECT player FROM players WHERE nick='Slusk'),
1344 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1350 (SELECT player FROM players WHERE nick='Slusk'),
1352 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1358 (SELECT player FROM players WHERE nick='Oliyzia'),
1361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1364 (SELECT player FROM players WHERE nick='Oliyzia'),
1366 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1369 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1372 (SELECT player FROM players WHERE nick='Oliyzia'),
1374 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1377 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1378 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1380 (SELECT player FROM players WHERE nick='Oliyzia'),
1382 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1388 (SELECT player FROM players WHERE nick='Tom'),
1391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1394 (SELECT player FROM players WHERE nick='Tom'),
1396 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1402 (SELECT player FROM players WHERE nick='Tom'),
1404 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1410 (SELECT player FROM players WHERE nick='Tom'),
1412 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1415 INSERT INTO groups (tournament, round, parallel) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1418 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1421 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
1423 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1428 UPDATE rounds SET randomsongs=2 WHERE
1429 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1431 UPDATE rounds SET chosensongs=1 WHERE
1432 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1434 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1435 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1437 (SELECT player FROM players WHERE nick='Purity'),
1440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1443 (SELECT player FROM players WHERE nick='Purity'),
1445 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1448 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1451 (SELECT player FROM players WHERE nick='Purity'),
1453 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1456 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1457 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1459 (SELECT player FROM players WHERE nick='Purity'),
1461 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1467 (SELECT player FROM players WHERE nick='Snofox'),
1470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1473 (SELECT player FROM players WHERE nick='Snofox'),
1475 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1481 (SELECT player FROM players WHERE nick='Snofox'),
1483 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1489 (SELECT player FROM players WHERE nick='Snofox'),
1491 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1494 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1497 (SELECT player FROM players WHERE nick='ViD'),
1500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1503 (SELECT player FROM players WHERE nick='ViD'),
1505 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1511 (SELECT player FROM players WHERE nick='ViD'),
1513 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1519 (SELECT player FROM players WHERE nick='ViD'),
1521 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1524 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1527 (SELECT player FROM players WHERE nick='T|na'),
1530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1533 (SELECT player FROM players WHERE nick='T|na'),
1535 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1541 (SELECT player FROM players WHERE nick='T|na'),
1543 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1549 (SELECT player FROM players WHERE nick='T|na'),
1551 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1554 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1557 (SELECT player FROM players WHERE nick='Pfxp'),
1560 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1563 (SELECT player FROM players WHERE nick='Pfxp'),
1565 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1569 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1571 (SELECT player FROM players WHERE nick='Pfxp'),
1573 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1579 (SELECT player FROM players WHERE nick='Pfxp'),
1581 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1584 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1587 (SELECT player FROM players WHERE nick='DufF'),
1590 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1593 (SELECT player FROM players WHERE nick='DufF'),
1595 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1601 (SELECT player FROM players WHERE nick='DufF'),
1603 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1609 (SELECT player FROM players WHERE nick='DufF'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1614 INSERT INTO groups (tournament, round, parallel) VALUES (
1615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1617 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1618 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1620 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1622 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1623 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1625 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
1627 UPDATE rounds SET randomsongs=2 WHERE
1628 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1630 UPDATE rounds SET chosensongs=1 WHERE
1631 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1633 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1636 (SELECT player FROM players WHERE nick='Spinnvill'),
1639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1640 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1642 (SELECT player FROM players WHERE nick='Spinnvill'),
1644 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1650 (SELECT player FROM players WHERE nick='Spinnvill'),
1652 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1655 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1658 (SELECT player FROM players WHERE nick='Spinnvill'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1663 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1666 (SELECT player FROM players WHERE nick='kjmcw'),
1669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1672 (SELECT player FROM players WHERE nick='kjmcw'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1680 (SELECT player FROM players WHERE nick='kjmcw'),
1682 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1688 (SELECT player FROM players WHERE nick='kjmcw'),
1690 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1693 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1694 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1696 (SELECT player FROM players WHERE nick='Daniil'),
1699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1702 (SELECT player FROM players WHERE nick='Daniil'),
1704 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1707 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1708 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1710 (SELECT player FROM players WHERE nick='Daniil'),
1712 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1715 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1716 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1718 (SELECT player FROM players WHERE nick='Daniil'),
1720 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1723 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1726 (SELECT player FROM players WHERE nick='Stream'),
1729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1732 (SELECT player FROM players WHERE nick='Stream'),
1734 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1740 (SELECT player FROM players WHERE nick='Stream'),
1742 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1748 (SELECT player FROM players WHERE nick='Stream'),
1750 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1756 (SELECT player FROM players WHERE nick='Snute'),
1759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1762 (SELECT player FROM players WHERE nick='Snute'),
1764 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1770 (SELECT player FROM players WHERE nick='Snute'),
1772 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1778 (SELECT player FROM players WHERE nick='Snute'),
1780 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1786 (SELECT player FROM players WHERE nick='RiChY'),
1789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1792 (SELECT player FROM players WHERE nick='RiChY'),
1794 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1800 (SELECT player FROM players WHERE nick='RiChY'),
1802 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1808 (SELECT player FROM players WHERE nick='RiChY'),
1810 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1813 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1815 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1818 INSERT INTO groups (tournament, round, parallel) VALUES (
1819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1821 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1822 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1824 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
1826 UPDATE rounds SET randomsongs=1 WHERE
1827 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1829 UPDATE rounds SET chosensongs=1 WHERE
1830 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1832 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1833 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1835 (SELECT player FROM players WHERE nick='Daniil'),
1838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1841 (SELECT player FROM players WHERE nick='Daniil'),
1843 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1849 (SELECT player FROM players WHERE nick='Daniil'),
1851 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1857 (SELECT player FROM players WHERE nick='Snofox'),
1860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1863 (SELECT player FROM players WHERE nick='Snofox'),
1865 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1871 (SELECT player FROM players WHERE nick='Snofox'),
1873 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1876 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1879 (SELECT player FROM players WHERE nick='Draconia'),
1882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1885 (SELECT player FROM players WHERE nick='Draconia'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1893 (SELECT player FROM players WHERE nick='Draconia'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1901 (SELECT player FROM players WHERE nick='RiChY'),
1904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1907 (SELECT player FROM players WHERE nick='RiChY'),
1909 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1913 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1915 (SELECT player FROM players WHERE nick='RiChY'),
1917 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1923 (SELECT player FROM players WHERE nick='Oliyzia'),
1926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1929 (SELECT player FROM players WHERE nick='Oliyzia'),
1931 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1937 (SELECT player FROM players WHERE nick='Oliyzia'),
1939 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1942 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1943 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1945 (SELECT player FROM players WHERE nick='T|na'),
1948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1951 (SELECT player FROM players WHERE nick='T|na'),
1953 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1959 (SELECT player FROM players WHERE nick='T|na'),
1961 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1964 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1967 (SELECT player FROM players WHERE nick='Snute'),
1970 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1973 (SELECT player FROM players WHERE nick='Snute'),
1975 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1981 (SELECT player FROM players WHERE nick='Snute'),
1983 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1986 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1989 (SELECT player FROM players WHERE nick='DufF'),
1992 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1995 (SELECT player FROM players WHERE nick='DufF'),
1997 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
2000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2003 (SELECT player FROM players WHERE nick='DufF'),
2005 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2008 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2009 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2011 (SELECT player FROM players WHERE nick='Tom'),
2014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2017 (SELECT player FROM players WHERE nick='Tom'),
2019 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
2022 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2025 (SELECT player FROM players WHERE nick='Tom'),
2027 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2030 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2032 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2035 INSERT INTO groups (tournament, round, parallel) VALUES (
2036 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2038 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2039 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2041 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
2043 UPDATE rounds SET randomsongs=1 WHERE
2044 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2046 UPDATE rounds SET chosensongs=1 WHERE
2047 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2049 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2052 (SELECT player FROM players WHERE nick='T|na'),
2055 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2056 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2058 (SELECT player FROM players WHERE nick='T|na'),
2060 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2064 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2066 (SELECT player FROM players WHERE nick='T|na'),
2068 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2071 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2072 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2074 (SELECT player FROM players WHERE nick='Tom'),
2077 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2080 (SELECT player FROM players WHERE nick='Tom'),
2082 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2085 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2088 (SELECT player FROM players WHERE nick='Tom'),
2090 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2093 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2096 (SELECT player FROM players WHERE nick='Daniil'),
2099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2102 (SELECT player FROM players WHERE nick='Daniil'),
2104 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2110 (SELECT player FROM players WHERE nick='Daniil'),
2112 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2115 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2118 (SELECT player FROM players WHERE nick='RiChY'),
2121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2124 (SELECT player FROM players WHERE nick='RiChY'),
2126 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2129 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2130 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2132 (SELECT player FROM players WHERE nick='RiChY'),
2134 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2137 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2138 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2140 (SELECT player FROM players WHERE nick='Oliyzia'),
2143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2146 (SELECT player FROM players WHERE nick='Oliyzia'),
2148 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2154 (SELECT player FROM players WHERE nick='Oliyzia'),
2156 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2159 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2160 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2162 (SELECT player FROM players WHERE nick='DufF'),
2165 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2168 (SELECT player FROM players WHERE nick='DufF'),
2170 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2176 (SELECT player FROM players WHERE nick='DufF'),
2178 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2184 (SELECT player FROM players WHERE nick='Snute'),
2187 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2190 (SELECT player FROM players WHERE nick='Snute'),
2192 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
2195 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2198 (SELECT player FROM players WHERE nick='Snute'),
2200 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2203 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2208 INSERT INTO groups (tournament, round, parallel) VALUES (
2209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2211 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2214 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
2216 UPDATE rounds SET randomsongs=1 WHERE
2217 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2219 UPDATE rounds SET chosensongs=1 WHERE
2220 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2222 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2225 (SELECT player FROM players WHERE nick='Daniil'),
2228 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2231 (SELECT player FROM players WHERE nick='Daniil'),
2233 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
2236 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2239 (SELECT player FROM players WHERE nick='Daniil'),
2241 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2247 (SELECT player FROM players WHERE nick='Tom'),
2250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2253 (SELECT player FROM players WHERE nick='Tom'),
2255 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
2258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2261 (SELECT player FROM players WHERE nick='Tom'),
2263 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2266 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2269 (SELECT player FROM players WHERE nick='Oliyzia'),
2272 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2273 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2275 (SELECT player FROM players WHERE nick='Oliyzia'),
2277 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
2280 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2283 (SELECT player FROM players WHERE nick='Oliyzia'),
2285 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2288 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2291 (SELECT player FROM players WHERE nick='DufF'),
2294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2297 (SELECT player FROM players WHERE nick='DufF'),
2299 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
2302 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2305 (SELECT player FROM players WHERE nick='DufF'),
2307 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2310 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2313 (SELECT player FROM players WHERE nick='Snute'),
2316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2319 (SELECT player FROM players WHERE nick='Snute'),
2321 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
2324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2327 (SELECT player FROM players WHERE nick='Snute'),
2329 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2332 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2337 INSERT INTO groups (tournament, round, parallel) VALUES (
2338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2340 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2343 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
2345 UPDATE rounds SET randomsongs=1 WHERE
2346 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2348 UPDATE rounds SET chosensongs=1 WHERE
2349 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2351 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2354 (SELECT player FROM players WHERE nick='DufF'),
2357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2360 (SELECT player FROM players WHERE nick='DufF'),
2362 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
2365 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2368 (SELECT player FROM players WHERE nick='DufF'),
2370 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2373 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2376 (SELECT player FROM players WHERE nick='Daniil'),
2379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2382 (SELECT player FROM players WHERE nick='Daniil'),
2384 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
2387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2390 (SELECT player FROM players WHERE nick='Daniil'),
2392 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2395 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2396 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2398 (SELECT player FROM players WHERE nick='Snute'),
2401 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2404 (SELECT player FROM players WHERE nick='Snute'),
2406 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
2409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2412 (SELECT player FROM players WHERE nick='Snute'),
2414 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2417 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2420 (SELECT player FROM players WHERE nick='Tom'),
2423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2426 (SELECT player FROM players WHERE nick='Tom'),
2428 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
2431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2434 (SELECT player FROM players WHERE nick='Tom'),
2436 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2439 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2444 INSERT INTO groups (tournament, round, parallel) VALUES (
2445 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2447 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2450 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
2452 UPDATE rounds SET randomsongs=1 WHERE
2453 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2455 UPDATE rounds SET chosensongs=1 WHERE
2456 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2458 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2459 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2461 (SELECT player FROM players WHERE nick='DufF'),
2464 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2467 (SELECT player FROM players WHERE nick='DufF'),
2469 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2472 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2473 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2475 (SELECT player FROM players WHERE nick='DufF'),
2477 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2480 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2481 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2483 (SELECT player FROM players WHERE nick='Tom'),
2486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2489 (SELECT player FROM players WHERE nick='Tom'),
2491 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2494 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2495 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2497 (SELECT player FROM players WHERE nick='Tom'),
2499 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2502 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2503 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2505 (SELECT player FROM players WHERE nick='Snute'),
2508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2511 (SELECT player FROM players WHERE nick='Snute'),
2513 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2519 (SELECT player FROM players WHERE nick='Snute'),
2521 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2524 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2529 INSERT INTO groups (tournament, round, parallel) VALUES (
2530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2532 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2535 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
2537 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2540 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2542 UPDATE rounds SET randomsongs=2 WHERE
2543 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2545 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2548 (SELECT player FROM players WHERE nick='Tom'),
2551 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2554 (SELECT player FROM players WHERE nick='Tom'),
2556 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2562 (SELECT player FROM players WHERE nick='Tom'),
2564 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2570 (SELECT player FROM players WHERE nick='Snute'),
2573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2576 (SELECT player FROM players WHERE nick='Snute'),
2578 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2582 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 8' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2584 (SELECT player FROM players WHERE nick='Snute'),
2586 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),