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 4' 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
28 (SELECT player FROM players WHERE nick='Oliyzia'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
34 (SELECT player FROM players WHERE nick='Daniil'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
40 (SELECT player FROM players WHERE nick='DufF'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
46 (SELECT player FROM players WHERE nick='kjmcw'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
52 (SELECT player FROM players WHERE nick='Draconia'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
58 (SELECT player FROM players WHERE nick='Slusk'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='Yeye'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='Telc'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
76 (SELECT player FROM players WHERE nick='ViD'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='RiChY'),
84 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 );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='Snofox'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='Matsi'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Havok'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lykkesopp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lykkesopp' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='Lykkesopp'),
108 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 );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
112 (SELECT player FROM players WHERE nick='Smiph'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
118 (SELECT player FROM players WHERE nick='Vampyro'),
120 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 );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
124 (SELECT player FROM players WHERE nick='Pfxp'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
130 (SELECT player FROM players WHERE nick='Purity'),
132 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 );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
136 (SELECT player FROM players WHERE nick='Mulefisk'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
142 (SELECT player FROM players WHERE nick='Magnar'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electus' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
148 (SELECT player FROM players WHERE nick='Electus'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
154 (SELECT player FROM players WHERE nick='Advena'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
160 (SELECT player FROM players WHERE nick='FantNo'),
162 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 );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
166 (SELECT player FROM players WHERE nick='Indy'),
168 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 );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
172 (SELECT player FROM players WHERE nick='T|na'),
174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ink' NOT IN ( SELECT nick FROM players );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
178 (SELECT player FROM players WHERE nick='Ink'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
184 (SELECT player FROM players WHERE nick='Lejordet'),
186 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 );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
190 (SELECT player FROM players WHERE nick='Private Ryan'),
192 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 );
193 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
196 (SELECT player FROM players WHERE nick='Spinnvill'),
198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players );
199 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
202 (SELECT player FROM players WHERE nick='Cyanid'),
204 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
209 INSERT INTO groups (tournament, round, parallel) VALUES (
210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
212 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
215 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
217 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
220 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
222 UPDATE rounds SET randomsongs=2 WHERE
223 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
225 UPDATE rounds SET chosensongs=1 WHERE
226 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
231 (SELECT player FROM players WHERE nick='Private Ryan'),
234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
237 (SELECT player FROM players WHERE nick='Private Ryan'),
239 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
245 (SELECT player FROM players WHERE nick='Private Ryan'),
247 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
253 (SELECT player FROM players WHERE nick='Private Ryan'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
258 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
261 (SELECT player FROM players WHERE nick='Advena'),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
267 (SELECT player FROM players WHERE nick='Advena'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
272 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
275 (SELECT player FROM players WHERE nick='Advena'),
277 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
280 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
283 (SELECT player FROM players WHERE nick='Advena'),
285 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
288 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4' 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('Tsugaru')),
302 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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('Test My Best')),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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('Dead End')),
318 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
321 (SELECT player FROM players WHERE nick='Havok'),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
327 (SELECT player FROM players WHERE nick='Havok'),
329 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
335 (SELECT player FROM players WHERE nick='Havok'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
343 (SELECT player FROM players WHERE nick='Havok'),
345 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
348 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
351 (SELECT player FROM players WHERE nick='Tom'),
354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
357 (SELECT player FROM players WHERE nick='Tom'),
359 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
362 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
365 (SELECT player FROM players WHERE nick='Tom'),
367 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
373 (SELECT player FROM players WHERE nick='Tom'),
375 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
378 INSERT INTO groups (tournament, round, parallel) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
381 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
384 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
386 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
387 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
389 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
391 UPDATE rounds SET randomsongs=2 WHERE
392 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
394 UPDATE rounds SET chosensongs=1 WHERE
395 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
400 (SELECT player FROM players WHERE nick='ViD'),
403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
406 (SELECT player FROM players WHERE nick='ViD'),
408 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
414 (SELECT player FROM players WHERE nick='ViD'),
416 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
422 (SELECT player FROM players WHERE nick='ViD'),
424 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
430 (SELECT player FROM players WHERE nick='Electus'),
433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
436 (SELECT player FROM players WHERE nick='Electus'),
438 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
444 (SELECT player FROM players WHERE nick='Electus'),
446 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
449 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
452 (SELECT player FROM players WHERE nick='Electus'),
454 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
457 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
460 (SELECT player FROM players WHERE nick='RiChY'),
463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
466 (SELECT player FROM players WHERE nick='RiChY'),
468 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
471 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
472 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
474 (SELECT player FROM players WHERE nick='RiChY'),
476 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
479 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
480 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
482 (SELECT player FROM players WHERE nick='RiChY'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
487 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
490 (SELECT player FROM players WHERE nick='Lejordet'),
493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
496 (SELECT player FROM players WHERE nick='Lejordet'),
498 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
504 (SELECT player FROM players WHERE nick='Lejordet'),
506 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
512 (SELECT player FROM players WHERE nick='Lejordet'),
514 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
517 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
520 (SELECT player FROM players WHERE nick='Snute'),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
526 (SELECT player FROM players WHERE nick='Snute'),
528 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
534 (SELECT player FROM players WHERE nick='Snute'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
542 (SELECT player FROM players WHERE nick='Snute'),
544 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
547 INSERT INTO groups (tournament, round, parallel) VALUES (
548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
550 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
553 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
555 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
558 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
560 UPDATE rounds SET randomsongs=2 WHERE
561 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
563 UPDATE rounds SET chosensongs=1 WHERE
564 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
569 (SELECT player FROM players WHERE nick='FantNo'),
572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
575 (SELECT player FROM players WHERE nick='FantNo'),
577 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
583 (SELECT player FROM players WHERE nick='FantNo'),
585 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
591 (SELECT player FROM players WHERE nick='FantNo'),
593 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
599 (SELECT player FROM players WHERE nick='Snofox'),
602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
605 (SELECT player FROM players WHERE nick='Snofox'),
607 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
613 (SELECT player FROM players WHERE nick='Snofox'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
618 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
619 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
621 (SELECT player FROM players WHERE nick='Snofox'),
623 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
629 (SELECT player FROM players WHERE nick='Mulefisk'),
632 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
635 (SELECT player FROM players WHERE nick='Mulefisk'),
637 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
640 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
643 (SELECT player FROM players WHERE nick='Mulefisk'),
645 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
648 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
649 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
651 (SELECT player FROM players WHERE nick='Mulefisk'),
653 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
656 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
659 (SELECT player FROM players WHERE nick='kjmcw'),
662 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
665 (SELECT player FROM players WHERE nick='kjmcw'),
667 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
670 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
671 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
673 (SELECT player FROM players WHERE nick='kjmcw'),
675 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
681 (SELECT player FROM players WHERE nick='kjmcw'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
686 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
689 (SELECT player FROM players WHERE nick='Daniil'),
692 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
695 (SELECT player FROM players WHERE nick='Daniil'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
701 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
703 (SELECT player FROM players WHERE nick='Daniil'),
705 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
711 (SELECT player FROM players WHERE nick='Daniil'),
713 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
716 INSERT INTO groups (tournament, round, parallel) VALUES (
717 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
719 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
722 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
724 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
725 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
727 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
729 UPDATE rounds SET randomsongs=2 WHERE
730 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
732 UPDATE rounds SET chosensongs=1 WHERE
733 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
735 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
738 (SELECT player FROM players WHERE nick='T|na'),
741 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
744 (SELECT player FROM players WHERE nick='T|na'),
746 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
749 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
752 (SELECT player FROM players WHERE nick='T|na'),
754 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
757 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
758 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
760 (SELECT player FROM players WHERE nick='T|na'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
765 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
768 (SELECT player FROM players WHERE nick='Magnar'),
771 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
774 (SELECT player FROM players WHERE nick='Magnar'),
776 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
779 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
782 (SELECT player FROM players WHERE nick='Magnar'),
784 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
787 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
790 (SELECT player FROM players WHERE nick='Magnar'),
792 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
798 (SELECT player FROM players WHERE nick='Vampyro'),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
804 (SELECT player FROM players WHERE nick='Vampyro'),
806 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
812 (SELECT player FROM players WHERE nick='Vampyro'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
820 (SELECT player FROM players WHERE nick='Vampyro'),
822 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
828 (SELECT player FROM players WHERE nick='Yeye'),
831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
834 (SELECT player FROM players WHERE nick='Yeye'),
836 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
839 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
842 (SELECT player FROM players WHERE nick='Yeye'),
844 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
847 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
850 (SELECT player FROM players WHERE nick='Yeye'),
852 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
855 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
858 (SELECT player FROM players WHERE nick='DufF'),
861 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
864 (SELECT player FROM players WHERE nick='DufF'),
866 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
872 (SELECT player FROM players WHERE nick='DufF'),
874 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
880 (SELECT player FROM players WHERE nick='DufF'),
882 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
885 INSERT INTO groups (tournament, round, parallel) VALUES (
886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
891 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
893 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
896 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
898 UPDATE rounds SET randomsongs=2 WHERE
899 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4' 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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
907 (SELECT player FROM players WHERE nick='Pfxp'),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
913 (SELECT player FROM players WHERE nick='Pfxp'),
915 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
918 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
921 (SELECT player FROM players WHERE nick='Pfxp'),
923 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
929 (SELECT player FROM players WHERE nick='Pfxp'),
931 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
934 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
937 (SELECT player FROM players WHERE nick='Ink'),
940 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
943 (SELECT player FROM players WHERE nick='Ink'),
945 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
951 (SELECT player FROM players WHERE nick='Ink'),
953 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
959 (SELECT player FROM players WHERE nick='Ink'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
964 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
967 (SELECT player FROM players WHERE nick='Cyanid'),
970 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
973 (SELECT player FROM players WHERE nick='Cyanid'),
975 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
981 (SELECT player FROM players WHERE nick='Cyanid'),
983 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
989 (SELECT player FROM players WHERE nick='Cyanid'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
994 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
997 (SELECT player FROM players WHERE nick='Matsi'),
1000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1003 (SELECT player FROM players WHERE nick='Matsi'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1008 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1011 (SELECT player FROM players WHERE nick='Matsi'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1016 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1017 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1019 (SELECT player FROM players WHERE nick='Matsi'),
1021 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1024 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1027 (SELECT player FROM players WHERE nick='Slusk'),
1030 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1031 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1033 (SELECT player FROM players WHERE nick='Slusk'),
1035 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1038 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1039 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1041 (SELECT player FROM players WHERE nick='Slusk'),
1043 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1046 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1047 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1049 (SELECT player FROM players WHERE nick='Slusk'),
1051 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1055 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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 4' 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('Can\'t Stop Fallin\' in Love')),
1068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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('Make A Jam!')),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' 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('Jam Jam Reggae (AM Swing Mix)')),
1084 INSERT INTO groups (tournament, round, parallel) VALUES (
1085 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1087 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1090 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
1092 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1093 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1095 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1097 UPDATE rounds SET randomsongs=2 WHERE
1098 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1100 UPDATE rounds SET chosensongs=1 WHERE
1101 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1103 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1106 (SELECT player FROM players WHERE nick='Lykkesopp'),
1109 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1112 (SELECT player FROM players WHERE nick='Lykkesopp'),
1114 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1120 (SELECT player FROM players WHERE nick='Lykkesopp'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1128 (SELECT player FROM players WHERE nick='Lykkesopp'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1133 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1136 (SELECT player FROM players WHERE nick='Indy'),
1139 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1142 (SELECT player FROM players WHERE nick='Indy'),
1144 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1147 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1150 (SELECT player FROM players WHERE nick='Indy'),
1152 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1155 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1158 (SELECT player FROM players WHERE nick='Indy'),
1160 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1163 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1166 (SELECT player FROM players WHERE nick='Spinnvill'),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1172 (SELECT player FROM players WHERE nick='Spinnvill'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1180 (SELECT player FROM players WHERE nick='Spinnvill'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1186 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1188 (SELECT player FROM players WHERE nick='Spinnvill'),
1190 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1193 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1196 (SELECT player FROM players WHERE nick='Purity'),
1199 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1202 (SELECT player FROM players WHERE nick='Purity'),
1204 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1207 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1210 (SELECT player FROM players WHERE nick='Purity'),
1212 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1215 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1218 (SELECT player FROM players WHERE nick='Purity'),
1220 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1226 (SELECT player FROM players WHERE nick='Telc'),
1229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1232 (SELECT player FROM players WHERE nick='Telc'),
1234 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1240 (SELECT player FROM players WHERE nick='Telc'),
1242 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1245 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1248 (SELECT player FROM players WHERE nick='Telc'),
1250 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1253 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1256 (SELECT player FROM players WHERE nick='Oliyzia'),
1259 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1262 (SELECT player FROM players WHERE nick='Oliyzia'),
1264 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1267 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1268 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1270 (SELECT player FROM players WHERE nick='Oliyzia'),
1272 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1275 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1276 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1278 (SELECT player FROM players WHERE nick='Oliyzia'),
1280 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1283 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1288 INSERT INTO groups (tournament, round, parallel) VALUES (
1289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1291 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1294 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1296 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1299 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
1301 UPDATE rounds SET randomsongs=2 WHERE
1302 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1304 UPDATE rounds SET chosensongs=1 WHERE
1305 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1308 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1310 (SELECT player FROM players WHERE nick='Smiph'),
1313 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1316 (SELECT player FROM players WHERE nick='Smiph'),
1318 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1321 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1324 (SELECT player FROM players WHERE nick='Smiph'),
1326 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1329 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1332 (SELECT player FROM players WHERE nick='Smiph'),
1334 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1337 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1340 (SELECT player FROM players WHERE nick='Yeye'),
1343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1346 (SELECT player FROM players WHERE nick='Yeye'),
1348 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1354 (SELECT player FROM players WHERE nick='Yeye'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1359 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1362 (SELECT player FROM players WHERE nick='Yeye'),
1364 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1367 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1368 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1370 (SELECT player FROM players WHERE nick='Snofox'),
1373 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1376 (SELECT player FROM players WHERE nick='Snofox'),
1378 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1384 (SELECT player FROM players WHERE nick='Snofox'),
1386 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1392 (SELECT player FROM players WHERE nick='Snofox'),
1394 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1400 (SELECT player FROM players WHERE nick='ViD'),
1403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1406 (SELECT player FROM players WHERE nick='ViD'),
1408 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1412 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1414 (SELECT player FROM players WHERE nick='ViD'),
1416 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1422 (SELECT player FROM players WHERE nick='ViD'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1427 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1430 (SELECT player FROM players WHERE nick='Draconia'),
1433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1436 (SELECT player FROM players WHERE nick='Draconia'),
1438 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1444 (SELECT player FROM players WHERE nick='Draconia'),
1446 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1449 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1452 (SELECT player FROM players WHERE nick='Draconia'),
1454 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1457 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1460 (SELECT player FROM players WHERE nick='Tom'),
1463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1466 (SELECT player FROM players WHERE nick='Tom'),
1468 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1471 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1472 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1474 (SELECT player FROM players WHERE nick='Tom'),
1476 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1479 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1480 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1482 (SELECT player FROM players WHERE nick='Tom'),
1484 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
1487 INSERT INTO groups (tournament, round, parallel) VALUES (
1488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1490 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1493 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1495 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1498 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1500 UPDATE rounds SET randomsongs=2 WHERE
1501 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1503 UPDATE rounds SET chosensongs=1 WHERE
1504 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1506 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1509 (SELECT player FROM players WHERE nick='Daniil'),
1512 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1515 (SELECT player FROM players WHERE nick='Daniil'),
1517 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1520 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1521 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1523 (SELECT player FROM players WHERE nick='Daniil'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1528 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1531 (SELECT player FROM players WHERE nick='Daniil'),
1533 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1536 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1539 (SELECT player FROM players WHERE nick='RiChY'),
1542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1545 (SELECT player FROM players WHERE nick='RiChY'),
1547 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1550 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1553 (SELECT player FROM players WHERE nick='RiChY'),
1555 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1561 (SELECT player FROM players WHERE nick='RiChY'),
1563 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1569 (SELECT player FROM players WHERE nick='Havok'),
1572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1575 (SELECT player FROM players WHERE nick='Havok'),
1577 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1583 (SELECT player FROM players WHERE nick='Havok'),
1585 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1591 (SELECT player FROM players WHERE nick='Havok'),
1593 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1596 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1599 (SELECT player FROM players WHERE nick='Vampyro'),
1602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1605 (SELECT player FROM players WHERE nick='Vampyro'),
1607 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1613 (SELECT player FROM players WHERE nick='Vampyro'),
1615 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1618 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1619 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1621 (SELECT player FROM players WHERE nick='Vampyro'),
1623 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1629 (SELECT player FROM players WHERE nick='DufF'),
1632 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1635 (SELECT player FROM players WHERE nick='DufF'),
1637 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1640 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1643 (SELECT player FROM players WHERE nick='DufF'),
1645 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1648 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1649 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1651 (SELECT player FROM players WHERE nick='DufF'),
1653 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1656 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1659 (SELECT player FROM players WHERE nick='Oliyzia'),
1662 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1665 (SELECT player FROM players WHERE nick='Oliyzia'),
1667 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1670 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1671 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1673 (SELECT player FROM players WHERE nick='Oliyzia'),
1675 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1679 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1681 (SELECT player FROM players WHERE nick='Oliyzia'),
1683 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1686 INSERT INTO groups (tournament, round, parallel) VALUES (
1687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1689 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1692 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1694 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1697 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1699 UPDATE rounds SET randomsongs=2 WHERE
1700 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1702 UPDATE rounds SET chosensongs=1 WHERE
1703 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1705 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1708 (SELECT player FROM players WHERE nick='Matsi'),
1711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1714 (SELECT player FROM players WHERE nick='Matsi'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1722 (SELECT player FROM players WHERE nick='Matsi'),
1724 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1730 (SELECT player FROM players WHERE nick='Matsi'),
1732 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1735 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1738 (SELECT player FROM players WHERE nick='Telc'),
1741 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1744 (SELECT player FROM players WHERE nick='Telc'),
1746 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1749 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1750 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1752 (SELECT player FROM players WHERE nick='Telc'),
1754 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1757 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1758 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1760 (SELECT player FROM players WHERE nick='Telc'),
1762 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1765 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1768 (SELECT player FROM players WHERE nick='Lykkesopp'),
1771 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1774 (SELECT player FROM players WHERE nick='Lykkesopp'),
1776 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1779 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1780 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1782 (SELECT player FROM players WHERE nick='Lykkesopp'),
1784 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1787 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1790 (SELECT player FROM players WHERE nick='Lykkesopp'),
1792 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1798 (SELECT player FROM players WHERE nick='Slusk'),
1801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1804 (SELECT player FROM players WHERE nick='Slusk'),
1806 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1812 (SELECT player FROM players WHERE nick='Slusk'),
1814 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1820 (SELECT player FROM players WHERE nick='Slusk'),
1822 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1828 (SELECT player FROM players WHERE nick='kjmcw'),
1831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1834 (SELECT player FROM players WHERE nick='kjmcw'),
1836 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1839 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1840 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1842 (SELECT player FROM players WHERE nick='kjmcw'),
1844 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1847 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1848 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1850 (SELECT player FROM players WHERE nick='kjmcw'),
1852 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1855 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1858 (SELECT player FROM players WHERE nick='Snute'),
1861 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1864 (SELECT player FROM players WHERE nick='Snute'),
1866 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1872 (SELECT player FROM players WHERE nick='Snute'),
1874 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1880 (SELECT player FROM players WHERE nick='Snute'),
1882 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1885 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1887 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1890 INSERT INTO groups (tournament, round, parallel) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1893 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1896 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
1898 UPDATE rounds SET randomsongs=1 WHERE
1899 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1901 UPDATE rounds SET chosensongs=1 WHERE
1902 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1904 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1907 (SELECT player FROM players WHERE nick='Slusk'),
1910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1913 (SELECT player FROM players WHERE nick='Slusk'),
1915 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1918 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1919 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1921 (SELECT player FROM players WHERE nick='Slusk'),
1923 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1926 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1929 (SELECT player FROM players WHERE nick='Yeye'),
1932 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1933 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1935 (SELECT player FROM players WHERE nick='Yeye'),
1937 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1940 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1943 (SELECT player FROM players WHERE nick='Yeye'),
1945 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1948 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1951 (SELECT player FROM players WHERE nick='Daniil'),
1954 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1955 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1957 (SELECT player FROM players WHERE nick='Daniil'),
1959 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1962 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1965 (SELECT player FROM players WHERE nick='Daniil'),
1967 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1970 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1973 (SELECT player FROM players WHERE nick='kjmcw'),
1976 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1979 (SELECT player FROM players WHERE nick='kjmcw'),
1981 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1984 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1985 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1987 (SELECT player FROM players WHERE nick='kjmcw'),
1989 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1992 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1995 (SELECT player FROM players WHERE nick='Draconia'),
1998 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1999 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2001 (SELECT player FROM players WHERE nick='Draconia'),
2003 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2009 (SELECT player FROM players WHERE nick='Draconia'),
2011 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2014 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2017 (SELECT player FROM players WHERE nick='Oliyzia'),
2020 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2021 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2023 (SELECT player FROM players WHERE nick='Oliyzia'),
2025 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2029 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2031 (SELECT player FROM players WHERE nick='Oliyzia'),
2033 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2039 (SELECT player FROM players WHERE nick='Tom'),
2042 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2043 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2045 (SELECT player FROM players WHERE nick='Tom'),
2047 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2050 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2053 (SELECT player FROM players WHERE nick='Tom'),
2055 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2058 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2059 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2061 (SELECT player FROM players WHERE nick='DufF'),
2064 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2067 (SELECT player FROM players WHERE nick='DufF'),
2069 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2073 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2075 (SELECT player FROM players WHERE nick='DufF'),
2077 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2080 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2083 (SELECT player FROM players WHERE nick='Snute'),
2086 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2087 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2089 (SELECT player FROM players WHERE nick='Snute'),
2091 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
2094 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2095 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2097 (SELECT player FROM players WHERE nick='Snute'),
2099 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2102 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2107 INSERT INTO groups (tournament, round, parallel) VALUES (
2108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2110 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2111 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2113 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
2115 UPDATE rounds SET randomsongs=1 WHERE
2116 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2118 UPDATE rounds SET chosensongs=1 WHERE
2119 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2124 (SELECT player FROM players WHERE nick='Draconia'),
2127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2130 (SELECT player FROM players WHERE nick='Draconia'),
2132 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2138 (SELECT player FROM players WHERE nick='Draconia'),
2140 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2143 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2146 (SELECT player FROM players WHERE nick='Oliyzia'),
2149 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2150 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2152 (SELECT player FROM players WHERE nick='Oliyzia'),
2154 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2160 (SELECT player FROM players WHERE nick='Oliyzia'),
2162 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2165 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2168 (SELECT player FROM players WHERE nick='Daniil'),
2171 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2172 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2174 (SELECT player FROM players WHERE nick='Daniil'),
2176 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2179 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2182 (SELECT player FROM players WHERE nick='Daniil'),
2184 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2187 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2190 (SELECT player FROM players WHERE nick='kjmcw'),
2193 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2196 (SELECT player FROM players WHERE nick='kjmcw'),
2198 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2201 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2202 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2204 (SELECT player FROM players WHERE nick='kjmcw'),
2206 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2209 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2212 (SELECT player FROM players WHERE nick='Snute'),
2215 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2218 (SELECT player FROM players WHERE nick='Snute'),
2220 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2223 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2226 (SELECT player FROM players WHERE nick='Snute'),
2228 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2231 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2232 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2234 (SELECT player FROM players WHERE nick='Tom'),
2237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2240 (SELECT player FROM players WHERE nick='Tom'),
2242 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2245 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2248 (SELECT player FROM players WHERE nick='Tom'),
2250 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2253 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2256 (SELECT player FROM players WHERE nick='DufF'),
2259 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2262 (SELECT player FROM players WHERE nick='DufF'),
2264 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2267 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2268 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2270 (SELECT player FROM players WHERE nick='DufF'),
2272 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2275 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2280 INSERT INTO groups (tournament, round, parallel) VALUES (
2281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2283 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2286 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
2288 UPDATE rounds SET randomsongs=1 WHERE
2289 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2291 UPDATE rounds SET chosensongs=1 WHERE
2292 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2294 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2297 (SELECT player FROM players WHERE nick='DufF'),
2300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2303 (SELECT player FROM players WHERE nick='DufF'),
2305 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2309 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2311 (SELECT player FROM players WHERE nick='DufF'),
2313 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2316 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2319 (SELECT player FROM players WHERE nick='Oliyzia'),
2322 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2323 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2325 (SELECT player FROM players WHERE nick='Oliyzia'),
2327 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2330 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2333 (SELECT player FROM players WHERE nick='Oliyzia'),
2335 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2338 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2339 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2341 (SELECT player FROM players WHERE nick='Daniil'),
2344 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2345 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2347 (SELECT player FROM players WHERE nick='Daniil'),
2349 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2352 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2353 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2355 (SELECT player FROM players WHERE nick='Daniil'),
2357 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2360 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2363 (SELECT player FROM players WHERE nick='Tom'),
2366 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2369 (SELECT player FROM players WHERE nick='Tom'),
2371 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2377 (SELECT player FROM players WHERE nick='Tom'),
2379 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
2382 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2383 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2385 (SELECT player FROM players WHERE nick='Snute'),
2388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2391 (SELECT player FROM players WHERE nick='Snute'),
2393 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2396 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2399 (SELECT player FROM players WHERE nick='Snute'),
2401 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2404 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2409 INSERT INTO groups (tournament, round, parallel) VALUES (
2410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2412 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2413 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2415 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
2417 UPDATE rounds SET randomsongs=1 WHERE
2418 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2420 UPDATE rounds SET chosensongs=1 WHERE
2421 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2423 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2426 (SELECT player FROM players WHERE nick='Snute'),
2429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2430 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2432 (SELECT player FROM players WHERE nick='Snute'),
2434 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2438 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2440 (SELECT player FROM players WHERE nick='Snute'),
2442 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2448 (SELECT player FROM players WHERE nick='Oliyzia'),
2451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2454 (SELECT player FROM players WHERE nick='Oliyzia'),
2456 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2462 (SELECT player FROM players WHERE nick='Oliyzia'),
2464 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2470 (SELECT player FROM players WHERE nick='Daniil'),
2473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2474 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2476 (SELECT player FROM players WHERE nick='Daniil'),
2478 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2484 (SELECT player FROM players WHERE nick='Daniil'),
2486 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2489 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2492 (SELECT player FROM players WHERE nick='Tom'),
2495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2498 (SELECT player FROM players WHERE nick='Tom'),
2500 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2506 (SELECT player FROM players WHERE nick='Tom'),
2508 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2511 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2516 INSERT INTO groups (tournament, round, parallel) VALUES (
2517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2519 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2522 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
2524 UPDATE rounds SET randomsongs=1 WHERE
2525 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2527 UPDATE rounds SET chosensongs=1 WHERE
2528 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2530 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2533 (SELECT player FROM players WHERE nick='Oliyzia'),
2536 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2539 (SELECT player FROM players WHERE nick='Oliyzia'),
2541 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
2544 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2545 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2547 (SELECT player FROM players WHERE nick='Oliyzia'),
2549 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2552 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2553 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2555 (SELECT player FROM players WHERE nick='Snute'),
2558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2561 (SELECT player FROM players WHERE nick='Snute'),
2563 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
2566 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2569 (SELECT player FROM players WHERE nick='Snute'),
2571 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2575 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2577 (SELECT player FROM players WHERE nick='Tom'),
2580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2581 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2583 (SELECT player FROM players WHERE nick='Tom'),
2585 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
2588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2591 (SELECT player FROM players WHERE nick='Tom'),
2593 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2596 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2601 INSERT INTO groups (tournament, round, parallel) VALUES (
2602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2604 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2607 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
2609 UPDATE rounds SET randomsongs=1 WHERE
2610 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2612 UPDATE rounds SET chosensongs=1 WHERE
2613 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
2615 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2618 (SELECT player FROM players WHERE nick='Snute'),
2621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2624 (SELECT player FROM players WHERE nick='Snute'),
2626 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
2629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2632 (SELECT player FROM players WHERE nick='Snute'),
2634 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2637 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2640 (SELECT player FROM players WHERE nick='Tom'),
2643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2646 (SELECT player FROM players WHERE nick='Tom'),
2648 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
2651 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
2654 (SELECT player FROM players WHERE nick='Tom'),
2656 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),