2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
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 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
16 (SELECT player FROM players WHERE nick='Snute'),
18 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 );
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 2004' )),
22 (SELECT player FROM players WHERE nick='DufF'),
24 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 );
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 2004' )),
28 (SELECT player FROM players WHERE nick='RiChY'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
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 2004' )),
34 (SELECT player FROM players WHERE nick='Haggar'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nameless' 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 2004' )),
40 (SELECT player FROM players WHERE nick='Nameless'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
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 2004' )),
46 (SELECT player FROM players WHERE nick='OJK'),
48 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 );
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 2004' )),
52 (SELECT player FROM players WHERE nick='Snofox'),
54 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 );
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 2004' )),
58 (SELECT player FROM players WHERE nick='Tom'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pingo' 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 2004' )),
64 (SELECT player FROM players WHERE nick='Pingo'),
66 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 );
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 2004' )),
70 (SELECT player FROM players WHERE nick='Oliyzia'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Gogo' 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 2004' )),
76 (SELECT player FROM players WHERE nick='Gogo'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' 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 2004' )),
82 (SELECT player FROM players WHERE nick='Duckling'),
84 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 );
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 2004' )),
88 (SELECT player FROM players WHERE nick='T|na'),
90 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 );
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 2004' )),
94 (SELECT player FROM players WHERE nick='Daniil'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
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 2004' )),
100 (SELECT player FROM players WHERE nick='Ylini'),
102 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 );
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 2004' )),
106 (SELECT player FROM players WHERE nick='Mulefisk'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Olemann' 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 2004' )),
112 (SELECT player FROM players WHERE nick='Olemann'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tassen' 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 2004' )),
118 (SELECT player FROM players WHERE nick='Tassen'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Bonzo' 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 2004' )),
124 (SELECT player FROM players WHERE nick='Bonzo'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mync' 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 2004' )),
130 (SELECT player FROM players WHERE nick='Mync'),
132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ozon' 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 2004' )),
136 (SELECT player FROM players WHERE nick='Ozon'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pål Andre' 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 2004' )),
142 (SELECT player FROM players WHERE nick='Pål Andre'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ted Kristian' 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 2004' )),
148 (SELECT player FROM players WHERE nick='Ted Kristian'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' 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 2004' )),
154 (SELECT player FROM players WHERE nick='Dabi'),
156 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 );
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 2004' )),
160 (SELECT player FROM players WHERE nick='Draconia'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Alexxz' 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 2004' )),
166 (SELECT player FROM players WHERE nick='Alexxz'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' NOT IN ( SELECT nick FROM players );
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 2004' )),
172 (SELECT player FROM players WHERE nick='Stream'),
174 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 );
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 2004' )),
178 (SELECT player FROM players WHERE nick='Smiph'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jim Andre' 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 2004' )),
184 (SELECT player FROM players WHERE nick='Jim Andre'),
186 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Glukko' 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 2004' )),
190 (SELECT player FROM players WHERE nick='Glukko'),
192 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hyper' 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 2004' )),
196 (SELECT player FROM players WHERE nick='Hyper'),
198 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 );
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 2004' )),
202 (SELECT player FROM players WHERE nick='Mario'),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Zeek' NOT IN ( SELECT nick FROM players );
205 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
208 (SELECT player FROM players WHERE nick='Zeek'),
210 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
215 INSERT INTO groups (tournament, round, parallel) VALUES (
216 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
218 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
219 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
221 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
223 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
226 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
228 UPDATE rounds SET randomsongs=2 WHERE
229 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
231 UPDATE rounds SET chosensongs=1 WHERE
232 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
234 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
237 (SELECT player FROM players WHERE nick='Pål Andre'),
240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
243 (SELECT player FROM players WHERE nick='Pål Andre'),
245 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
251 (SELECT player FROM players WHERE nick='Pål Andre'),
253 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
259 (SELECT player FROM players WHERE nick='Pål Andre'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
264 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
267 (SELECT player FROM players WHERE nick='Tassen'),
270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
273 (SELECT player FROM players WHERE nick='Tassen'),
275 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
281 (SELECT player FROM players WHERE nick='Tassen'),
283 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
289 (SELECT player FROM players WHERE nick='Tassen'),
291 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
294 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
297 (SELECT player FROM players WHERE nick='Haggar'),
300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
303 (SELECT player FROM players WHERE nick='Haggar'),
305 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
309 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
311 (SELECT player FROM players WHERE nick='Haggar'),
313 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
319 (SELECT player FROM players WHERE nick='Haggar'),
321 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
324 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
327 (SELECT player FROM players WHERE nick='Draconia'),
330 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
333 (SELECT player FROM players WHERE nick='Draconia'),
335 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
338 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
341 (SELECT player FROM players WHERE nick='Draconia'),
343 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
349 (SELECT player FROM players WHERE nick='Draconia'),
351 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
354 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
357 (SELECT player FROM players WHERE nick='Snute'),
360 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
363 (SELECT player FROM players WHERE nick='Snute'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
371 (SELECT player FROM players WHERE nick='Snute'),
373 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
379 (SELECT player FROM players WHERE nick='Snute'),
381 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
384 INSERT INTO groups (tournament, round, parallel) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
387 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
390 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
392 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
395 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
397 UPDATE rounds SET randomsongs=2 WHERE
398 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
400 UPDATE rounds SET chosensongs=1 WHERE
401 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
406 (SELECT player FROM players WHERE nick='Mync'),
409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
412 (SELECT player FROM players WHERE nick='Mync'),
414 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
420 (SELECT player FROM players WHERE nick='Mync'),
422 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
425 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
428 (SELECT player FROM players WHERE nick='Mync'),
430 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
433 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
436 (SELECT player FROM players WHERE nick='Glukko'),
439 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
442 (SELECT player FROM players WHERE nick='Glukko'),
444 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
447 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
450 (SELECT player FROM players WHERE nick='Glukko'),
452 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
458 (SELECT player FROM players WHERE nick='Glukko'),
460 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
466 (SELECT player FROM players WHERE nick='Mulefisk'),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
472 (SELECT player FROM players WHERE nick='Mulefisk'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
477 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
480 (SELECT player FROM players WHERE nick='Mulefisk'),
482 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
488 (SELECT player FROM players WHERE nick='Mulefisk'),
490 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
496 (SELECT player FROM players WHERE nick='Ylini'),
499 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
502 (SELECT player FROM players WHERE nick='Ylini'),
504 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
510 (SELECT player FROM players WHERE nick='Ylini'),
512 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
518 (SELECT player FROM players WHERE nick='Ylini'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
526 (SELECT player FROM players WHERE nick='DufF'),
529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
532 (SELECT player FROM players WHERE nick='DufF'),
534 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
540 (SELECT player FROM players WHERE nick='DufF'),
542 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
548 (SELECT player FROM players WHERE nick='DufF'),
550 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
553 INSERT INTO groups (tournament, round, parallel) VALUES (
554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
556 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
557 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
559 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
561 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
564 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
566 UPDATE rounds SET randomsongs=2 WHERE
567 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
569 UPDATE rounds SET chosensongs=1 WHERE
570 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
572 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
575 (SELECT player FROM players WHERE nick='Pingo'),
578 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
581 (SELECT player FROM players WHERE nick='Pingo'),
583 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
587 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
589 (SELECT player FROM players WHERE nick='Pingo'),
591 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
597 (SELECT player FROM players WHERE nick='Pingo'),
599 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
605 (SELECT player FROM players WHERE nick='Jim Andre'),
608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
611 (SELECT player FROM players WHERE nick='Jim Andre'),
613 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
619 (SELECT player FROM players WHERE nick='Jim Andre'),
621 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
627 (SELECT player FROM players WHERE nick='Jim Andre'),
629 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
635 (SELECT player FROM players WHERE nick='Dabi'),
638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
641 (SELECT player FROM players WHERE nick='Dabi'),
643 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
649 (SELECT player FROM players WHERE nick='Dabi'),
651 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
654 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
657 (SELECT player FROM players WHERE nick='Dabi'),
659 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
662 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
665 (SELECT player FROM players WHERE nick='Olemann'),
668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
671 (SELECT player FROM players WHERE nick='Olemann'),
673 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
676 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
679 (SELECT player FROM players WHERE nick='Olemann'),
681 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
684 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
687 (SELECT player FROM players WHERE nick='Olemann'),
689 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
692 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
695 (SELECT player FROM players WHERE nick='OJK'),
698 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
701 (SELECT player FROM players WHERE nick='OJK'),
703 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
709 (SELECT player FROM players WHERE nick='OJK'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
717 (SELECT player FROM players WHERE nick='OJK'),
719 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
722 INSERT INTO groups (tournament, round, parallel) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
725 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
728 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
730 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
731 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
733 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
735 UPDATE rounds SET randomsongs=2 WHERE
736 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
738 UPDATE rounds SET chosensongs=1 WHERE
739 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
741 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
744 (SELECT player FROM players WHERE nick='Mario'),
747 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
748 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
750 (SELECT player FROM players WHERE nick='Mario'),
752 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
755 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
756 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
758 (SELECT player FROM players WHERE nick='Mario'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
763 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
764 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
766 (SELECT player FROM players WHERE nick='Mario'),
768 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
771 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
774 (SELECT player FROM players WHERE nick='Gogo'),
777 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
780 (SELECT player FROM players WHERE nick='Gogo'),
782 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
785 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
786 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
788 (SELECT player FROM players WHERE nick='Gogo'),
790 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
793 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
794 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
796 (SELECT player FROM players WHERE nick='Gogo'),
798 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
801 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
804 (SELECT player FROM players WHERE nick='Ted Kristian'),
807 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
810 (SELECT player FROM players WHERE nick='Ted Kristian'),
812 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
815 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
818 (SELECT player FROM players WHERE nick='Ted Kristian'),
820 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
823 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
824 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
826 (SELECT player FROM players WHERE nick='Ted Kristian'),
828 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
831 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
834 (SELECT player FROM players WHERE nick='Duckling'),
837 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
840 (SELECT player FROM players WHERE nick='Duckling'),
842 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
845 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
848 (SELECT player FROM players WHERE nick='Duckling'),
850 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
853 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
856 (SELECT player FROM players WHERE nick='Duckling'),
858 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
861 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
864 (SELECT player FROM players WHERE nick='Smiph'),
867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
870 (SELECT player FROM players WHERE nick='Smiph'),
872 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
878 (SELECT player FROM players WHERE nick='Smiph'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
886 (SELECT player FROM players WHERE nick='Smiph'),
888 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
894 (SELECT player FROM players WHERE nick='RiChY'),
897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
900 (SELECT player FROM players WHERE nick='RiChY'),
902 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
908 (SELECT player FROM players WHERE nick='RiChY'),
910 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
916 (SELECT player FROM players WHERE nick='RiChY'),
918 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
921 INSERT INTO groups (tournament, round, parallel) VALUES (
922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
924 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
925 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
927 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
929 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
930 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
932 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
934 UPDATE rounds SET randomsongs=2 WHERE
935 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
937 UPDATE rounds SET chosensongs=1 WHERE
938 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
940 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
943 (SELECT player FROM players WHERE nick='Alexxz'),
946 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
947 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
949 (SELECT player FROM players WHERE nick='Alexxz'),
951 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
954 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
955 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
957 (SELECT player FROM players WHERE nick='Alexxz'),
959 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
962 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
965 (SELECT player FROM players WHERE nick='Alexxz'),
967 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
970 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
973 (SELECT player FROM players WHERE nick='Zeek'),
976 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
979 (SELECT player FROM players WHERE nick='Zeek'),
981 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
984 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
985 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
987 (SELECT player FROM players WHERE nick='Zeek'),
989 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
992 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
993 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
995 (SELECT player FROM players WHERE nick='Zeek'),
997 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1003 (SELECT player FROM players WHERE nick='Bonzo'),
1006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1009 (SELECT player FROM players WHERE nick='Bonzo'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1017 (SELECT player FROM players WHERE nick='Bonzo'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1022 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1025 (SELECT player FROM players WHERE nick='Bonzo'),
1027 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1030 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1031 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1033 (SELECT player FROM players WHERE nick='Tom'),
1036 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1039 (SELECT player FROM players WHERE nick='Tom'),
1041 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1044 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1045 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1047 (SELECT player FROM players WHERE nick='Tom'),
1049 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1052 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1053 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1055 (SELECT player FROM players WHERE nick='Tom'),
1057 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1060 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1063 (SELECT player FROM players WHERE nick='Snofox'),
1066 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1069 (SELECT player FROM players WHERE nick='Snofox'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1074 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1077 (SELECT player FROM players WHERE nick='Snofox'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1082 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1083 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1085 (SELECT player FROM players WHERE nick='Snofox'),
1087 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1090 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1091 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1093 (SELECT player FROM players WHERE nick='T|na'),
1096 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1099 (SELECT player FROM players WHERE nick='T|na'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1104 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1107 (SELECT player FROM players WHERE nick='T|na'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1112 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1115 (SELECT player FROM players WHERE nick='T|na'),
1117 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1120 INSERT INTO groups (tournament, round, parallel) VALUES (
1121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1123 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1126 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1128 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1129 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1131 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
1133 UPDATE rounds SET randomsongs=2 WHERE
1134 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1136 UPDATE rounds SET chosensongs=1 WHERE
1137 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1139 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1142 (SELECT player FROM players WHERE nick='Ozon'),
1145 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1148 (SELECT player FROM players WHERE nick='Ozon'),
1150 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1153 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1156 (SELECT player FROM players WHERE nick='Ozon'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1161 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1164 (SELECT player FROM players WHERE nick='Ozon'),
1166 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1169 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1172 (SELECT player FROM players WHERE nick='Hyper'),
1175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1178 (SELECT player FROM players WHERE nick='Hyper'),
1180 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1186 (SELECT player FROM players WHERE nick='Hyper'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1191 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1194 (SELECT player FROM players WHERE nick='Hyper'),
1196 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1199 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1202 (SELECT player FROM players WHERE nick='Nameless'),
1205 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1208 (SELECT player FROM players WHERE nick='Nameless'),
1210 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1213 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1214 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1216 (SELECT player FROM players WHERE nick='Nameless'),
1218 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1221 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1222 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1224 (SELECT player FROM players WHERE nick='Nameless'),
1226 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1229 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1232 (SELECT player FROM players WHERE nick='Daniil'),
1235 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1238 (SELECT player FROM players WHERE nick='Daniil'),
1240 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1243 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1244 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1246 (SELECT player FROM players WHERE nick='Daniil'),
1248 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1251 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1252 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1254 (SELECT player FROM players WHERE nick='Daniil'),
1256 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1259 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1262 (SELECT player FROM players WHERE nick='Oliyzia'),
1265 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1268 (SELECT player FROM players WHERE nick='Oliyzia'),
1270 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1273 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1276 (SELECT player FROM players WHERE nick='Oliyzia'),
1278 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1284 (SELECT player FROM players WHERE nick='Oliyzia'),
1286 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1289 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1292 (SELECT player FROM players WHERE nick='Stream'),
1295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1298 (SELECT player FROM players WHERE nick='Stream'),
1300 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1306 (SELECT player FROM players WHERE nick='Stream'),
1308 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1311 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1312 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1314 (SELECT player FROM players WHERE nick='Stream'),
1316 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1319 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1324 INSERT INTO groups (tournament, round, parallel) VALUES (
1325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1327 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1328 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1330 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1332 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1335 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1337 UPDATE rounds SET randomsongs=2 WHERE
1338 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1340 UPDATE rounds SET chosensongs=1 WHERE
1341 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1343 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1346 (SELECT player FROM players WHERE nick='Olemann'),
1349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1352 (SELECT player FROM players WHERE nick='Olemann'),
1354 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1360 (SELECT player FROM players WHERE nick='Olemann'),
1362 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1365 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1368 (SELECT player FROM players WHERE nick='Olemann'),
1370 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1373 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1376 (SELECT player FROM players WHERE nick='T|na'),
1379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1382 (SELECT player FROM players WHERE nick='T|na'),
1384 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1390 (SELECT player FROM players WHERE nick='T|na'),
1392 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1395 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1396 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1398 (SELECT player FROM players WHERE nick='T|na'),
1400 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1406 (SELECT player FROM players WHERE nick='Oliyzia'),
1409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1412 (SELECT player FROM players WHERE nick='Oliyzia'),
1414 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1420 (SELECT player FROM players WHERE nick='Oliyzia'),
1422 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1425 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1428 (SELECT player FROM players WHERE nick='Oliyzia'),
1430 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1433 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1436 (SELECT player FROM players WHERE nick='Snofox'),
1439 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1442 (SELECT player FROM players WHERE nick='Snofox'),
1444 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1447 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1450 (SELECT player FROM players WHERE nick='Snofox'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1458 (SELECT player FROM players WHERE nick='Snofox'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1466 (SELECT player FROM players WHERE nick='Tom'),
1469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1472 (SELECT player FROM players WHERE nick='Tom'),
1474 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1477 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1480 (SELECT player FROM players WHERE nick='Tom'),
1482 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1488 (SELECT player FROM players WHERE nick='Tom'),
1490 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1496 (SELECT player FROM players WHERE nick='Snute'),
1499 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1502 (SELECT player FROM players WHERE nick='Snute'),
1504 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1510 (SELECT player FROM players WHERE nick='Snute'),
1512 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1518 (SELECT player FROM players WHERE nick='Snute'),
1520 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1523 INSERT INTO groups (tournament, round, parallel) VALUES (
1524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1526 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1527 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1529 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
1531 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1534 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1536 UPDATE rounds SET randomsongs=2 WHERE
1537 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1539 UPDATE rounds SET chosensongs=1 WHERE
1540 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1542 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1543 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1545 (SELECT player FROM players WHERE nick='Duckling'),
1548 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1551 (SELECT player FROM players WHERE nick='Duckling'),
1553 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1556 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1557 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1559 (SELECT player FROM players WHERE nick='Duckling'),
1561 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1564 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1565 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1567 (SELECT player FROM players WHERE nick='Duckling'),
1569 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1572 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1575 (SELECT player FROM players WHERE nick='Daniil'),
1578 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1581 (SELECT player FROM players WHERE nick='Daniil'),
1583 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1587 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1589 (SELECT player FROM players WHERE nick='Daniil'),
1591 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1597 (SELECT player FROM players WHERE nick='Daniil'),
1599 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1605 (SELECT player FROM players WHERE nick='Mulefisk'),
1608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1611 (SELECT player FROM players WHERE nick='Mulefisk'),
1613 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1619 (SELECT player FROM players WHERE nick='Mulefisk'),
1621 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1627 (SELECT player FROM players WHERE nick='Mulefisk'),
1629 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1635 (SELECT player FROM players WHERE nick='Haggar'),
1638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1641 (SELECT player FROM players WHERE nick='Haggar'),
1643 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1649 (SELECT player FROM players WHERE nick='Haggar'),
1651 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1654 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1657 (SELECT player FROM players WHERE nick='Haggar'),
1659 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1662 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1665 (SELECT player FROM players WHERE nick='Nameless'),
1668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1671 (SELECT player FROM players WHERE nick='Nameless'),
1673 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1676 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1679 (SELECT player FROM players WHERE nick='Nameless'),
1681 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1684 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1687 (SELECT player FROM players WHERE nick='Nameless'),
1689 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1692 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1693 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1695 (SELECT player FROM players WHERE nick='OJK'),
1698 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1701 (SELECT player FROM players WHERE nick='OJK'),
1703 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1709 (SELECT player FROM players WHERE nick='OJK'),
1711 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1717 (SELECT player FROM players WHERE nick='OJK'),
1719 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1722 INSERT INTO groups (tournament, round, parallel) VALUES (
1723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1725 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1728 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1730 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1731 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1733 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1735 UPDATE rounds SET randomsongs=2 WHERE
1736 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1738 UPDATE rounds SET chosensongs=1 WHERE
1739 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1741 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1744 (SELECT player FROM players WHERE nick='Tassen'),
1747 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1748 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1750 (SELECT player FROM players WHERE nick='Tassen'),
1752 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1755 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1756 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1758 (SELECT player FROM players WHERE nick='Tassen'),
1760 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1763 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1764 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1766 (SELECT player FROM players WHERE nick='Tassen'),
1768 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1771 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1774 (SELECT player FROM players WHERE nick='Ylini'),
1777 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1778 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1780 (SELECT player FROM players WHERE nick='Ylini'),
1782 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1785 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1786 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1788 (SELECT player FROM players WHERE nick='Ylini'),
1790 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1793 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1794 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1796 (SELECT player FROM players WHERE nick='Ylini'),
1798 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1801 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1802 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1804 (SELECT player FROM players WHERE nick='Pingo'),
1807 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1808 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1810 (SELECT player FROM players WHERE nick='Pingo'),
1812 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1815 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1816 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1818 (SELECT player FROM players WHERE nick='Pingo'),
1820 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1823 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1824 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1826 (SELECT player FROM players WHERE nick='Pingo'),
1828 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1831 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1834 (SELECT player FROM players WHERE nick='Gogo'),
1837 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1840 (SELECT player FROM players WHERE nick='Gogo'),
1842 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1845 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1848 (SELECT player FROM players WHERE nick='Gogo'),
1850 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1853 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1856 (SELECT player FROM players WHERE nick='Gogo'),
1858 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1861 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1864 (SELECT player FROM players WHERE nick='RiChY'),
1867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1870 (SELECT player FROM players WHERE nick='RiChY'),
1872 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1876 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1878 (SELECT player FROM players WHERE nick='RiChY'),
1880 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1886 (SELECT player FROM players WHERE nick='RiChY'),
1888 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1894 (SELECT player FROM players WHERE nick='DufF'),
1897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1900 (SELECT player FROM players WHERE nick='DufF'),
1902 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1908 (SELECT player FROM players WHERE nick='DufF'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1916 (SELECT player FROM players WHERE nick='DufF'),
1918 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1921 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1926 INSERT INTO groups (tournament, round, parallel) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1929 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1930 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1932 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1934 UPDATE rounds SET randomsongs=1 WHERE
1935 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1937 UPDATE rounds SET chosensongs=1 WHERE
1938 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
1940 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1943 (SELECT player FROM players WHERE nick='OJK'),
1946 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1947 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1949 (SELECT player FROM players WHERE nick='OJK'),
1951 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
1957 (SELECT player FROM players WHERE nick='OJK'),
1959 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1962 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1965 (SELECT player FROM players WHERE nick='Pingo'),
1968 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1969 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1971 (SELECT player FROM players WHERE nick='Pingo'),
1973 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
1979 (SELECT player FROM players WHERE nick='Pingo'),
1981 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1984 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1985 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1987 (SELECT player FROM players WHERE nick='Tom'),
1990 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1991 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
1993 (SELECT player FROM players WHERE nick='Tom'),
1995 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
2001 (SELECT player FROM players WHERE nick='Tom'),
2003 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2006 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2009 (SELECT player FROM players WHERE nick='Nameless'),
2012 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2015 (SELECT player FROM players WHERE nick='Nameless'),
2017 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
2023 (SELECT player FROM players WHERE nick='Nameless'),
2025 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2028 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2029 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2031 (SELECT player FROM players WHERE nick='RiChY'),
2034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2035 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2037 (SELECT player FROM players WHERE nick='RiChY'),
2039 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
2045 (SELECT player FROM players WHERE nick='RiChY'),
2047 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2050 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2053 (SELECT player FROM players WHERE nick='Snofox'),
2056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2059 (SELECT player FROM players WHERE nick='Snofox'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
2067 (SELECT player FROM players WHERE nick='Snofox'),
2069 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2072 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2073 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2075 (SELECT player FROM players WHERE nick='Haggar'),
2078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2079 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2081 (SELECT player FROM players WHERE nick='Haggar'),
2083 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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 2004' )),
2089 (SELECT player FROM players WHERE nick='Haggar'),
2091 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2094 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2095 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2097 (SELECT player FROM players WHERE nick='Snute'),
2100 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2101 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2103 (SELECT player FROM players WHERE nick='Snute'),
2105 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
2108 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2111 (SELECT player FROM players WHERE nick='Snute'),
2113 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2116 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2119 (SELECT player FROM players WHERE nick='DufF'),
2122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2123 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2125 (SELECT player FROM players WHERE nick='DufF'),
2127 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
2130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2133 (SELECT player FROM players WHERE nick='DufF'),
2135 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2138 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2143 INSERT INTO groups (tournament, round, parallel) VALUES (
2144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2146 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2149 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
2151 UPDATE rounds SET randomsongs=1 WHERE
2152 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2154 UPDATE rounds SET chosensongs=1 WHERE
2155 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2157 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2160 (SELECT player FROM players WHERE nick='Haggar'),
2163 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2166 (SELECT player FROM players WHERE nick='Haggar'),
2168 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
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 2004' )),
2174 (SELECT player FROM players WHERE nick='Haggar'),
2176 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2179 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2182 (SELECT player FROM players WHERE nick='Snofox'),
2185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2186 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2188 (SELECT player FROM players WHERE nick='Snofox'),
2190 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
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 2004' )),
2196 (SELECT player FROM players WHERE nick='Snofox'),
2198 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2201 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2202 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2204 (SELECT player FROM players WHERE nick='RiChY'),
2207 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2208 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2210 (SELECT player FROM players WHERE nick='RiChY'),
2212 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
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 2004' )),
2218 (SELECT player FROM players WHERE nick='RiChY'),
2220 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2226 (SELECT player FROM players WHERE nick='Nameless'),
2229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2232 (SELECT player FROM players WHERE nick='Nameless'),
2234 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
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 2004' )),
2240 (SELECT player FROM players WHERE nick='Nameless'),
2242 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2245 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2248 (SELECT player FROM players WHERE nick='Snute'),
2251 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2252 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2254 (SELECT player FROM players WHERE nick='Snute'),
2256 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
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 2004' )),
2262 (SELECT player FROM players WHERE nick='Snute'),
2264 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2267 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2268 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2270 (SELECT player FROM players WHERE nick='DufF'),
2273 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2276 (SELECT player FROM players WHERE nick='DufF'),
2278 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2284 (SELECT player FROM players WHERE nick='DufF'),
2286 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2289 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2292 (SELECT player FROM players WHERE nick='OJK'),
2295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2298 (SELECT player FROM players WHERE nick='OJK'),
2300 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2306 (SELECT player FROM players WHERE nick='OJK'),
2308 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2311 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2316 INSERT INTO groups (tournament, round, parallel) VALUES (
2317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2319 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2322 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2324 UPDATE rounds SET randomsongs=1 WHERE
2325 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2327 UPDATE rounds SET chosensongs=1 WHERE
2328 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2330 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2333 (SELECT player FROM players WHERE nick='Nameless'),
2336 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2339 (SELECT player FROM players WHERE nick='Nameless'),
2341 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
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 2004' )),
2347 (SELECT player FROM players WHERE nick='Nameless'),
2349 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2352 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2353 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2355 (SELECT player FROM players WHERE nick='RiChY'),
2358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2361 (SELECT player FROM players WHERE nick='RiChY'),
2363 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
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 2004' )),
2369 (SELECT player FROM players WHERE nick='RiChY'),
2371 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2374 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2377 (SELECT player FROM players WHERE nick='Haggar'),
2380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2383 (SELECT player FROM players WHERE nick='Haggar'),
2385 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
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 2004' )),
2391 (SELECT player FROM players WHERE nick='Haggar'),
2393 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2399 (SELECT player FROM players WHERE nick='Snute'),
2402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2405 (SELECT player FROM players WHERE nick='Snute'),
2407 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2413 (SELECT player FROM players WHERE nick='Snute'),
2415 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2418 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2421 (SELECT player FROM players WHERE nick='DufF'),
2424 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2427 (SELECT player FROM players WHERE nick='DufF'),
2429 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2432 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2433 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2435 (SELECT player FROM players WHERE nick='DufF'),
2437 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2440 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2442 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2445 INSERT INTO groups (tournament, round, parallel) VALUES (
2446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2448 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2451 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
2453 UPDATE rounds SET randomsongs=1 WHERE
2454 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2456 UPDATE rounds SET chosensongs=1 WHERE
2457 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2459 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2460 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2462 (SELECT player FROM players WHERE nick='RiChY'),
2465 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2466 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2468 (SELECT player FROM players WHERE nick='RiChY'),
2470 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
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 2004' )),
2476 (SELECT player FROM players WHERE nick='RiChY'),
2478 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2481 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2484 (SELECT player FROM players WHERE nick='Haggar'),
2487 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2490 (SELECT player FROM players WHERE nick='Haggar'),
2492 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
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 2004' )),
2498 (SELECT player FROM players WHERE nick='Haggar'),
2500 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2503 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2506 (SELECT player FROM players WHERE nick='DufF'),
2509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2512 (SELECT player FROM players WHERE nick='DufF'),
2514 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2517 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2520 (SELECT player FROM players WHERE nick='DufF'),
2522 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2525 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2528 (SELECT player FROM players WHERE nick='Snute'),
2531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2534 (SELECT player FROM players WHERE nick='Snute'),
2536 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2542 (SELECT player FROM players WHERE nick='Snute'),
2544 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2547 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2549 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2552 INSERT INTO groups (tournament, round, parallel) VALUES (
2553 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2555 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2558 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
2560 UPDATE rounds SET randomsongs=1 WHERE
2561 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2563 UPDATE rounds SET chosensongs=1 WHERE
2564 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2569 (SELECT player FROM players WHERE nick='RiChY'),
2572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2573 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2575 (SELECT player FROM players WHERE nick='RiChY'),
2577 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
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 2004' )),
2583 (SELECT player FROM players WHERE nick='RiChY'),
2585 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2588 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2589 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2591 (SELECT player FROM players WHERE nick='DufF'),
2594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2595 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2597 (SELECT player FROM players WHERE nick='DufF'),
2599 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2602 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2603 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2605 (SELECT player FROM players WHERE nick='DufF'),
2607 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2610 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2611 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2613 (SELECT player FROM players WHERE nick='Snute'),
2616 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2617 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2619 (SELECT player FROM players WHERE nick='Snute'),
2621 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2625 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2627 (SELECT player FROM players WHERE nick='Snute'),
2629 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2632 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2634 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2637 INSERT INTO groups (tournament, round, parallel) VALUES (
2638 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2640 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2643 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2645 UPDATE rounds SET randomsongs=1 WHERE
2646 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2648 UPDATE rounds SET chosensongs=1 WHERE
2649 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )) AND
2651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2654 (SELECT player FROM players WHERE nick='Snute'),
2657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2660 (SELECT player FROM players WHERE nick='Snute'),
2662 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2668 (SELECT player FROM players WHERE nick='Snute'),
2670 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2673 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2676 (SELECT player FROM players WHERE nick='DufF'),
2679 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2680 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2682 (SELECT player FROM players WHERE nick='DufF'),
2684 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2687 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4' AND season=( SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004' )),
2690 (SELECT player FROM players WHERE nick='DufF'),
2692 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),