2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
16 (SELECT player FROM players WHERE nick='Snute'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
22 (SELECT player FROM players WHERE nick='Th0rny'),
24 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 );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
28 (SELECT player FROM players WHERE nick='Tom'),
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 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
34 (SELECT player FROM players WHERE nick='Daniil'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
40 (SELECT player FROM players WHERE nick='Oliyzia'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
46 (SELECT player FROM players WHERE nick='Draconia'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
52 (SELECT player FROM players WHERE nick='DufF'),
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 2' 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, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
64 (SELECT player FROM players WHERE nick='Telc'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
70 (SELECT player FROM players WHERE nick='RiChY'),
72 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 );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
76 (SELECT player FROM players WHERE nick='Yeye'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
82 (SELECT player FROM players WHERE nick='Havok'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mario' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
88 (SELECT player FROM players WHERE nick='Mario'),
90 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 );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
94 (SELECT player FROM players WHERE nick='kjmcw'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
100 (SELECT player FROM players WHERE nick='Lejordet'),
102 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 );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
106 (SELECT player FROM players WHERE nick='Matsi'),
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 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
112 (SELECT player FROM players WHERE nick='Smiph'),
114 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
119 INSERT INTO groups (tournament, round, parallel) VALUES (
120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
122 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
125 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
127 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
130 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
132 UPDATE rounds SET randomsongs=2 WHERE
133 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
135 UPDATE rounds SET chosensongs=1 WHERE
136 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
138 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
141 (SELECT player FROM players WHERE nick='Havok'),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
147 (SELECT player FROM players WHERE nick='Havok'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
155 (SELECT player FROM players WHERE nick='Havok'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
163 (SELECT player FROM players WHERE nick='Havok'),
165 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
169 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
171 (SELECT player FROM players WHERE nick='Lejordet'),
174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
177 (SELECT player FROM players WHERE nick='Lejordet'),
179 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
185 (SELECT player FROM players WHERE nick='Lejordet'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
191 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
193 (SELECT player FROM players WHERE nick='Lejordet'),
195 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
201 (SELECT player FROM players WHERE nick='Draconia'),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
207 (SELECT player FROM players WHERE nick='Draconia'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
215 (SELECT player FROM players WHERE nick='Draconia'),
217 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
221 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
223 (SELECT player FROM players WHERE nick='Draconia'),
225 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
231 (SELECT player FROM players WHERE nick='DufF'),
234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
237 (SELECT player FROM players WHERE nick='DufF'),
239 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
245 (SELECT player FROM players WHERE nick='DufF'),
247 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
253 (SELECT player FROM players WHERE nick='DufF'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
258 INSERT INTO groups (tournament, round, parallel) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
261 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
264 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
266 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
269 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
271 UPDATE rounds SET randomsongs=2 WHERE
272 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
274 UPDATE rounds SET chosensongs=1 WHERE
275 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
277 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
280 (SELECT player FROM players WHERE nick='Oliyzia'),
283 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
286 (SELECT player FROM players WHERE nick='Oliyzia'),
288 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
291 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
292 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
294 (SELECT player FROM players WHERE nick='Oliyzia'),
296 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
299 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
300 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
302 (SELECT player FROM players WHERE nick='Oliyzia'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
308 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
310 (SELECT player FROM players WHERE nick='kjmcw'),
313 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
316 (SELECT player FROM players WHERE nick='kjmcw'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
321 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
324 (SELECT player FROM players WHERE nick='kjmcw'),
326 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
329 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
332 (SELECT player FROM players WHERE nick='kjmcw'),
334 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
337 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
340 (SELECT player FROM players WHERE nick='Daniil'),
343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
346 (SELECT player FROM players WHERE nick='Daniil'),
348 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
354 (SELECT player FROM players WHERE nick='Daniil'),
356 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
359 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
362 (SELECT player FROM players WHERE nick='Daniil'),
364 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
367 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
368 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
370 (SELECT player FROM players WHERE nick='Th0rny'),
373 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
376 (SELECT player FROM players WHERE nick='Th0rny'),
378 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
384 (SELECT player FROM players WHERE nick='Th0rny'),
386 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
392 (SELECT player FROM players WHERE nick='Th0rny'),
394 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
397 INSERT INTO groups (tournament, round, parallel) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
400 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
401 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
403 (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
405 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
408 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
410 UPDATE rounds SET randomsongs=2 WHERE
411 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
413 UPDATE rounds SET chosensongs=1 WHERE
414 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
416 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
419 (SELECT player FROM players WHERE nick='Smiph'),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
425 (SELECT player FROM players WHERE nick='Smiph'),
427 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
433 (SELECT player FROM players WHERE nick='Smiph'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
441 (SELECT player FROM players WHERE nick='Smiph'),
443 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
446 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
447 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
449 (SELECT player FROM players WHERE nick='Yeye'),
452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
455 (SELECT player FROM players WHERE nick='Yeye'),
457 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
463 (SELECT player FROM players WHERE nick='Yeye'),
465 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
471 (SELECT player FROM players WHERE nick='Yeye'),
473 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
479 (SELECT player FROM players WHERE nick='Slusk'),
482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
485 (SELECT player FROM players WHERE nick='Slusk'),
487 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
490 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
493 (SELECT player FROM players WHERE nick='Slusk'),
495 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
498 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
501 (SELECT player FROM players WHERE nick='Slusk'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
506 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
509 (SELECT player FROM players WHERE nick='Snute'),
512 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
515 (SELECT player FROM players WHERE nick='Snute'),
517 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
520 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
523 (SELECT player FROM players WHERE nick='Snute'),
525 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
528 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
531 (SELECT player FROM players WHERE nick='Snute'),
533 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
536 INSERT INTO groups (tournament, round, parallel) VALUES (
537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
539 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
542 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
544 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
545 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
547 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
549 UPDATE rounds SET randomsongs=2 WHERE
550 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
552 UPDATE rounds SET chosensongs=1 WHERE
553 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
555 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
558 (SELECT player FROM players WHERE nick='Matsi'),
561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
564 (SELECT player FROM players WHERE nick='Matsi'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
569 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
572 (SELECT player FROM players WHERE nick='Matsi'),
574 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
577 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
578 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
580 (SELECT player FROM players WHERE nick='Matsi'),
582 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
585 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
586 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
588 (SELECT player FROM players WHERE nick='Mario'),
591 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
592 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
594 (SELECT player FROM players WHERE nick='Mario'),
596 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
599 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
600 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
602 (SELECT player FROM players WHERE nick='Mario'),
604 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
607 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
608 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
610 (SELECT player FROM players WHERE nick='Mario'),
612 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
615 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
618 (SELECT player FROM players WHERE nick='RiChY'),
621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
624 (SELECT player FROM players WHERE nick='RiChY'),
626 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
632 (SELECT player FROM players WHERE nick='RiChY'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
637 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
640 (SELECT player FROM players WHERE nick='RiChY'),
642 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
645 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
646 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
648 (SELECT player FROM players WHERE nick='Telc'),
651 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
654 (SELECT player FROM players WHERE nick='Telc'),
656 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
659 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
660 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
662 (SELECT player FROM players WHERE nick='Telc'),
664 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
667 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
668 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
670 (SELECT player FROM players WHERE nick='Telc'),
672 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
675 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
678 (SELECT player FROM players WHERE nick='Tom'),
681 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
682 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
684 (SELECT player FROM players WHERE nick='Tom'),
686 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
692 (SELECT player FROM players WHERE nick='Tom'),
694 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
700 (SELECT player FROM players WHERE nick='Tom'),
702 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
705 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
710 INSERT INTO groups (tournament, round, parallel) VALUES (
711 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
713 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
714 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
716 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
718 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
719 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
721 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
723 UPDATE rounds SET randomsongs=2 WHERE
724 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
726 UPDATE rounds SET chosensongs=1 WHERE
727 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
729 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
732 (SELECT player FROM players WHERE nick='Oliyzia'),
735 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
738 (SELECT player FROM players WHERE nick='Oliyzia'),
740 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
743 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
746 (SELECT player FROM players WHERE nick='Oliyzia'),
748 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
754 (SELECT player FROM players WHERE nick='Oliyzia'),
756 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
759 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
762 (SELECT player FROM players WHERE nick='Th0rny'),
765 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
768 (SELECT player FROM players WHERE nick='Th0rny'),
770 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
773 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
774 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
776 (SELECT player FROM players WHERE nick='Th0rny'),
778 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
781 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
782 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
784 (SELECT player FROM players WHERE nick='Th0rny'),
786 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
789 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
792 (SELECT player FROM players WHERE nick='RiChY'),
795 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
798 (SELECT player FROM players WHERE nick='RiChY'),
800 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
803 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
804 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
806 (SELECT player FROM players WHERE nick='RiChY'),
808 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
811 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
812 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
814 (SELECT player FROM players WHERE nick='RiChY'),
816 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
819 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
822 (SELECT player FROM players WHERE nick='Snute'),
825 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
828 (SELECT player FROM players WHERE nick='Snute'),
830 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
833 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
834 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
836 (SELECT player FROM players WHERE nick='Snute'),
838 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
841 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
842 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
844 (SELECT player FROM players WHERE nick='Snute'),
846 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
849 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
850 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
852 (SELECT player FROM players WHERE nick='DufF'),
855 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
858 (SELECT player FROM players WHERE nick='DufF'),
860 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
863 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
866 (SELECT player FROM players WHERE nick='DufF'),
868 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
874 (SELECT player FROM players WHERE nick='DufF'),
876 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
879 INSERT INTO groups (tournament, round, parallel) VALUES (
880 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
882 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
885 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
887 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
888 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
890 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
892 UPDATE rounds SET randomsongs=2 WHERE
893 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
895 UPDATE rounds SET chosensongs=1 WHERE
896 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
901 (SELECT player FROM players WHERE nick='Telc'),
904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
907 (SELECT player FROM players WHERE nick='Telc'),
909 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
913 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
915 (SELECT player FROM players WHERE nick='Telc'),
917 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
920 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
923 (SELECT player FROM players WHERE nick='Telc'),
925 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
928 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
931 (SELECT player FROM players WHERE nick='Draconia'),
934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
937 (SELECT player FROM players WHERE nick='Draconia'),
939 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
942 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
945 (SELECT player FROM players WHERE nick='Draconia'),
947 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
953 (SELECT player FROM players WHERE nick='Draconia'),
955 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
958 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
961 (SELECT player FROM players WHERE nick='Slusk'),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
967 (SELECT player FROM players WHERE nick='Slusk'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
975 (SELECT player FROM players WHERE nick='Slusk'),
977 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
980 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
983 (SELECT player FROM players WHERE nick='Slusk'),
985 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
988 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
991 (SELECT player FROM players WHERE nick='Tom'),
994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
997 (SELECT player FROM players WHERE nick='Tom'),
999 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
1002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1005 (SELECT player FROM players WHERE nick='Tom'),
1007 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1010 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1013 (SELECT player FROM players WHERE nick='Tom'),
1015 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1018 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1021 (SELECT player FROM players WHERE nick='Daniil'),
1024 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1027 (SELECT player FROM players WHERE nick='Daniil'),
1029 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
1032 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1033 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1035 (SELECT player FROM players WHERE nick='Daniil'),
1037 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1041 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1043 (SELECT player FROM players WHERE nick='Daniil'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1048 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1053 INSERT INTO groups (tournament, round, parallel) VALUES (
1054 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1056 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1059 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
1061 UPDATE rounds SET randomsongs=1 WHERE
1062 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1064 UPDATE rounds SET chosensongs=1 WHERE
1065 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1067 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1068 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1070 (SELECT player FROM players WHERE nick='Oliyzia'),
1073 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1076 (SELECT player FROM players WHERE nick='Oliyzia'),
1078 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1081 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1082 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1084 (SELECT player FROM players WHERE nick='Oliyzia'),
1086 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1089 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1092 (SELECT player FROM players WHERE nick='Draconia'),
1095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1096 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1098 (SELECT player FROM players WHERE nick='Draconia'),
1100 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1106 (SELECT player FROM players WHERE nick='Draconia'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1111 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1114 (SELECT player FROM players WHERE nick='Daniil'),
1117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1120 (SELECT player FROM players WHERE nick='Daniil'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1128 (SELECT player FROM players WHERE nick='Daniil'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1133 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1136 (SELECT player FROM players WHERE nick='Th0rny'),
1139 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1142 (SELECT player FROM players WHERE nick='Th0rny'),
1144 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1147 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1148 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1150 (SELECT player FROM players WHERE nick='Th0rny'),
1152 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1155 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1158 (SELECT player FROM players WHERE nick='Tom'),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1164 (SELECT player FROM players WHERE nick='Tom'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1172 (SELECT player FROM players WHERE nick='Tom'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1180 (SELECT player FROM players WHERE nick='Snute'),
1183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1186 (SELECT player FROM players WHERE nick='Snute'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1191 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1194 (SELECT player FROM players WHERE nick='Snute'),
1196 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1199 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1204 INSERT INTO groups (tournament, round, parallel) VALUES (
1205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1207 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1210 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1212 UPDATE rounds SET randomsongs=1 WHERE
1213 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1215 UPDATE rounds SET chosensongs=1 WHERE
1216 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1218 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1219 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1221 (SELECT player FROM players WHERE nick='Oliyzia'),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1227 (SELECT player FROM players WHERE nick='Oliyzia'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1235 (SELECT player FROM players WHERE nick='Oliyzia'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1243 (SELECT player FROM players WHERE nick='Daniil'),
1246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1249 (SELECT player FROM players WHERE nick='Daniil'),
1251 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1257 (SELECT player FROM players WHERE nick='Daniil'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1262 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1265 (SELECT player FROM players WHERE nick='Th0rny'),
1268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1269 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1271 (SELECT player FROM players WHERE nick='Th0rny'),
1273 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1276 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1277 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1279 (SELECT player FROM players WHERE nick='Th0rny'),
1281 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1284 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1287 (SELECT player FROM players WHERE nick='Tom'),
1290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1293 (SELECT player FROM players WHERE nick='Tom'),
1295 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1301 (SELECT player FROM players WHERE nick='Tom'),
1303 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1309 (SELECT player FROM players WHERE nick='Snute'),
1312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1315 (SELECT player FROM players WHERE nick='Snute'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1323 (SELECT player FROM players WHERE nick='Snute'),
1325 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1328 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1333 INSERT INTO groups (tournament, round, parallel) VALUES (
1334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1336 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1339 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
1341 UPDATE rounds SET randomsongs=1 WHERE
1342 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1344 UPDATE rounds SET chosensongs=1 WHERE
1345 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1347 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1350 (SELECT player FROM players WHERE nick='Daniil'),
1353 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1354 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1356 (SELECT player FROM players WHERE nick='Daniil'),
1358 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1362 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1364 (SELECT player FROM players WHERE nick='Daniil'),
1366 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1369 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1370 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1372 (SELECT player FROM players WHERE nick='Snute'),
1375 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1376 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1378 (SELECT player FROM players WHERE nick='Snute'),
1380 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1383 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1384 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1386 (SELECT player FROM players WHERE nick='Snute'),
1388 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1394 (SELECT player FROM players WHERE nick='Th0rny'),
1397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1400 (SELECT player FROM players WHERE nick='Th0rny'),
1402 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1408 (SELECT player FROM players WHERE nick='Th0rny'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1413 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1416 (SELECT player FROM players WHERE nick='Tom'),
1419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1420 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1422 (SELECT player FROM players WHERE nick='Tom'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1427 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1430 (SELECT player FROM players WHERE nick='Tom'),
1432 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1435 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1440 INSERT INTO groups (tournament, round, parallel) VALUES (
1441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1443 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1444 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1446 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
1448 UPDATE rounds SET randomsongs=1 WHERE
1449 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1451 UPDATE rounds SET chosensongs=1 WHERE
1452 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1454 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1455 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1457 (SELECT player FROM players WHERE nick='Th0rny'),
1460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1463 (SELECT player FROM players WHERE nick='Th0rny'),
1465 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1469 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1471 (SELECT player FROM players WHERE nick='Th0rny'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1477 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1479 (SELECT player FROM players WHERE nick='Tom'),
1482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1483 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1485 (SELECT player FROM players WHERE nick='Tom'),
1487 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1490 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1493 (SELECT player FROM players WHERE nick='Tom'),
1495 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1498 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1501 (SELECT player FROM players WHERE nick='Snute'),
1504 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1507 (SELECT player FROM players WHERE nick='Snute'),
1509 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1512 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1515 (SELECT player FROM players WHERE nick='Snute'),
1517 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1520 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1525 INSERT INTO groups (tournament, round, parallel) VALUES (
1526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1528 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1531 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
1533 UPDATE rounds SET randomsongs=1 WHERE
1534 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1536 UPDATE rounds SET chosensongs=1 WHERE
1537 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )) AND
1539 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1542 (SELECT player FROM players WHERE nick='Th0rny'),
1545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1548 (SELECT player FROM players WHERE nick='Th0rny'),
1550 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1556 (SELECT player FROM players WHERE nick='Th0rny'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1561 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1564 (SELECT player FROM players WHERE nick='Snute'),
1567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1570 (SELECT player FROM players WHERE nick='Snute'),
1572 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2003' )),
1578 (SELECT player FROM players WHERE nick='Snute'),
1580 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),