2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
5 'Challenge Cup 5 - NM',
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 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 5 - NM'),
16 (SELECT player FROM players WHERE nick='Snute'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick 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 5 - NM'),
22 (SELECT player FROM players WHERE nick='DufF'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
28 (SELECT player FROM players WHERE nick='Haggar'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
34 (SELECT player FROM players WHERE nick='OJK'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
40 (SELECT player FROM players WHERE nick='RiChY'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
46 (SELECT player FROM players WHERE nick='Nameless'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
52 (SELECT player FROM players WHERE nick='Gogo'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
58 (SELECT player FROM players WHERE nick='T|na'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick 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 5 - NM'),
64 (SELECT player FROM players WHERE nick='Pingo'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
70 (SELECT player FROM players WHERE nick='Daniil'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
76 (SELECT player FROM players WHERE nick='Duckling'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
82 (SELECT player FROM players WHERE nick='Oliyzia'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
88 (SELECT player FROM players WHERE nick='Bonzo'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
94 (SELECT player FROM players WHERE nick='Stream'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
100 (SELECT player FROM players WHERE nick='Olemann'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
106 (SELECT player FROM players WHERE nick='Ozon'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
112 (SELECT player FROM players WHERE nick='Mync'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
118 (SELECT player FROM players WHERE nick='Ylini'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
124 (SELECT player FROM players WHERE nick='Smiph'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cuivien' AS nick WHERE 'Cuivien' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
130 (SELECT player FROM players WHERE nick='Cuivien'),
132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
136 (SELECT player FROM players WHERE nick='Haanz'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
142 (SELECT player FROM players WHERE nick='Felz'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cehtna' AS nick WHERE 'Cehtna' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
148 (SELECT player FROM players WHERE nick='Cehtna'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
154 (SELECT player FROM players WHERE nick='Andeplane'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
160 (SELECT player FROM players WHERE nick='Alexxz'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Asphodel' AS nick WHERE 'Asphodel' NOT IN ( SELECT nick FROM players );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
166 (SELECT player FROM players WHERE nick='Asphodel'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
172 (SELECT player FROM players WHERE nick='Havok'),
174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
178 (SELECT player FROM players WHERE nick='Zeila'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ngan' AS nick WHERE 'Ngan' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
184 (SELECT player FROM players WHERE nick='Ngan'),
186 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andre' AS nick WHERE 'Andre' NOT IN ( SELECT nick FROM players );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
190 (SELECT player FROM players WHERE nick='Andre'),
192 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lindaninja' AS nick WHERE 'Lindaninja' NOT IN ( SELECT nick FROM players );
193 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
196 (SELECT player FROM players WHERE nick='Lindaninja'),
198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
199 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
202 (SELECT player FROM players WHERE nick='Eruanna'),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ingviild' AS nick WHERE 'Ingviild' NOT IN ( SELECT nick FROM players );
205 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
208 (SELECT player FROM players WHERE nick='Ingviild'),
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
211 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
214 (SELECT player FROM players WHERE nick='Marilla'),
216 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mickva' AS nick WHERE 'Mickva' NOT IN ( SELECT nick FROM players );
217 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
220 (SELECT player FROM players WHERE nick='Mickva'),
222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
223 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
226 (SELECT player FROM players WHERE nick='Chimera'),
228 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
229 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
232 (SELECT player FROM players WHERE nick='Maxion'),
234 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
235 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
238 (SELECT player FROM players WHERE nick='Athena'),
240 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
245 INSERT INTO groups (tournament, round, parallel) VALUES (
246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
248 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
251 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
253 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
256 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
258 UPDATE rounds SET randomsongs=2 WHERE
259 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
261 UPDATE rounds SET chosensongs=1 WHERE
262 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
264 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
267 (SELECT player FROM players WHERE nick='Eruanna'),
270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
273 (SELECT player FROM players WHERE nick='Eruanna'),
275 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
281 (SELECT player FROM players WHERE nick='Eruanna'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
289 (SELECT player FROM players WHERE nick='Eruanna'),
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 5 - NM'),
297 (SELECT player FROM players WHERE nick='Andeplane'),
300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
303 (SELECT player FROM players WHERE nick='Andeplane'),
305 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
309 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
311 (SELECT player FROM players WHERE nick='Andeplane'),
313 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
319 (SELECT player FROM players WHERE nick='Andeplane'),
321 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
324 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
327 (SELECT player FROM players WHERE nick='Zeila'),
330 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
331 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
333 (SELECT player FROM players WHERE nick='Zeila'),
335 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
338 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
341 (SELECT player FROM players WHERE nick='Zeila'),
343 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
349 (SELECT player FROM players WHERE nick='Zeila'),
351 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
354 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
357 (SELECT player FROM players WHERE nick='Stream'),
360 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
361 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
363 (SELECT player FROM players WHERE nick='Stream'),
365 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
371 (SELECT player FROM players WHERE nick='Stream'),
373 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
379 (SELECT player FROM players WHERE nick='Stream'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
384 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
387 (SELECT player FROM players WHERE nick='Bonzo'),
390 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
391 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
393 (SELECT player FROM players WHERE nick='Bonzo'),
395 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
401 (SELECT player FROM players WHERE nick='Bonzo'),
403 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
406 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
409 (SELECT player FROM players WHERE nick='Bonzo'),
411 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
414 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
417 (SELECT player FROM players WHERE nick='Haggar'),
420 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
421 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
423 (SELECT player FROM players WHERE nick='Haggar'),
425 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
431 (SELECT player FROM players WHERE nick='Haggar'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
439 (SELECT player FROM players WHERE nick='Haggar'),
441 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
444 INSERT INTO groups (tournament, round, parallel) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
447 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
450 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
452 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
455 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
457 UPDATE rounds SET randomsongs=2 WHERE
458 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
460 UPDATE rounds SET chosensongs=1 WHERE
461 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
466 (SELECT player FROM players WHERE nick='Chimera'),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
472 (SELECT player FROM players WHERE nick='Chimera'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
477 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
480 (SELECT player FROM players WHERE nick='Chimera'),
482 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
488 (SELECT player FROM players WHERE nick='Chimera'),
490 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
496 (SELECT player FROM players WHERE nick='Alexxz'),
499 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
502 (SELECT player FROM players WHERE nick='Alexxz'),
504 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
510 (SELECT player FROM players WHERE nick='Alexxz'),
512 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
518 (SELECT player FROM players WHERE nick='Alexxz'),
520 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
526 (SELECT player FROM players WHERE nick='Smiph'),
529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
532 (SELECT player FROM players WHERE nick='Smiph'),
534 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
540 (SELECT player FROM players WHERE nick='Smiph'),
542 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
548 (SELECT player FROM players WHERE nick='Smiph'),
550 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
553 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
556 (SELECT player FROM players WHERE nick='Duckling'),
559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
562 (SELECT player FROM players WHERE nick='Duckling'),
564 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
570 (SELECT player FROM players WHERE nick='Duckling'),
572 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
578 (SELECT player FROM players WHERE nick='Duckling'),
580 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
583 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
586 (SELECT player FROM players WHERE nick='Pingo'),
589 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
590 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
592 (SELECT player FROM players WHERE nick='Pingo'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
597 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
600 (SELECT player FROM players WHERE nick='Pingo'),
602 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
605 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
606 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
608 (SELECT player FROM players WHERE nick='Pingo'),
610 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
613 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
614 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
616 (SELECT player FROM players WHERE nick='DufF'),
619 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
622 (SELECT player FROM players WHERE nick='DufF'),
624 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
630 (SELECT player FROM players WHERE nick='DufF'),
632 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
638 (SELECT player FROM players WHERE nick='DufF'),
640 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
643 INSERT INTO groups (tournament, round, parallel) VALUES (
644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
646 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
649 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
651 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
654 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
656 UPDATE rounds SET randomsongs=2 WHERE
657 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
659 UPDATE rounds SET chosensongs=1 WHERE
660 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
662 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
665 (SELECT player FROM players WHERE nick='Mickva'),
668 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
671 (SELECT player FROM players WHERE nick='Mickva'),
673 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
676 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
679 (SELECT player FROM players WHERE nick='Mickva'),
681 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
684 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
687 (SELECT player FROM players WHERE nick='Mickva'),
689 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
692 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
695 (SELECT player FROM players WHERE nick='Havok'),
698 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
701 (SELECT player FROM players WHERE nick='Havok'),
703 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
709 (SELECT player FROM players WHERE nick='Havok'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
717 (SELECT player FROM players WHERE nick='Havok'),
719 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
725 (SELECT player FROM players WHERE nick='Felz'),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
731 (SELECT player FROM players WHERE nick='Felz'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
739 (SELECT player FROM players WHERE nick='Felz'),
741 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
744 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
747 (SELECT player FROM players WHERE nick='Felz'),
749 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
752 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
753 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
755 (SELECT player FROM players WHERE nick='Mync'),
758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
761 (SELECT player FROM players WHERE nick='Mync'),
763 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
769 (SELECT player FROM players WHERE nick='Mync'),
771 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
777 (SELECT player FROM players WHERE nick='Mync'),
779 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
785 (SELECT player FROM players WHERE nick='Gogo'),
788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
791 (SELECT player FROM players WHERE nick='Gogo'),
793 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
799 (SELECT player FROM players WHERE nick='Gogo'),
801 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
807 (SELECT player FROM players WHERE nick='Gogo'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
812 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
813 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
815 (SELECT player FROM players WHERE nick='Snute'),
818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
821 (SELECT player FROM players WHERE nick='Snute'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
826 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
829 (SELECT player FROM players WHERE nick='Snute'),
831 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
837 (SELECT player FROM players WHERE nick='Snute'),
839 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
842 INSERT INTO groups (tournament, round, parallel) VALUES (
843 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
845 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
848 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
850 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
851 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
855 UPDATE rounds SET randomsongs=2 WHERE
856 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
858 UPDATE rounds SET chosensongs=1 WHERE
859 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
861 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
864 (SELECT player FROM players WHERE nick='Ingviild'),
867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
870 (SELECT player FROM players WHERE nick='Ingviild'),
872 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
875 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
878 (SELECT player FROM players WHERE nick='Ingviild'),
880 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
883 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
886 (SELECT player FROM players WHERE nick='Ingviild'),
888 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
894 (SELECT player FROM players WHERE nick='Ngan'),
897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
898 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
900 (SELECT player FROM players WHERE nick='Ngan'),
902 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
908 (SELECT player FROM players WHERE nick='Ngan'),
910 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
916 (SELECT player FROM players WHERE nick='Ngan'),
918 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
921 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
924 (SELECT player FROM players WHERE nick='Cuivien'),
927 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
930 (SELECT player FROM players WHERE nick='Cuivien'),
932 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
935 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
936 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
938 (SELECT player FROM players WHERE nick='Cuivien'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
946 (SELECT player FROM players WHERE nick='Cuivien'),
948 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
951 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
954 (SELECT player FROM players WHERE nick='Daniil'),
957 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
958 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
960 (SELECT player FROM players WHERE nick='Daniil'),
962 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
965 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
968 (SELECT player FROM players WHERE nick='Daniil'),
970 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
973 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
976 (SELECT player FROM players WHERE nick='Daniil'),
978 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
984 (SELECT player FROM players WHERE nick='Olemann'),
987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
990 (SELECT player FROM players WHERE nick='Olemann'),
992 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
998 (SELECT player FROM players WHERE nick='Olemann'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1006 (SELECT player FROM players WHERE nick='Olemann'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1011 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1012 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1014 (SELECT player FROM players WHERE nick='RiChY'),
1017 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1018 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1020 (SELECT player FROM players WHERE nick='RiChY'),
1022 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1028 (SELECT player FROM players WHERE nick='RiChY'),
1030 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1036 (SELECT player FROM players WHERE nick='RiChY'),
1038 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1041 INSERT INTO groups (tournament, round, parallel) VALUES (
1042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1044 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1045 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1049 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1050 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1054 UPDATE rounds SET randomsongs=2 WHERE
1055 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1057 UPDATE rounds SET chosensongs=1 WHERE
1058 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1060 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1063 (SELECT player FROM players WHERE nick='Maxion'),
1066 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1069 (SELECT player FROM players WHERE nick='Maxion'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1074 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1077 (SELECT player FROM players WHERE nick='Maxion'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1082 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1083 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1085 (SELECT player FROM players WHERE nick='Maxion'),
1087 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1090 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1091 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1093 (SELECT player FROM players WHERE nick='Lindaninja'),
1096 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1099 (SELECT player FROM players WHERE nick='Lindaninja'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1104 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1107 (SELECT player FROM players WHERE nick='Lindaninja'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1112 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1115 (SELECT player FROM players WHERE nick='Lindaninja'),
1117 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1123 (SELECT player FROM players WHERE nick='Asphodel'),
1126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1129 (SELECT player FROM players WHERE nick='Asphodel'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1137 (SELECT player FROM players WHERE nick='Asphodel'),
1139 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1142 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1145 (SELECT player FROM players WHERE nick='Asphodel'),
1147 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1150 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1153 (SELECT player FROM players WHERE nick='Cehtna'),
1156 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1159 (SELECT player FROM players WHERE nick='Cehtna'),
1161 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1164 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1167 (SELECT player FROM players WHERE nick='Cehtna'),
1169 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1173 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1175 (SELECT player FROM players WHERE nick='Cehtna'),
1177 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1180 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1181 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1183 (SELECT player FROM players WHERE nick='T|na'),
1186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1189 (SELECT player FROM players WHERE nick='T|na'),
1191 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1197 (SELECT player FROM players WHERE nick='T|na'),
1199 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1203 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1205 (SELECT player FROM players WHERE nick='T|na'),
1207 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1211 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1213 (SELECT player FROM players WHERE nick='Ylini'),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1219 (SELECT player FROM players WHERE nick='Ylini'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1227 (SELECT player FROM players WHERE nick='Ylini'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1235 (SELECT player FROM players WHERE nick='Ylini'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1243 (SELECT player FROM players WHERE nick='OJK'),
1246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1249 (SELECT player FROM players WHERE nick='OJK'),
1251 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1257 (SELECT player FROM players WHERE nick='OJK'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1263 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1265 (SELECT player FROM players WHERE nick='OJK'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1270 INSERT INTO groups (tournament, round, parallel) VALUES (
1271 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1273 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1274 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1276 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1278 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1281 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
1283 UPDATE rounds SET randomsongs=2 WHERE
1284 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1286 UPDATE rounds SET chosensongs=1 WHERE
1287 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1289 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1292 (SELECT player FROM players WHERE nick='Athena'),
1295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1298 (SELECT player FROM players WHERE nick='Athena'),
1300 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1306 (SELECT player FROM players WHERE nick='Athena'),
1308 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1311 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1312 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1314 (SELECT player FROM players WHERE nick='Athena'),
1316 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1319 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1322 (SELECT player FROM players WHERE nick='Andre'),
1325 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1328 (SELECT player FROM players WHERE nick='Andre'),
1330 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1333 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1334 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1336 (SELECT player FROM players WHERE nick='Andre'),
1338 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1344 (SELECT player FROM players WHERE nick='Andre'),
1346 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1350 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1352 (SELECT player FROM players WHERE nick='Marilla'),
1355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1358 (SELECT player FROM players WHERE nick='Marilla'),
1360 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1366 (SELECT player FROM players WHERE nick='Marilla'),
1368 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1374 (SELECT player FROM players WHERE nick='Marilla'),
1376 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1380 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1382 (SELECT player FROM players WHERE nick='Ozon'),
1385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1388 (SELECT player FROM players WHERE nick='Ozon'),
1390 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1396 (SELECT player FROM players WHERE nick='Ozon'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1401 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1402 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1404 (SELECT player FROM players WHERE nick='Ozon'),
1406 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1409 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1412 (SELECT player FROM players WHERE nick='Haanz'),
1415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1418 (SELECT player FROM players WHERE nick='Haanz'),
1420 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1424 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1426 (SELECT player FROM players WHERE nick='Haanz'),
1428 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1434 (SELECT player FROM players WHERE nick='Haanz'),
1436 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1442 (SELECT player FROM players WHERE nick='Nameless'),
1445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1446 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1448 (SELECT player FROM players WHERE nick='Nameless'),
1450 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1456 (SELECT player FROM players WHERE nick='Nameless'),
1458 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1464 (SELECT player FROM players WHERE nick='Nameless'),
1466 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1469 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1472 (SELECT player FROM players WHERE nick='Oliyzia'),
1475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1478 (SELECT player FROM players WHERE nick='Oliyzia'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1486 (SELECT player FROM players WHERE nick='Oliyzia'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1491 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1492 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1494 (SELECT player FROM players WHERE nick='Oliyzia'),
1496 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1499 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1504 INSERT INTO groups (tournament, round, parallel) VALUES (
1505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1507 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1508 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1510 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1512 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1513 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1515 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
1517 UPDATE rounds SET randomsongs=2 WHERE
1518 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1520 UPDATE rounds SET chosensongs=1 WHERE
1521 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1526 (SELECT player FROM players WHERE nick='Bonzo'),
1529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1532 (SELECT player FROM players WHERE nick='Bonzo'),
1534 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1540 (SELECT player FROM players WHERE nick='Bonzo'),
1542 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1548 (SELECT player FROM players WHERE nick='Bonzo'),
1550 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1553 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1556 (SELECT player FROM players WHERE nick='Mync'),
1559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1562 (SELECT player FROM players WHERE nick='Mync'),
1564 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1570 (SELECT player FROM players WHERE nick='Mync'),
1572 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1578 (SELECT player FROM players WHERE nick='Mync'),
1580 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1583 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1586 (SELECT player FROM players WHERE nick='Haggar'),
1589 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1590 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1592 (SELECT player FROM players WHERE nick='Haggar'),
1594 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1597 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1600 (SELECT player FROM players WHERE nick='Haggar'),
1602 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1605 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1606 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1608 (SELECT player FROM players WHERE nick='Haggar'),
1610 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1613 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1614 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1616 (SELECT player FROM players WHERE nick='Daniil'),
1619 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1622 (SELECT player FROM players WHERE nick='Daniil'),
1624 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1630 (SELECT player FROM players WHERE nick='Daniil'),
1632 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1638 (SELECT player FROM players WHERE nick='Daniil'),
1640 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1643 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1646 (SELECT player FROM players WHERE nick='Snute'),
1649 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1650 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1652 (SELECT player FROM players WHERE nick='Snute'),
1654 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1660 (SELECT player FROM players WHERE nick='Snute'),
1662 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1666 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1668 (SELECT player FROM players WHERE nick='Snute'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1673 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1674 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1676 (SELECT player FROM players WHERE nick='OJK'),
1679 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1680 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1682 (SELECT player FROM players WHERE nick='OJK'),
1684 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1687 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1690 (SELECT player FROM players WHERE nick='OJK'),
1692 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1695 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1698 (SELECT player FROM players WHERE nick='OJK'),
1700 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1703 INSERT INTO groups (tournament, round, parallel) VALUES (
1704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1706 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1707 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1709 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
1711 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1714 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1716 UPDATE rounds SET randomsongs=2 WHERE
1717 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1719 UPDATE rounds SET chosensongs=1 WHERE
1720 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1725 (SELECT player FROM players WHERE nick='Ozon'),
1728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1731 (SELECT player FROM players WHERE nick='Ozon'),
1733 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1739 (SELECT player FROM players WHERE nick='Ozon'),
1741 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1744 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1747 (SELECT player FROM players WHERE nick='Ozon'),
1749 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1752 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1753 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1755 (SELECT player FROM players WHERE nick='RiChY'),
1758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1761 (SELECT player FROM players WHERE nick='RiChY'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1769 (SELECT player FROM players WHERE nick='RiChY'),
1771 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1777 (SELECT player FROM players WHERE nick='RiChY'),
1779 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1785 (SELECT player FROM players WHERE nick='Oliyzia'),
1788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1791 (SELECT player FROM players WHERE nick='Oliyzia'),
1793 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1797 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1799 (SELECT player FROM players WHERE nick='Oliyzia'),
1801 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1807 (SELECT player FROM players WHERE nick='Oliyzia'),
1809 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1812 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1813 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1815 (SELECT player FROM players WHERE nick='T|na'),
1818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1821 (SELECT player FROM players WHERE nick='T|na'),
1823 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1826 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1827 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1829 (SELECT player FROM players WHERE nick='T|na'),
1831 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1835 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1837 (SELECT player FROM players WHERE nick='T|na'),
1839 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1842 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1843 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1845 (SELECT player FROM players WHERE nick='Nameless'),
1848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1851 (SELECT player FROM players WHERE nick='Nameless'),
1853 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1857 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1859 (SELECT player FROM players WHERE nick='Nameless'),
1861 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1864 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1865 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1867 (SELECT player FROM players WHERE nick='Nameless'),
1869 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1872 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1873 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1875 (SELECT player FROM players WHERE nick='Olemann'),
1878 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1879 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1881 (SELECT player FROM players WHERE nick='Olemann'),
1883 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1886 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1887 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1889 (SELECT player FROM players WHERE nick='Olemann'),
1891 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1897 (SELECT player FROM players WHERE nick='Olemann'),
1899 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1902 INSERT INTO groups (tournament, round, parallel) VALUES (
1903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1905 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1906 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1910 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1913 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1915 UPDATE rounds SET randomsongs=2 WHERE
1916 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1918 UPDATE rounds SET chosensongs=1 WHERE
1919 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
1921 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1924 (SELECT player FROM players WHERE nick='Ylini'),
1927 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1930 (SELECT player FROM players WHERE nick='Ylini'),
1932 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1935 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1936 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1938 (SELECT player FROM players WHERE nick='Ylini'),
1940 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1946 (SELECT player FROM players WHERE nick='Ylini'),
1948 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1951 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1954 (SELECT player FROM players WHERE nick='Pingo'),
1957 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1958 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1960 (SELECT player FROM players WHERE nick='Pingo'),
1962 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1965 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1968 (SELECT player FROM players WHERE nick='Pingo'),
1970 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1973 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1976 (SELECT player FROM players WHERE nick='Pingo'),
1978 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1982 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1984 (SELECT player FROM players WHERE nick='Gogo'),
1987 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1990 (SELECT player FROM players WHERE nick='Gogo'),
1992 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
1998 (SELECT player FROM players WHERE nick='Gogo'),
2000 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2006 (SELECT player FROM players WHERE nick='Gogo'),
2008 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2011 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2012 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2014 (SELECT player FROM players WHERE nick='Duckling'),
2017 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2018 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2020 (SELECT player FROM players WHERE nick='Duckling'),
2022 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2028 (SELECT player FROM players WHERE nick='Duckling'),
2030 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2036 (SELECT player FROM players WHERE nick='Duckling'),
2038 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2041 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2044 (SELECT player FROM players WHERE nick='Stream'),
2047 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2048 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2050 (SELECT player FROM players WHERE nick='Stream'),
2052 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2055 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2056 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2058 (SELECT player FROM players WHERE nick='Stream'),
2060 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2064 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2066 (SELECT player FROM players WHERE nick='Stream'),
2068 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2071 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2072 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2074 (SELECT player FROM players WHERE nick='DufF'),
2077 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2080 (SELECT player FROM players WHERE nick='DufF'),
2082 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2085 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2086 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2088 (SELECT player FROM players WHERE nick='DufF'),
2090 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2093 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2096 (SELECT player FROM players WHERE nick='DufF'),
2098 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2101 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2106 INSERT INTO groups (tournament, round, parallel) VALUES (
2107 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2109 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2110 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2112 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
2114 UPDATE rounds SET randomsongs=1 WHERE
2115 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2117 UPDATE rounds SET chosensongs=1 WHERE
2118 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2123 (SELECT player FROM players WHERE nick='RiChY'),
2126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2129 (SELECT player FROM players WHERE nick='RiChY'),
2131 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2135 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2137 (SELECT player FROM players WHERE nick='RiChY'),
2139 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2142 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2145 (SELECT player FROM players WHERE nick='Pingo'),
2148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2151 (SELECT player FROM players WHERE nick='Pingo'),
2153 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2156 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2159 (SELECT player FROM players WHERE nick='Pingo'),
2161 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2164 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2165 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2167 (SELECT player FROM players WHERE nick='OJK'),
2170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2171 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2173 (SELECT player FROM players WHERE nick='OJK'),
2175 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2181 (SELECT player FROM players WHERE nick='OJK'),
2183 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2189 (SELECT player FROM players WHERE nick='T|na'),
2192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2195 (SELECT player FROM players WHERE nick='T|na'),
2197 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2203 (SELECT player FROM players WHERE nick='T|na'),
2205 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2208 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2211 (SELECT player FROM players WHERE nick='Haggar'),
2214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2217 (SELECT player FROM players WHERE nick='Haggar'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2225 (SELECT player FROM players WHERE nick='Haggar'),
2227 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2230 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2233 (SELECT player FROM players WHERE nick='Gogo'),
2236 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2239 (SELECT player FROM players WHERE nick='Gogo'),
2241 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2244 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2247 (SELECT player FROM players WHERE nick='Gogo'),
2249 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2255 (SELECT player FROM players WHERE nick='Nameless'),
2258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2261 (SELECT player FROM players WHERE nick='Nameless'),
2263 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2269 (SELECT player FROM players WHERE nick='Nameless'),
2271 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2274 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2275 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2277 (SELECT player FROM players WHERE nick='DufF'),
2280 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2283 (SELECT player FROM players WHERE nick='DufF'),
2285 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2288 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2291 (SELECT player FROM players WHERE nick='DufF'),
2293 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2296 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2299 (SELECT player FROM players WHERE nick='Snute'),
2302 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2303 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2305 (SELECT player FROM players WHERE nick='Snute'),
2307 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2313 (SELECT player FROM players WHERE nick='Snute'),
2315 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2318 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2320 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2323 INSERT INTO groups (tournament, round, parallel) VALUES (
2324 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2326 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2329 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
2331 UPDATE rounds SET randomsongs=1 WHERE
2332 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2334 UPDATE rounds SET chosensongs=1 WHERE
2335 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2337 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2340 (SELECT player FROM players WHERE nick='Gogo'),
2343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2346 (SELECT player FROM players WHERE nick='Gogo'),
2348 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2354 (SELECT player FROM players WHERE nick='Gogo'),
2356 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2359 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2362 (SELECT player FROM players WHERE nick='Haggar'),
2365 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2366 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2368 (SELECT player FROM players WHERE nick='Haggar'),
2370 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2373 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2374 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2376 (SELECT player FROM players WHERE nick='Haggar'),
2378 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2381 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2382 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2384 (SELECT player FROM players WHERE nick='Nameless'),
2387 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2388 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2390 (SELECT player FROM players WHERE nick='Nameless'),
2392 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2395 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2396 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2398 (SELECT player FROM players WHERE nick='Nameless'),
2400 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2406 (SELECT player FROM players WHERE nick='RiChY'),
2409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2412 (SELECT player FROM players WHERE nick='RiChY'),
2414 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2420 (SELECT player FROM players WHERE nick='RiChY'),
2422 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2425 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2428 (SELECT player FROM players WHERE nick='DufF'),
2431 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2432 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2434 (SELECT player FROM players WHERE nick='DufF'),
2436 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2439 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2442 (SELECT player FROM players WHERE nick='DufF'),
2444 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2450 (SELECT player FROM players WHERE nick='OJK'),
2453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2454 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2456 (SELECT player FROM players WHERE nick='OJK'),
2458 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2464 (SELECT player FROM players WHERE nick='OJK'),
2466 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2469 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2472 (SELECT player FROM players WHERE nick='Snute'),
2475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2478 (SELECT player FROM players WHERE nick='Snute'),
2480 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2486 (SELECT player FROM players WHERE nick='Snute'),
2488 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2491 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2496 INSERT INTO groups (tournament, round, parallel) VALUES (
2497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2499 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2502 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
2504 UPDATE rounds SET randomsongs=1 WHERE
2505 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2507 UPDATE rounds SET chosensongs=1 WHERE
2508 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2510 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2511 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2513 (SELECT player FROM players WHERE nick='RiChY'),
2516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2519 (SELECT player FROM players WHERE nick='RiChY'),
2521 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2527 (SELECT player FROM players WHERE nick='RiChY'),
2529 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2532 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2535 (SELECT player FROM players WHERE nick='DufF'),
2538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2541 (SELECT player FROM players WHERE nick='DufF'),
2543 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2549 (SELECT player FROM players WHERE nick='DufF'),
2551 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2554 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2555 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2557 (SELECT player FROM players WHERE nick='OJK'),
2560 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2563 (SELECT player FROM players WHERE nick='OJK'),
2565 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2569 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2571 (SELECT player FROM players WHERE nick='OJK'),
2573 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2576 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2579 (SELECT player FROM players WHERE nick='Snute'),
2582 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2583 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2585 (SELECT player FROM players WHERE nick='Snute'),
2587 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2590 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2593 (SELECT player FROM players WHERE nick='Snute'),
2595 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2601 (SELECT player FROM players WHERE nick='Haggar'),
2604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2607 (SELECT player FROM players WHERE nick='Haggar'),
2609 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2612 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2613 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2615 (SELECT player FROM players WHERE nick='Haggar'),
2617 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2620 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2625 INSERT INTO groups (tournament, round, parallel) VALUES (
2626 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2628 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2629 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2631 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
2633 UPDATE rounds SET randomsongs=1 WHERE
2634 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2636 UPDATE rounds SET chosensongs=1 WHERE
2637 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2639 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2640 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2642 (SELECT player FROM players WHERE nick='Haggar'),
2645 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2646 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2648 (SELECT player FROM players WHERE nick='Haggar'),
2650 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2653 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2654 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2656 (SELECT player FROM players WHERE nick='Haggar'),
2658 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2661 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2662 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2664 (SELECT player FROM players WHERE nick='OJK'),
2667 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2668 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2670 (SELECT player FROM players WHERE nick='OJK'),
2672 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2675 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2676 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2678 (SELECT player FROM players WHERE nick='OJK'),
2680 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2683 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2684 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2686 (SELECT player FROM players WHERE nick='DufF'),
2689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2692 (SELECT player FROM players WHERE nick='DufF'),
2694 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2700 (SELECT player FROM players WHERE nick='DufF'),
2702 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2705 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2708 (SELECT player FROM players WHERE nick='Snute'),
2711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2714 (SELECT player FROM players WHERE nick='Snute'),
2716 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
2719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2722 (SELECT player FROM players WHERE nick='Snute'),
2724 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2727 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2732 INSERT INTO groups (tournament, round, parallel) VALUES (
2733 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2735 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2738 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
2740 UPDATE rounds SET randomsongs=1 WHERE
2741 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2743 UPDATE rounds SET chosensongs=1 WHERE
2744 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2746 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2749 (SELECT player FROM players WHERE nick='DufF'),
2752 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2753 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2755 (SELECT player FROM players WHERE nick='DufF'),
2757 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2760 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2761 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2763 (SELECT player FROM players WHERE nick='DufF'),
2765 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2768 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2769 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2771 (SELECT player FROM players WHERE nick='Snute'),
2774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2777 (SELECT player FROM players WHERE nick='Snute'),
2779 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2785 (SELECT player FROM players WHERE nick='Snute'),
2787 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2790 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2791 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2793 (SELECT player FROM players WHERE nick='Haggar'),
2796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2797 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2799 (SELECT player FROM players WHERE nick='Haggar'),
2801 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2807 (SELECT player FROM players WHERE nick='Haggar'),
2809 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2812 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2817 INSERT INTO groups (tournament, round, parallel) VALUES (
2818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2820 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2821 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2823 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
2825 UPDATE rounds SET randomsongs=1 WHERE
2826 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2828 UPDATE rounds SET chosensongs=1 WHERE
2829 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2831 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2832 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2834 (SELECT player FROM players WHERE nick='DufF'),
2837 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2838 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2840 (SELECT player FROM players WHERE nick='DufF'),
2842 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2845 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2848 (SELECT player FROM players WHERE nick='DufF'),
2850 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2853 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2856 (SELECT player FROM players WHERE nick='Snute'),
2859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2862 (SELECT player FROM players WHERE nick='Snute'),
2864 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
2867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2870 (SELECT player FROM players WHERE nick='Snute'),
2872 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2875 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2880 INSERT INTO groups (tournament, round, parallel) VALUES (
2881 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2883 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2884 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2886 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
2888 UPDATE rounds SET randomsongs=1 WHERE
2889 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2891 UPDATE rounds SET chosensongs=1 WHERE
2892 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2894 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2897 (SELECT player FROM players WHERE nick='Ylini'),
2900 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2901 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2903 (SELECT player FROM players WHERE nick='Ylini'),
2905 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2908 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2909 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2911 (SELECT player FROM players WHERE nick='Ylini'),
2913 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2916 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2917 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2919 (SELECT player FROM players WHERE nick='Oliyzia'),
2922 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2925 (SELECT player FROM players WHERE nick='Oliyzia'),
2927 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2933 (SELECT player FROM players WHERE nick='Oliyzia'),
2935 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2938 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2939 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2941 (SELECT player FROM players WHERE nick='T|na'),
2944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2947 (SELECT player FROM players WHERE nick='T|na'),
2949 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
2952 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2953 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2955 (SELECT player FROM players WHERE nick='T|na'),
2957 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2960 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2962 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2965 INSERT INTO groups (tournament, round, parallel) VALUES (
2966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2968 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2969 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2971 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
2973 UPDATE rounds SET randomsongs=1 WHERE
2974 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2976 UPDATE rounds SET chosensongs=1 WHERE
2977 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM') AND
2979 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2980 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2982 (SELECT player FROM players WHERE nick='T|na'),
2985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2986 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2988 (SELECT player FROM players WHERE nick='T|na'),
2990 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2993 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2994 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
2996 (SELECT player FROM players WHERE nick='T|na'),
2998 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3001 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3002 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
3004 (SELECT player FROM players WHERE nick='Oliyzia'),
3007 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3008 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
3010 (SELECT player FROM players WHERE nick='Oliyzia'),
3012 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
3015 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3016 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'),
3018 (SELECT player FROM players WHERE nick='Oliyzia'),
3020 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),