2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
16 (SELECT player FROM players WHERE nick='Tom'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 7' 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, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
34 (SELECT player FROM players WHERE nick='OJK'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, '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 7' 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, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
46 (SELECT player FROM players WHERE nick='Snofox'),
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 7' 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, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
58 (SELECT player FROM players WHERE nick='Pfxp'),
60 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 );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='ViD'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='Draconia'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
76 (SELECT player FROM players WHERE nick='Telc'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='kjmcw'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='Mulefisk'),
90 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 );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='Stream'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Tha Dragon'),
102 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 );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='RiChY'),
108 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 );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
112 (SELECT player FROM players WHERE nick='Havok'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Private Ryan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Private Ryan' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
118 (SELECT player FROM players WHERE nick='Private Ryan'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
124 (SELECT player FROM players WHERE nick='Indy'),
126 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 );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
130 (SELECT player FROM players WHERE nick='Matsi'),
132 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 );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
136 (SELECT player FROM players WHERE nick='Smiph'),
138 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 );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
142 (SELECT player FROM players WHERE nick='Spinnvill'),
144 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 );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
148 (SELECT player FROM players WHERE nick='Ylini'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Iris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Iris' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
154 (SELECT player FROM players WHERE nick='Iris'),
156 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 );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
160 (SELECT player FROM players WHERE nick='Haz'),
162 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 );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
166 (SELECT player FROM players WHERE nick='Benny'),
168 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 );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
172 (SELECT player FROM players WHERE nick='Jannemor'),
174 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
179 INSERT INTO groups (tournament, round, parallel) VALUES (
180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
182 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
185 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
187 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
190 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
192 UPDATE rounds SET randomsongs=2 WHERE
193 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
195 UPDATE rounds SET chosensongs=1 WHERE
196 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
201 (SELECT player FROM players WHERE nick='Pfxp'),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
207 (SELECT player FROM players WHERE nick='Pfxp'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
215 (SELECT player FROM players WHERE nick='Pfxp'),
217 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
221 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
223 (SELECT player FROM players WHERE nick='Pfxp'),
225 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
231 (SELECT player FROM players WHERE nick='Tha Dragon'),
234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
237 (SELECT player FROM players WHERE nick='Tha Dragon'),
239 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
245 (SELECT player FROM players WHERE nick='Tha Dragon'),
247 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
253 (SELECT player FROM players WHERE nick='Tha Dragon'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
258 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
261 (SELECT player FROM players WHERE nick='Matsi'),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
267 (SELECT player FROM players WHERE nick='Matsi'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
272 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
275 (SELECT player FROM players WHERE nick='Matsi'),
277 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
280 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
283 (SELECT player FROM players WHERE nick='Matsi'),
285 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
288 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
291 (SELECT player FROM players WHERE nick='Smiph'),
294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
297 (SELECT player FROM players WHERE nick='Smiph'),
299 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
302 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
305 (SELECT player FROM players WHERE nick='Smiph'),
307 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
313 (SELECT player FROM players WHERE nick='Smiph'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
318 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
321 (SELECT player FROM players WHERE nick='Tom'),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
327 (SELECT player FROM players WHERE nick='Tom'),
329 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
335 (SELECT player FROM players WHERE nick='Tom'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
343 (SELECT player FROM players WHERE nick='Tom'),
345 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
348 INSERT INTO groups (tournament, round, parallel) VALUES (
349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
351 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
354 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
356 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
359 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
361 UPDATE rounds SET randomsongs=2 WHERE
362 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
364 UPDATE rounds SET chosensongs=1 WHERE
365 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
367 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
368 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
370 (SELECT player FROM players WHERE nick='Haz'),
373 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
376 (SELECT player FROM players WHERE nick='Haz'),
378 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
384 (SELECT player FROM players WHERE nick='Haz'),
386 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
392 (SELECT player FROM players WHERE nick='Haz'),
394 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
400 (SELECT player FROM players WHERE nick='Indy'),
403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
406 (SELECT player FROM players WHERE nick='Indy'),
408 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
414 (SELECT player FROM players WHERE nick='Indy'),
416 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
422 (SELECT player FROM players WHERE nick='Indy'),
424 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
430 (SELECT player FROM players WHERE nick='Mulefisk'),
433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
436 (SELECT player FROM players WHERE nick='Mulefisk'),
438 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
444 (SELECT player FROM players WHERE nick='Mulefisk'),
446 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
449 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
452 (SELECT player FROM players WHERE nick='Mulefisk'),
454 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
457 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
460 (SELECT player FROM players WHERE nick='Telc'),
463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
466 (SELECT player FROM players WHERE nick='Telc'),
468 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
471 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
472 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
474 (SELECT player FROM players WHERE nick='Telc'),
476 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
479 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
480 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
482 (SELECT player FROM players WHERE nick='Telc'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
487 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
490 (SELECT player FROM players WHERE nick='Snute'),
493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
496 (SELECT player FROM players WHERE nick='Snute'),
498 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
504 (SELECT player FROM players WHERE nick='Snute'),
506 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
512 (SELECT player FROM players WHERE nick='Snute'),
514 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
517 INSERT INTO groups (tournament, round, parallel) VALUES (
518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
520 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
521 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
523 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
525 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
528 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
530 UPDATE rounds SET randomsongs=2 WHERE
531 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
533 UPDATE rounds SET chosensongs=1 WHERE
534 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
536 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
539 (SELECT player FROM players WHERE nick='Iris'),
542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
545 (SELECT player FROM players WHERE nick='Iris'),
547 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
550 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
553 (SELECT player FROM players WHERE nick='Iris'),
555 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
561 (SELECT player FROM players WHERE nick='Iris'),
563 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
569 (SELECT player FROM players WHERE nick='T|na'),
572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
575 (SELECT player FROM players WHERE nick='T|na'),
577 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
583 (SELECT player FROM players WHERE nick='T|na'),
585 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
591 (SELECT player FROM players WHERE nick='T|na'),
593 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
599 (SELECT player FROM players WHERE nick='OJK'),
602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
605 (SELECT player FROM players WHERE nick='OJK'),
607 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
613 (SELECT player FROM players WHERE nick='OJK'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
618 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
619 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
621 (SELECT player FROM players WHERE nick='OJK'),
623 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
629 (SELECT player FROM players WHERE nick='RiChY'),
632 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
635 (SELECT player FROM players WHERE nick='RiChY'),
637 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
640 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
643 (SELECT player FROM players WHERE nick='RiChY'),
645 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
648 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
649 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
651 (SELECT player FROM players WHERE nick='RiChY'),
653 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
656 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
659 (SELECT player FROM players WHERE nick='DufF'),
662 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
665 (SELECT player FROM players WHERE nick='DufF'),
667 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
670 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
671 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
673 (SELECT player FROM players WHERE nick='DufF'),
675 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
681 (SELECT player FROM players WHERE nick='DufF'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
686 INSERT INTO groups (tournament, round, parallel) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
689 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
692 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
694 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
697 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
699 UPDATE rounds SET randomsongs=2 WHERE
700 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
702 UPDATE rounds SET chosensongs=1 WHERE
703 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
705 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
708 (SELECT player FROM players WHERE nick='Stream'),
711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
714 (SELECT player FROM players WHERE nick='Stream'),
716 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
722 (SELECT player FROM players WHERE nick='Stream'),
724 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
730 (SELECT player FROM players WHERE nick='Stream'),
732 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
735 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
738 (SELECT player FROM players WHERE nick='Jannemor'),
741 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
744 (SELECT player FROM players WHERE nick='Jannemor'),
746 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
749 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
752 (SELECT player FROM players WHERE nick='Jannemor'),
754 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
757 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
758 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
760 (SELECT player FROM players WHERE nick='Jannemor'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
765 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
768 (SELECT player FROM players WHERE nick='Snofox'),
771 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
774 (SELECT player FROM players WHERE nick='Snofox'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
779 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
782 (SELECT player FROM players WHERE nick='Snofox'),
784 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
787 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
790 (SELECT player FROM players WHERE nick='Snofox'),
792 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
798 (SELECT player FROM players WHERE nick='Spinnvill'),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
804 (SELECT player FROM players WHERE nick='Spinnvill'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
812 (SELECT player FROM players WHERE nick='Spinnvill'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
820 (SELECT player FROM players WHERE nick='Spinnvill'),
822 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
828 (SELECT player FROM players WHERE nick='Havok'),
831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
834 (SELECT player FROM players WHERE nick='Havok'),
836 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
839 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
842 (SELECT player FROM players WHERE nick='Havok'),
844 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
847 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
850 (SELECT player FROM players WHERE nick='Havok'),
852 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
855 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
858 (SELECT player FROM players WHERE nick='Oliyzia'),
861 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
864 (SELECT player FROM players WHERE nick='Oliyzia'),
866 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
872 (SELECT player FROM players WHERE nick='Oliyzia'),
874 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
880 (SELECT player FROM players WHERE nick='Oliyzia'),
882 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
885 INSERT INTO groups (tournament, round, parallel) VALUES (
886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
888 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
889 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
891 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
893 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
896 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
898 UPDATE rounds SET randomsongs=2 WHERE
899 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
901 UPDATE rounds SET chosensongs=1 WHERE
902 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
904 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
907 (SELECT player FROM players WHERE nick='Benny'),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
913 (SELECT player FROM players WHERE nick='Benny'),
915 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
918 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
921 (SELECT player FROM players WHERE nick='Benny'),
923 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
929 (SELECT player FROM players WHERE nick='Benny'),
931 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
934 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
937 (SELECT player FROM players WHERE nick='Ylini'),
940 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
943 (SELECT player FROM players WHERE nick='Ylini'),
945 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
951 (SELECT player FROM players WHERE nick='Ylini'),
953 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
959 (SELECT player FROM players WHERE nick='Ylini'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
964 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
967 (SELECT player FROM players WHERE nick='Private Ryan'),
970 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
973 (SELECT player FROM players WHERE nick='Private Ryan'),
975 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
981 (SELECT player FROM players WHERE nick='Private Ryan'),
983 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
989 (SELECT player FROM players WHERE nick='Private Ryan'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
994 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
997 (SELECT player FROM players WHERE nick='ViD'),
1000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1003 (SELECT player FROM players WHERE nick='ViD'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1008 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1011 (SELECT player FROM players WHERE nick='ViD'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1016 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1017 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1019 (SELECT player FROM players WHERE nick='ViD'),
1021 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1024 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1027 (SELECT player FROM players WHERE nick='kjmcw'),
1030 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1031 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1033 (SELECT player FROM players WHERE nick='kjmcw'),
1035 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1038 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1039 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1041 (SELECT player FROM players WHERE nick='kjmcw'),
1043 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1046 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1047 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1049 (SELECT player FROM players WHERE nick='kjmcw'),
1051 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1055 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1057 (SELECT player FROM players WHERE nick='Draconia'),
1060 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1063 (SELECT player FROM players WHERE nick='Draconia'),
1065 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1071 (SELECT player FROM players WHERE nick='Draconia'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1079 (SELECT player FROM players WHERE nick='Draconia'),
1081 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1084 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1089 INSERT INTO groups (tournament, round, parallel) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1092 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1093 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1095 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
1097 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1098 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1100 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
1102 UPDATE rounds SET randomsongs=2 WHERE
1103 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1105 UPDATE rounds SET chosensongs=1 WHERE
1106 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1111 (SELECT player FROM players WHERE nick='Tha Dragon'),
1114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1115 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1117 (SELECT player FROM players WHERE nick='Tha Dragon'),
1119 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1125 (SELECT player FROM players WHERE nick='Tha Dragon'),
1127 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1133 (SELECT player FROM players WHERE nick='Tha Dragon'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1138 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1141 (SELECT player FROM players WHERE nick='Pfxp'),
1144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1147 (SELECT player FROM players WHERE nick='Pfxp'),
1149 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1155 (SELECT player FROM players WHERE nick='Pfxp'),
1157 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1163 (SELECT player FROM players WHERE nick='Pfxp'),
1165 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1169 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1171 (SELECT player FROM players WHERE nick='kjmcw'),
1174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1175 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1177 (SELECT player FROM players WHERE nick='kjmcw'),
1179 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1185 (SELECT player FROM players WHERE nick='kjmcw'),
1187 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1193 (SELECT player FROM players WHERE nick='kjmcw'),
1195 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1201 (SELECT player FROM players WHERE nick='Oliyzia'),
1204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1207 (SELECT player FROM players WHERE nick='Oliyzia'),
1209 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1215 (SELECT player FROM players WHERE nick='Oliyzia'),
1217 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1221 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1223 (SELECT player FROM players WHERE nick='Oliyzia'),
1225 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1231 (SELECT player FROM players WHERE nick='Tom'),
1234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1237 (SELECT player FROM players WHERE nick='Tom'),
1239 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1245 (SELECT player FROM players WHERE nick='Tom'),
1247 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1253 (SELECT player FROM players WHERE nick='Tom'),
1255 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1258 INSERT INTO groups (tournament, round, parallel) VALUES (
1259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1261 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1264 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
1266 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1269 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
1271 UPDATE rounds SET randomsongs=2 WHERE
1272 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1274 UPDATE rounds SET chosensongs=1 WHERE
1275 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1277 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1280 (SELECT player FROM players WHERE nick='ViD'),
1283 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1286 (SELECT player FROM players WHERE nick='ViD'),
1288 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1291 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1294 (SELECT player FROM players WHERE nick='ViD'),
1296 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1299 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1300 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1302 (SELECT player FROM players WHERE nick='ViD'),
1304 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1308 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1310 (SELECT player FROM players WHERE nick='T|na'),
1313 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1316 (SELECT player FROM players WHERE nick='T|na'),
1318 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1321 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1324 (SELECT player FROM players WHERE nick='T|na'),
1326 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1329 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1332 (SELECT player FROM players WHERE nick='T|na'),
1334 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1337 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1340 (SELECT player FROM players WHERE nick='Mulefisk'),
1343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1346 (SELECT player FROM players WHERE nick='Mulefisk'),
1348 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1354 (SELECT player FROM players WHERE nick='Mulefisk'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1359 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1362 (SELECT player FROM players WHERE nick='Mulefisk'),
1364 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1367 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1368 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1370 (SELECT player FROM players WHERE nick='Draconia'),
1373 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1376 (SELECT player FROM players WHERE nick='Draconia'),
1378 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1384 (SELECT player FROM players WHERE nick='Draconia'),
1386 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1392 (SELECT player FROM players WHERE nick='Draconia'),
1394 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1400 (SELECT player FROM players WHERE nick='OJK'),
1403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1406 (SELECT player FROM players WHERE nick='OJK'),
1408 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1414 (SELECT player FROM players WHERE nick='OJK'),
1416 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1422 (SELECT player FROM players WHERE nick='OJK'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1427 INSERT INTO groups (tournament, round, parallel) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1430 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1433 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1435 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1436 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1438 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
1440 UPDATE rounds SET randomsongs=2 WHERE
1441 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1443 UPDATE rounds SET chosensongs=1 WHERE
1444 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1446 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1447 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1449 (SELECT player FROM players WHERE nick='Telc'),
1452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1455 (SELECT player FROM players WHERE nick='Telc'),
1457 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1463 (SELECT player FROM players WHERE nick='Telc'),
1465 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1471 (SELECT player FROM players WHERE nick='Telc'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1479 (SELECT player FROM players WHERE nick='Stream'),
1482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1485 (SELECT player FROM players WHERE nick='Stream'),
1487 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1490 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1493 (SELECT player FROM players WHERE nick='Stream'),
1495 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1498 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1501 (SELECT player FROM players WHERE nick='Stream'),
1503 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1506 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1509 (SELECT player FROM players WHERE nick='Snofox'),
1512 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1515 (SELECT player FROM players WHERE nick='Snofox'),
1517 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1520 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1521 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1523 (SELECT player FROM players WHERE nick='Snofox'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1528 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1531 (SELECT player FROM players WHERE nick='Snofox'),
1533 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1536 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1539 (SELECT player FROM players WHERE nick='DufF'),
1542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1545 (SELECT player FROM players WHERE nick='DufF'),
1547 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1550 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1553 (SELECT player FROM players WHERE nick='DufF'),
1555 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1561 (SELECT player FROM players WHERE nick='DufF'),
1563 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1569 (SELECT player FROM players WHERE nick='Snute'),
1572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1575 (SELECT player FROM players WHERE nick='Snute'),
1577 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1583 (SELECT player FROM players WHERE nick='Snute'),
1585 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1591 (SELECT player FROM players WHERE nick='Snute'),
1593 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1596 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1601 INSERT INTO groups (tournament, round, parallel) VALUES (
1602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1604 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1607 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1609 UPDATE rounds SET randomsongs=1 WHERE
1610 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1612 UPDATE rounds SET chosensongs=1 WHERE
1613 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1615 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1618 (SELECT player FROM players WHERE nick='T|na'),
1621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1624 (SELECT player FROM players WHERE nick='T|na'),
1626 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1632 (SELECT player FROM players WHERE nick='T|na'),
1634 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1637 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1640 (SELECT player FROM players WHERE nick='Pfxp'),
1643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1646 (SELECT player FROM players WHERE nick='Pfxp'),
1648 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1651 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1654 (SELECT player FROM players WHERE nick='Pfxp'),
1656 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1659 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1660 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1662 (SELECT player FROM players WHERE nick='Snofox'),
1665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1668 (SELECT player FROM players WHERE nick='Snofox'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1673 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1676 (SELECT player FROM players WHERE nick='Snofox'),
1678 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1681 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1684 (SELECT player FROM players WHERE nick='DufF'),
1687 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1690 (SELECT player FROM players WHERE nick='DufF'),
1692 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1695 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1698 (SELECT player FROM players WHERE nick='DufF'),
1700 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1703 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1706 (SELECT player FROM players WHERE nick='ViD'),
1709 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1710 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1712 (SELECT player FROM players WHERE nick='ViD'),
1714 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1717 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1718 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1720 (SELECT player FROM players WHERE nick='ViD'),
1722 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1725 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1728 (SELECT player FROM players WHERE nick='Oliyzia'),
1731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1732 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1734 (SELECT player FROM players WHERE nick='Oliyzia'),
1736 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1739 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1740 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1742 (SELECT player FROM players WHERE nick='Oliyzia'),
1744 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1747 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1748 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1750 (SELECT player FROM players WHERE nick='OJK'),
1753 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1756 (SELECT player FROM players WHERE nick='OJK'),
1758 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1761 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1762 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1764 (SELECT player FROM players WHERE nick='OJK'),
1766 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1769 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1770 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1772 (SELECT player FROM players WHERE nick='Tom'),
1775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1778 (SELECT player FROM players WHERE nick='Tom'),
1780 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1786 (SELECT player FROM players WHERE nick='Tom'),
1788 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1791 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1794 (SELECT player FROM players WHERE nick='Snute'),
1797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1800 (SELECT player FROM players WHERE nick='Snute'),
1802 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1808 (SELECT player FROM players WHERE nick='Snute'),
1810 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1813 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1815 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' 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 7' 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 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1824 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
1826 UPDATE rounds SET randomsongs=1 WHERE
1827 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' 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 7' 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 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1835 (SELECT player FROM players WHERE nick='T|na'),
1838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1841 (SELECT player FROM players WHERE nick='T|na'),
1843 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1849 (SELECT player FROM players WHERE nick='T|na'),
1851 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1857 (SELECT player FROM players WHERE nick='Oliyzia'),
1860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1863 (SELECT player FROM players WHERE nick='Oliyzia'),
1865 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1871 (SELECT player FROM players WHERE nick='Oliyzia'),
1873 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1876 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1879 (SELECT player FROM players WHERE nick='Snofox'),
1882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1885 (SELECT player FROM players WHERE nick='Snofox'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1893 (SELECT player FROM players WHERE nick='Snofox'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1901 (SELECT player FROM players WHERE nick='OJK'),
1904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1907 (SELECT player FROM players WHERE nick='OJK'),
1909 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1913 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1915 (SELECT player FROM players WHERE nick='OJK'),
1917 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1923 (SELECT player FROM players WHERE nick='DufF'),
1926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1929 (SELECT player FROM players WHERE nick='DufF'),
1931 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1937 (SELECT player FROM players WHERE nick='DufF'),
1939 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1942 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1943 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1945 (SELECT player FROM players WHERE nick='Tom'),
1948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1951 (SELECT player FROM players WHERE nick='Tom'),
1953 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1959 (SELECT player FROM players WHERE nick='Tom'),
1961 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1964 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' 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 7' 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('Secret Rendez-vous')),
1978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' 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('So Deep (Perfect Sphere Mix)')),
1986 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1991 INSERT INTO groups (tournament, round, parallel) VALUES (
1992 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1994 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1997 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1999 UPDATE rounds SET randomsongs=1 WHERE
2000 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2002 UPDATE rounds SET chosensongs=1 WHERE
2003 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2005 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2006 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2008 (SELECT player FROM players WHERE nick='OJK'),
2011 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2012 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2014 (SELECT player FROM players WHERE nick='OJK'),
2016 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2019 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2020 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2022 (SELECT player FROM players WHERE nick='OJK'),
2024 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2027 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2028 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2030 (SELECT player FROM players WHERE nick='DufF'),
2033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2036 (SELECT player FROM players WHERE nick='DufF'),
2038 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2041 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2044 (SELECT player FROM players WHERE nick='DufF'),
2046 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2049 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2052 (SELECT player FROM players WHERE nick='Tom'),
2055 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2056 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2058 (SELECT player FROM players WHERE nick='Tom'),
2060 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2064 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2066 (SELECT player FROM players WHERE nick='Tom'),
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 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2074 (SELECT player FROM players WHERE nick='Oliyzia'),
2077 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2080 (SELECT player FROM players WHERE nick='Oliyzia'),
2082 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2085 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2088 (SELECT player FROM players WHERE nick='Oliyzia'),
2090 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2093 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2096 (SELECT player FROM players WHERE nick='Snute'),
2099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2102 (SELECT player FROM players WHERE nick='Snute'),
2104 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2110 (SELECT player FROM players WHERE nick='Snute'),
2112 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2115 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2120 INSERT INTO groups (tournament, round, parallel) VALUES (
2121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2123 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2126 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
2128 UPDATE rounds SET randomsongs=1 WHERE
2129 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2131 UPDATE rounds SET chosensongs=1 WHERE
2132 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2134 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2137 (SELECT player FROM players WHERE nick='Tom'),
2140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2143 (SELECT player FROM players WHERE nick='Tom'),
2145 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2151 (SELECT player FROM players WHERE nick='Tom'),
2153 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2156 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2159 (SELECT player FROM players WHERE nick='OJK'),
2162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2163 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2165 (SELECT player FROM players WHERE nick='OJK'),
2167 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2173 (SELECT player FROM players WHERE nick='OJK'),
2175 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2178 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2181 (SELECT player FROM players WHERE nick='DufF'),
2184 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2185 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2187 (SELECT player FROM players WHERE nick='DufF'),
2189 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2195 (SELECT player FROM players WHERE nick='DufF'),
2197 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2200 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2203 (SELECT player FROM players WHERE nick='Snute'),
2206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2209 (SELECT player FROM players WHERE nick='Snute'),
2211 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2217 (SELECT player FROM players WHERE nick='Snute'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2222 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2227 INSERT INTO groups (tournament, round, parallel) VALUES (
2228 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2233 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
2235 UPDATE rounds SET randomsongs=1 WHERE
2236 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2238 UPDATE rounds SET chosensongs=1 WHERE
2239 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2244 (SELECT player FROM players WHERE nick='DufF'),
2247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2250 (SELECT player FROM players WHERE nick='DufF'),
2252 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2256 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2258 (SELECT player FROM players WHERE nick='DufF'),
2260 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2263 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2266 (SELECT player FROM players WHERE nick='Snute'),
2269 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2270 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2272 (SELECT player FROM players WHERE nick='Snute'),
2274 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2277 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2280 (SELECT player FROM players WHERE nick='Snute'),
2282 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2285 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2286 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2288 (SELECT player FROM players WHERE nick='Tom'),
2291 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2294 (SELECT player FROM players WHERE nick='Tom'),
2296 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2299 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2300 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2302 (SELECT player FROM players WHERE nick='Tom'),
2304 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2307 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2309 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2312 INSERT INTO groups (tournament, round, parallel) VALUES (
2313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2315 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2316 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2318 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
2320 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2323 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2325 UPDATE rounds SET randomsongs=2 WHERE
2326 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2328 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2331 (SELECT player FROM players WHERE nick='Tom'),
2334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2337 (SELECT player FROM players WHERE nick='Tom'),
2339 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
2342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2345 (SELECT player FROM players WHERE nick='Tom'),
2347 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2350 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2353 (SELECT player FROM players WHERE nick='Snute'),
2356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2359 (SELECT player FROM players WHERE nick='Snute'),
2361 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
2364 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2367 (SELECT player FROM players WHERE nick='Snute'),
2369 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),