2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE countryname='Norway'),
7 'Tønsberg - Sjøsenteret bowling',
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, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
16 (SELECT player FROM players WHERE nick='Haggar'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
28 (SELECT player FROM players WHERE nick='Nameless'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
34 (SELECT player FROM players WHERE nick='Snofox'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
40 (SELECT player FROM players WHERE nick='Bonzo'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
46 (SELECT player FROM players WHERE nick='Oliyzia'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
52 (SELECT player FROM players WHERE nick='RiChY'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
58 (SELECT player FROM players WHERE nick='OJK'),
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 7'),
64 (SELECT player FROM players WHERE nick='Pingo'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
70 (SELECT player FROM players WHERE nick='Gogo'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
76 (SELECT player FROM players WHERE nick='T|na'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
82 (SELECT player FROM players WHERE nick='Olemann'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
88 (SELECT player FROM players WHERE nick='Duckling'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
94 (SELECT player FROM players WHERE nick='Andeplane'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
100 (SELECT player FROM players WHERE nick='Ylini'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
106 (SELECT player FROM players WHERE nick='Daniil'),
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 7'),
112 (SELECT player FROM players WHERE nick='Mync'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
118 (SELECT player FROM players WHERE nick='Smiph'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
124 (SELECT player FROM players WHERE nick='Felz'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
130 (SELECT player FROM players WHERE nick='Alexxz'),
132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
136 (SELECT player FROM players WHERE nick='v|per'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dritago' AS nick WHERE 'Dritago' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
142 (SELECT player FROM players WHERE nick='Dritago'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'SLC' AS nick WHERE 'SLC' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
148 (SELECT player FROM players WHERE nick='SLC'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
154 (SELECT player FROM players WHERE nick='Athena'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
160 (SELECT player FROM players WHERE nick='Pfxp'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
166 (SELECT player FROM players WHERE nick='Matsi'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeila' AS nick WHERE 'Zeila' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
172 (SELECT player FROM players WHERE nick='Zeila'),
174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
178 (SELECT player FROM players WHERE nick='Electron'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
184 (SELECT player FROM players WHERE nick='Pyro'),
186 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Volstad' AS nick WHERE 'Volstad' NOT IN ( SELECT nick FROM players );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
190 (SELECT player FROM players WHERE nick='Volstad'),
192 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
193 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
194 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
196 (SELECT player FROM players WHERE nick='Zackie'),
198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
199 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
202 (SELECT player FROM players WHERE nick='Matti'),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eruanna' AS nick WHERE 'Eruanna' NOT IN ( SELECT nick FROM players );
205 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
208 (SELECT player FROM players WHERE nick='Eruanna'),
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick WHERE 'Indy' NOT IN ( SELECT nick FROM players );
211 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
214 (SELECT player FROM players WHERE nick='Indy'),
216 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Crienexzy' AS nick WHERE 'Crienexzy' NOT IN ( SELECT nick FROM players );
217 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
220 (SELECT player FROM players WHERE nick='Crienexzy'),
222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
223 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
226 (SELECT player FROM players WHERE nick='Hyper'),
228 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick WHERE 'Benny' NOT IN ( SELECT nick FROM players );
229 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
232 (SELECT player FROM players WHERE nick='Benny'),
234 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Marilla' AS nick WHERE 'Marilla' NOT IN ( SELECT nick FROM players );
235 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
238 (SELECT player FROM players WHERE nick='Marilla'),
240 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'uSimen' AS nick WHERE 'uSimen' NOT IN ( SELECT nick FROM players );
241 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
244 (SELECT player FROM players WHERE nick='uSimen'),
246 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
247 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
250 (SELECT player FROM players WHERE nick='JonAnders'),
252 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
253 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
254 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
256 (SELECT player FROM players WHERE nick='Bush'),
258 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Voffen' AS nick WHERE 'Voffen' NOT IN ( SELECT nick FROM players );
259 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
260 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
262 (SELECT player FROM players WHERE nick='Voffen'),
264 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
265 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
266 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
268 (SELECT player FROM players WHERE nick='Annkakri'),
270 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
271 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
274 (SELECT player FROM players WHERE nick='Glock'),
276 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tove' AS nick WHERE 'Tove' NOT IN ( SELECT nick FROM players );
277 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
278 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
280 (SELECT player FROM players WHERE nick='Tove'),
282 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
287 INSERT INTO groups (tournament, round, parallel) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
290 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
293 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
295 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
298 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
300 UPDATE rounds SET randomsongs=2 WHERE
301 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
303 UPDATE rounds SET chosensongs=1 WHERE
304 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
309 (SELECT player FROM players WHERE nick='Crienexzy'),
312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
315 (SELECT player FROM players WHERE nick='Crienexzy'),
317 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
323 (SELECT player FROM players WHERE nick='Crienexzy'),
325 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
331 (SELECT player FROM players WHERE nick='Crienexzy'),
333 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
339 (SELECT player FROM players WHERE nick='Tove'),
342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
345 (SELECT player FROM players WHERE nick='Tove'),
347 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
353 (SELECT player FROM players WHERE nick='Tove'),
355 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
361 (SELECT player FROM players WHERE nick='Tove'),
363 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
369 (SELECT player FROM players WHERE nick='JonAnders'),
372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
375 (SELECT player FROM players WHERE nick='JonAnders'),
377 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
383 (SELECT player FROM players WHERE nick='JonAnders'),
385 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
391 (SELECT player FROM players WHERE nick='JonAnders'),
393 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
397 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
399 (SELECT player FROM players WHERE nick='Andeplane'),
402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
405 (SELECT player FROM players WHERE nick='Andeplane'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
411 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
413 (SELECT player FROM players WHERE nick='Andeplane'),
415 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
421 (SELECT player FROM players WHERE nick='Andeplane'),
423 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
426 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
427 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
429 (SELECT player FROM players WHERE nick='Matsi'),
432 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
433 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
435 (SELECT player FROM players WHERE nick='Matsi'),
437 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
443 (SELECT player FROM players WHERE nick='Matsi'),
445 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
448 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
451 (SELECT player FROM players WHERE nick='Matsi'),
453 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
456 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
457 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
459 (SELECT player FROM players WHERE nick='Snofox'),
462 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
463 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
465 (SELECT player FROM players WHERE nick='Snofox'),
467 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
473 (SELECT player FROM players WHERE nick='Snofox'),
475 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
481 (SELECT player FROM players WHERE nick='Snofox'),
483 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
486 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
489 (SELECT player FROM players WHERE nick='T|na'),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
495 (SELECT player FROM players WHERE nick='T|na'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
503 (SELECT player FROM players WHERE nick='T|na'),
505 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
511 (SELECT player FROM players WHERE nick='T|na'),
513 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
516 INSERT INTO groups (tournament, round, parallel) VALUES (
517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
519 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
520 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
522 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
524 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
527 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
529 UPDATE rounds SET randomsongs=2 WHERE
530 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
532 UPDATE rounds SET chosensongs=1 WHERE
533 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
538 (SELECT player FROM players WHERE nick='uSimen'),
541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
544 (SELECT player FROM players WHERE nick='uSimen'),
546 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
552 (SELECT player FROM players WHERE nick='uSimen'),
554 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
558 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
560 (SELECT player FROM players WHERE nick='uSimen'),
562 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
566 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
568 (SELECT player FROM players WHERE nick='Pfxp'),
571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
574 (SELECT player FROM players WHERE nick='Pfxp'),
576 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
582 (SELECT player FROM players WHERE nick='Pfxp'),
584 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
588 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
590 (SELECT player FROM players WHERE nick='Pfxp'),
592 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
595 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
596 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
598 (SELECT player FROM players WHERE nick='Glock'),
601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
602 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
604 (SELECT player FROM players WHERE nick='Glock'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
609 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
610 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
612 (SELECT player FROM players WHERE nick='Glock'),
614 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
618 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
620 (SELECT player FROM players WHERE nick='Glock'),
622 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
625 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
626 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
628 (SELECT player FROM players WHERE nick='Eruanna'),
631 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
632 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
634 (SELECT player FROM players WHERE nick='Eruanna'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
642 (SELECT player FROM players WHERE nick='Eruanna'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
648 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
650 (SELECT player FROM players WHERE nick='Eruanna'),
652 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
655 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
658 (SELECT player FROM players WHERE nick='v|per'),
661 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
662 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
664 (SELECT player FROM players WHERE nick='v|per'),
666 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
672 (SELECT player FROM players WHERE nick='v|per'),
674 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
680 (SELECT player FROM players WHERE nick='v|per'),
682 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
685 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
688 (SELECT player FROM players WHERE nick='Daniil'),
691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
692 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
694 (SELECT player FROM players WHERE nick='Daniil'),
696 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
700 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
702 (SELECT player FROM players WHERE nick='Daniil'),
704 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
707 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
710 (SELECT player FROM players WHERE nick='Daniil'),
712 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
715 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
716 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
718 (SELECT player FROM players WHERE nick='Nameless'),
721 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
722 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
724 (SELECT player FROM players WHERE nick='Nameless'),
726 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
730 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
732 (SELECT player FROM players WHERE nick='Nameless'),
734 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
740 (SELECT player FROM players WHERE nick='Nameless'),
742 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
745 INSERT INTO groups (tournament, round, parallel) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
748 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
749 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
751 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
753 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
756 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
758 UPDATE rounds SET randomsongs=2 WHERE
759 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
761 UPDATE rounds SET chosensongs=1 WHERE
762 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
765 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
767 (SELECT player FROM players WHERE nick='Benny'),
770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
773 (SELECT player FROM players WHERE nick='Benny'),
775 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
781 (SELECT player FROM players WHERE nick='Benny'),
783 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
786 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
787 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
789 (SELECT player FROM players WHERE nick='Benny'),
791 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
795 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
797 (SELECT player FROM players WHERE nick='Volstad'),
800 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
801 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
803 (SELECT player FROM players WHERE nick='Volstad'),
805 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
808 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
809 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
811 (SELECT player FROM players WHERE nick='Volstad'),
813 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
816 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
817 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
819 (SELECT player FROM players WHERE nick='Volstad'),
821 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
824 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
825 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
827 (SELECT player FROM players WHERE nick='Annkakri'),
830 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
833 (SELECT player FROM players WHERE nick='Annkakri'),
835 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
841 (SELECT player FROM players WHERE nick='Annkakri'),
843 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
849 (SELECT player FROM players WHERE nick='Annkakri'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
857 (SELECT player FROM players WHERE nick='Athena'),
860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
863 (SELECT player FROM players WHERE nick='Athena'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
871 (SELECT player FROM players WHERE nick='Athena'),
873 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
876 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
879 (SELECT player FROM players WHERE nick='Athena'),
881 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
884 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
885 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
887 (SELECT player FROM players WHERE nick='Felz'),
890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
893 (SELECT player FROM players WHERE nick='Felz'),
895 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
901 (SELECT player FROM players WHERE nick='Felz'),
903 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
909 (SELECT player FROM players WHERE nick='Felz'),
911 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
914 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
917 (SELECT player FROM players WHERE nick='Ylini'),
920 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
923 (SELECT player FROM players WHERE nick='Ylini'),
925 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
931 (SELECT player FROM players WHERE nick='Ylini'),
933 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
939 (SELECT player FROM players WHERE nick='Ylini'),
941 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
944 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
947 (SELECT player FROM players WHERE nick='Oliyzia'),
950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
953 (SELECT player FROM players WHERE nick='Oliyzia'),
955 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
961 (SELECT player FROM players WHERE nick='Oliyzia'),
963 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
969 (SELECT player FROM players WHERE nick='Oliyzia'),
971 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
974 INSERT INTO groups (tournament, round, parallel) VALUES (
975 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
977 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
978 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
980 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
982 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
985 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
987 UPDATE rounds SET randomsongs=2 WHERE
988 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
990 UPDATE rounds SET chosensongs=1 WHERE
991 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
993 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
994 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
996 (SELECT player FROM players WHERE nick='Voffen'),
999 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1000 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1002 (SELECT player FROM players WHERE nick='Voffen'),
1004 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1007 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1008 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1010 (SELECT player FROM players WHERE nick='Voffen'),
1012 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1015 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1016 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1018 (SELECT player FROM players WHERE nick='Voffen'),
1020 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1023 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1024 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1026 (SELECT player FROM players WHERE nick='Zackie'),
1029 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1032 (SELECT player FROM players WHERE nick='Zackie'),
1034 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1038 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1040 (SELECT player FROM players WHERE nick='Zackie'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1048 (SELECT player FROM players WHERE nick='Zackie'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1053 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1054 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1056 (SELECT player FROM players WHERE nick='Zeila'),
1059 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1060 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1062 (SELECT player FROM players WHERE nick='Zeila'),
1064 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1067 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1068 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1070 (SELECT player FROM players WHERE nick='Zeila'),
1072 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1075 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1076 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1078 (SELECT player FROM players WHERE nick='Zeila'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1083 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1084 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1086 (SELECT player FROM players WHERE nick='Alexxz'),
1089 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1092 (SELECT player FROM players WHERE nick='Alexxz'),
1094 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1097 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1098 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1100 (SELECT player FROM players WHERE nick='Alexxz'),
1102 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1108 (SELECT player FROM players WHERE nick='Alexxz'),
1110 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1113 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1116 (SELECT player FROM players WHERE nick='Olemann'),
1119 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1122 (SELECT player FROM players WHERE nick='Olemann'),
1124 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1130 (SELECT player FROM players WHERE nick='Olemann'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1138 (SELECT player FROM players WHERE nick='Olemann'),
1140 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1143 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1146 (SELECT player FROM players WHERE nick='RiChY'),
1149 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1150 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1152 (SELECT player FROM players WHERE nick='RiChY'),
1154 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1160 (SELECT player FROM players WHERE nick='RiChY'),
1162 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
1165 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1168 (SELECT player FROM players WHERE nick='RiChY'),
1170 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1173 INSERT INTO groups (tournament, round, parallel) VALUES (
1174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1176 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1177 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1179 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
1181 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1184 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1186 UPDATE rounds SET randomsongs=2 WHERE
1187 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1189 UPDATE rounds SET chosensongs=1 WHERE
1190 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1195 (SELECT player FROM players WHERE nick='SLC'),
1198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1201 (SELECT player FROM players WHERE nick='SLC'),
1203 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1209 (SELECT player FROM players WHERE nick='SLC'),
1211 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1217 (SELECT player FROM players WHERE nick='SLC'),
1219 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1222 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1225 (SELECT player FROM players WHERE nick='Matti'),
1228 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1229 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1231 (SELECT player FROM players WHERE nick='Matti'),
1233 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1236 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1239 (SELECT player FROM players WHERE nick='Matti'),
1241 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1244 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1245 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1247 (SELECT player FROM players WHERE nick='Matti'),
1249 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1255 (SELECT player FROM players WHERE nick='Hyper'),
1258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1261 (SELECT player FROM players WHERE nick='Hyper'),
1263 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1269 (SELECT player FROM players WHERE nick='Hyper'),
1271 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1275 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1277 (SELECT player FROM players WHERE nick='Hyper'),
1279 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1282 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1285 (SELECT player FROM players WHERE nick='Mync'),
1288 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1291 (SELECT player FROM players WHERE nick='Mync'),
1293 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1296 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1299 (SELECT player FROM players WHERE nick='Mync'),
1301 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1307 (SELECT player FROM players WHERE nick='Mync'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1315 (SELECT player FROM players WHERE nick='Duckling'),
1318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1321 (SELECT player FROM players WHERE nick='Duckling'),
1323 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1329 (SELECT player FROM players WHERE nick='Duckling'),
1331 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1337 (SELECT player FROM players WHERE nick='Duckling'),
1339 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1342 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1345 (SELECT player FROM players WHERE nick='Haggar'),
1348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1351 (SELECT player FROM players WHERE nick='Haggar'),
1353 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1359 (SELECT player FROM players WHERE nick='Haggar'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1364 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1367 (SELECT player FROM players WHERE nick='Haggar'),
1369 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1372 INSERT INTO groups (tournament, round, parallel) VALUES (
1373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1375 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1376 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1378 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
1380 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1383 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1385 UPDATE rounds SET randomsongs=2 WHERE
1386 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1388 UPDATE rounds SET chosensongs=1 WHERE
1389 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1394 (SELECT player FROM players WHERE nick='Dritago'),
1397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1400 (SELECT player FROM players WHERE nick='Dritago'),
1402 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1408 (SELECT player FROM players WHERE nick='Dritago'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1413 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1416 (SELECT player FROM players WHERE nick='Dritago'),
1418 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1421 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1424 (SELECT player FROM players WHERE nick='Pyro'),
1427 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1428 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1430 (SELECT player FROM players WHERE nick='Pyro'),
1432 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1435 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1436 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1438 (SELECT player FROM players WHERE nick='Pyro'),
1440 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1443 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1444 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1446 (SELECT player FROM players WHERE nick='Pyro'),
1448 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1451 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1452 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1454 (SELECT player FROM players WHERE nick='Marilla'),
1457 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1458 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1460 (SELECT player FROM players WHERE nick='Marilla'),
1462 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1465 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1466 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1468 (SELECT player FROM players WHERE nick='Marilla'),
1470 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1474 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1476 (SELECT player FROM players WHERE nick='Marilla'),
1478 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1481 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1484 (SELECT player FROM players WHERE nick='Pingo'),
1487 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1490 (SELECT player FROM players WHERE nick='Pingo'),
1492 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1498 (SELECT player FROM players WHERE nick='Pingo'),
1500 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1506 (SELECT player FROM players WHERE nick='Pingo'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1511 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1512 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1514 (SELECT player FROM players WHERE nick='Bonzo'),
1517 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1520 (SELECT player FROM players WHERE nick='Bonzo'),
1522 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1525 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1528 (SELECT player FROM players WHERE nick='Bonzo'),
1530 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1533 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1534 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1536 (SELECT player FROM players WHERE nick='Bonzo'),
1538 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1541 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1542 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1544 (SELECT player FROM players WHERE nick='OJK'),
1547 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1550 (SELECT player FROM players WHERE nick='OJK'),
1552 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1555 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1558 (SELECT player FROM players WHERE nick='OJK'),
1560 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1563 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1564 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1566 (SELECT player FROM players WHERE nick='OJK'),
1568 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1571 INSERT INTO groups (tournament, round, parallel) VALUES (
1572 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1574 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1575 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1577 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
1579 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1580 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1582 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1584 UPDATE rounds SET randomsongs=2 WHERE
1585 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1587 UPDATE rounds SET chosensongs=1 WHERE
1588 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1593 (SELECT player FROM players WHERE nick='Indy'),
1596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1599 (SELECT player FROM players WHERE nick='Indy'),
1601 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1607 (SELECT player FROM players WHERE nick='Indy'),
1609 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1612 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1613 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1615 (SELECT player FROM players WHERE nick='Indy'),
1617 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1620 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1623 (SELECT player FROM players WHERE nick='Electron'),
1626 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1627 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1629 (SELECT player FROM players WHERE nick='Electron'),
1631 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1634 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1635 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1637 (SELECT player FROM players WHERE nick='Electron'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1642 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1643 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1645 (SELECT player FROM players WHERE nick='Electron'),
1647 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1650 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1651 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1653 (SELECT player FROM players WHERE nick='Bush'),
1656 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1659 (SELECT player FROM players WHERE nick='Bush'),
1661 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1665 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1667 (SELECT player FROM players WHERE nick='Bush'),
1669 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1672 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1675 (SELECT player FROM players WHERE nick='Bush'),
1677 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1680 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1683 (SELECT player FROM players WHERE nick='Gogo'),
1686 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1687 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1689 (SELECT player FROM players WHERE nick='Gogo'),
1691 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1694 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1697 (SELECT player FROM players WHERE nick='Gogo'),
1699 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1702 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1703 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1705 (SELECT player FROM players WHERE nick='Gogo'),
1707 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1710 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1711 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1713 (SELECT player FROM players WHERE nick='Smiph'),
1716 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1717 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1719 (SELECT player FROM players WHERE nick='Smiph'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1724 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1725 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1727 (SELECT player FROM players WHERE nick='Smiph'),
1729 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1732 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1733 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1735 (SELECT player FROM players WHERE nick='Smiph'),
1737 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1740 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1741 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1743 (SELECT player FROM players WHERE nick='Snute'),
1746 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1749 (SELECT player FROM players WHERE nick='Snute'),
1751 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1754 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1757 (SELECT player FROM players WHERE nick='Snute'),
1759 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1762 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1763 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1765 (SELECT player FROM players WHERE nick='Snute'),
1767 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1770 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1772 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1775 INSERT INTO groups (tournament, round, parallel) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1778 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1781 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best'))
1783 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1786 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1788 UPDATE rounds SET randomsongs=2 WHERE
1789 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1791 UPDATE rounds SET chosensongs=1 WHERE
1792 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
1794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1795 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1797 (SELECT player FROM players WHERE nick='v|per'),
1800 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1801 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1803 (SELECT player FROM players WHERE nick='v|per'),
1805 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1808 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1809 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1811 (SELECT player FROM players WHERE nick='v|per'),
1813 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1816 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1817 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1819 (SELECT player FROM players WHERE nick='v|per'),
1821 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1824 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1825 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1827 (SELECT player FROM players WHERE nick='Mync'),
1830 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1833 (SELECT player FROM players WHERE nick='Mync'),
1835 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1839 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1841 (SELECT player FROM players WHERE nick='Mync'),
1843 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1849 (SELECT player FROM players WHERE nick='Mync'),
1851 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1855 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1857 (SELECT player FROM players WHERE nick='Duckling'),
1860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1863 (SELECT player FROM players WHERE nick='Duckling'),
1865 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1869 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1871 (SELECT player FROM players WHERE nick='Duckling'),
1873 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1876 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1879 (SELECT player FROM players WHERE nick='Duckling'),
1881 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1884 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1885 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1887 (SELECT player FROM players WHERE nick='T|na'),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1893 (SELECT player FROM players WHERE nick='T|na'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1901 (SELECT player FROM players WHERE nick='T|na'),
1903 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1909 (SELECT player FROM players WHERE nick='T|na'),
1911 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1914 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1917 (SELECT player FROM players WHERE nick='Pingo'),
1920 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1921 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1923 (SELECT player FROM players WHERE nick='Pingo'),
1925 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1929 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1931 (SELECT player FROM players WHERE nick='Pingo'),
1933 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1937 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1939 (SELECT player FROM players WHERE nick='Pingo'),
1941 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1944 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1945 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1947 (SELECT player FROM players WHERE nick='Haggar'),
1950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1951 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1953 (SELECT player FROM players WHERE nick='Haggar'),
1955 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1961 (SELECT player FROM players WHERE nick='Haggar'),
1963 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1967 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1969 (SELECT player FROM players WHERE nick='Haggar'),
1971 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1974 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1975 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1977 (SELECT player FROM players WHERE nick='OJK'),
1980 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1981 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1983 (SELECT player FROM players WHERE nick='OJK'),
1985 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
1988 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1991 (SELECT player FROM players WHERE nick='OJK'),
1993 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1997 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
1999 (SELECT player FROM players WHERE nick='OJK'),
2001 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2004 INSERT INTO groups (tournament, round, parallel) VALUES (
2005 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2007 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2008 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2010 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2012 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2013 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2015 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
2017 UPDATE rounds SET randomsongs=2 WHERE
2018 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2020 UPDATE rounds SET chosensongs=1 WHERE
2021 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2023 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2024 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2026 (SELECT player FROM players WHERE nick='Alexxz'),
2029 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2030 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2032 (SELECT player FROM players WHERE nick='Alexxz'),
2034 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2038 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2040 (SELECT player FROM players WHERE nick='Alexxz'),
2042 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2048 (SELECT player FROM players WHERE nick='Alexxz'),
2050 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2053 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2054 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2056 (SELECT player FROM players WHERE nick='Smiph'),
2059 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2060 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2062 (SELECT player FROM players WHERE nick='Smiph'),
2064 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2067 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2068 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2070 (SELECT player FROM players WHERE nick='Smiph'),
2072 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2075 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2076 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2078 (SELECT player FROM players WHERE nick='Smiph'),
2080 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2083 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2084 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2086 (SELECT player FROM players WHERE nick='Ylini'),
2089 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2092 (SELECT player FROM players WHERE nick='Ylini'),
2094 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2097 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2098 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2100 (SELECT player FROM players WHERE nick='Ylini'),
2102 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2108 (SELECT player FROM players WHERE nick='Ylini'),
2110 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2113 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2116 (SELECT player FROM players WHERE nick='Gogo'),
2119 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2122 (SELECT player FROM players WHERE nick='Gogo'),
2124 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2127 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2128 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2130 (SELECT player FROM players WHERE nick='Gogo'),
2132 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2138 (SELECT player FROM players WHERE nick='Gogo'),
2140 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2143 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2146 (SELECT player FROM players WHERE nick='Oliyzia'),
2149 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2150 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2152 (SELECT player FROM players WHERE nick='Oliyzia'),
2154 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2160 (SELECT player FROM players WHERE nick='Oliyzia'),
2162 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2165 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2168 (SELECT player FROM players WHERE nick='Oliyzia'),
2170 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2173 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2176 (SELECT player FROM players WHERE nick='RiChY'),
2179 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2182 (SELECT player FROM players WHERE nick='RiChY'),
2184 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2187 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2188 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2190 (SELECT player FROM players WHERE nick='RiChY'),
2192 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2195 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2196 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2198 (SELECT player FROM players WHERE nick='RiChY'),
2200 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2203 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2204 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2206 (SELECT player FROM players WHERE nick='Snute'),
2209 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2210 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2212 (SELECT player FROM players WHERE nick='Snute'),
2214 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2220 (SELECT player FROM players WHERE nick='Snute'),
2222 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
2225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2228 (SELECT player FROM players WHERE nick='Snute'),
2230 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2233 INSERT INTO groups (tournament, round, parallel) VALUES (
2234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2236 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2237 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2239 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2241 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2244 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
2246 UPDATE rounds SET randomsongs=2 WHERE
2247 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2249 UPDATE rounds SET chosensongs=1 WHERE
2250 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2255 (SELECT player FROM players WHERE nick='Felz'),
2258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2261 (SELECT player FROM players WHERE nick='Felz'),
2263 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2269 (SELECT player FROM players WHERE nick='Felz'),
2271 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2275 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2277 (SELECT player FROM players WHERE nick='Felz'),
2279 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2282 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2285 (SELECT player FROM players WHERE nick='Andeplane'),
2288 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2289 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2291 (SELECT player FROM players WHERE nick='Andeplane'),
2293 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2296 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2297 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2299 (SELECT player FROM players WHERE nick='Andeplane'),
2301 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2305 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2307 (SELECT player FROM players WHERE nick='Andeplane'),
2309 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2315 (SELECT player FROM players WHERE nick='Bonzo'),
2318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2321 (SELECT player FROM players WHERE nick='Bonzo'),
2323 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2329 (SELECT player FROM players WHERE nick='Bonzo'),
2331 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2337 (SELECT player FROM players WHERE nick='Bonzo'),
2339 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2342 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2345 (SELECT player FROM players WHERE nick='Daniil'),
2348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2349 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2351 (SELECT player FROM players WHERE nick='Daniil'),
2353 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2357 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2359 (SELECT player FROM players WHERE nick='Daniil'),
2361 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2364 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2365 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2367 (SELECT player FROM players WHERE nick='Daniil'),
2369 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2372 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2375 (SELECT player FROM players WHERE nick='Olemann'),
2378 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2381 (SELECT player FROM players WHERE nick='Olemann'),
2383 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2386 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2387 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2389 (SELECT player FROM players WHERE nick='Olemann'),
2391 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2397 (SELECT player FROM players WHERE nick='Olemann'),
2399 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2402 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2405 (SELECT player FROM players WHERE nick='Snofox'),
2408 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2409 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2411 (SELECT player FROM players WHERE nick='Snofox'),
2413 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2416 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2419 (SELECT player FROM players WHERE nick='Snofox'),
2421 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2424 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2427 (SELECT player FROM players WHERE nick='Snofox'),
2429 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2432 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2433 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2435 (SELECT player FROM players WHERE nick='Nameless'),
2438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2441 (SELECT player FROM players WHERE nick='Nameless'),
2443 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2446 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2447 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2449 (SELECT player FROM players WHERE nick='Nameless'),
2451 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2455 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2457 (SELECT player FROM players WHERE nick='Nameless'),
2459 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2462 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2467 INSERT INTO groups (tournament, round, parallel) VALUES (
2468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2470 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2473 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2475 UPDATE rounds SET randomsongs=1 WHERE
2476 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2478 UPDATE rounds SET chosensongs=1 WHERE
2479 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2481 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2482 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2484 (SELECT player FROM players WHERE nick='RiChY'),
2487 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2488 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2490 (SELECT player FROM players WHERE nick='RiChY'),
2492 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2495 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2498 (SELECT player FROM players WHERE nick='RiChY'),
2500 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2503 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2504 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2506 (SELECT player FROM players WHERE nick='Snofox'),
2509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2512 (SELECT player FROM players WHERE nick='Snofox'),
2514 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2517 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2520 (SELECT player FROM players WHERE nick='Snofox'),
2522 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2525 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2528 (SELECT player FROM players WHERE nick='Pingo'),
2531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2534 (SELECT player FROM players WHERE nick='Pingo'),
2536 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2542 (SELECT player FROM players WHERE nick='Pingo'),
2544 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2547 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2550 (SELECT player FROM players WHERE nick='OJK'),
2553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2556 (SELECT player FROM players WHERE nick='OJK'),
2558 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2564 (SELECT player FROM players WHERE nick='OJK'),
2566 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2569 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2570 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2572 (SELECT player FROM players WHERE nick='Oliyzia'),
2575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2576 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2578 (SELECT player FROM players WHERE nick='Oliyzia'),
2580 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2583 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2586 (SELECT player FROM players WHERE nick='Oliyzia'),
2588 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2591 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2592 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2594 (SELECT player FROM players WHERE nick='Bonzo'),
2597 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2600 (SELECT player FROM players WHERE nick='Bonzo'),
2602 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2605 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2606 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2608 (SELECT player FROM players WHERE nick='Bonzo'),
2610 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2613 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2614 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2616 (SELECT player FROM players WHERE nick='Snute'),
2619 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2620 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2622 (SELECT player FROM players WHERE nick='Snute'),
2624 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2628 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2630 (SELECT player FROM players WHERE nick='Snute'),
2632 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2635 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2638 (SELECT player FROM players WHERE nick='Nameless'),
2641 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2644 (SELECT player FROM players WHERE nick='Nameless'),
2646 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2649 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2650 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2652 (SELECT player FROM players WHERE nick='Nameless'),
2654 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2657 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2658 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2660 (SELECT player FROM players WHERE nick='Haggar'),
2663 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2664 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2666 (SELECT player FROM players WHERE nick='Haggar'),
2668 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2671 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2672 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2674 (SELECT player FROM players WHERE nick='Haggar'),
2676 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2679 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2684 INSERT INTO groups (tournament, round, parallel) VALUES (
2685 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2687 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2688 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2690 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
2692 UPDATE rounds SET randomsongs=1 WHERE
2693 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2695 UPDATE rounds SET chosensongs=1 WHERE
2696 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2698 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2699 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2701 (SELECT player FROM players WHERE nick='Nameless'),
2704 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2705 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2707 (SELECT player FROM players WHERE nick='Nameless'),
2709 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2712 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2713 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2715 (SELECT player FROM players WHERE nick='Nameless'),
2717 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2720 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2723 (SELECT player FROM players WHERE nick='RiChY'),
2726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2727 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2729 (SELECT player FROM players WHERE nick='RiChY'),
2731 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2734 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2735 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2737 (SELECT player FROM players WHERE nick='RiChY'),
2739 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2742 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2745 (SELECT player FROM players WHERE nick='Oliyzia'),
2748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2749 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2751 (SELECT player FROM players WHERE nick='Oliyzia'),
2753 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2757 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2759 (SELECT player FROM players WHERE nick='Oliyzia'),
2761 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2765 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2767 (SELECT player FROM players WHERE nick='Snofox'),
2770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2773 (SELECT player FROM players WHERE nick='Snofox'),
2775 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2779 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2781 (SELECT player FROM players WHERE nick='Snofox'),
2783 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2786 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2787 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2789 (SELECT player FROM players WHERE nick='Snute'),
2792 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2793 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2795 (SELECT player FROM players WHERE nick='Snute'),
2797 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2800 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2801 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2803 (SELECT player FROM players WHERE nick='Snute'),
2805 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2808 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2809 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2811 (SELECT player FROM players WHERE nick='Haggar'),
2814 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2815 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2817 (SELECT player FROM players WHERE nick='Haggar'),
2819 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2822 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2823 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2825 (SELECT player FROM players WHERE nick='Haggar'),
2827 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2830 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2831 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2833 (SELECT player FROM players WHERE nick='Bonzo'),
2836 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2837 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2839 (SELECT player FROM players WHERE nick='Bonzo'),
2841 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2845 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2847 (SELECT player FROM players WHERE nick='Bonzo'),
2849 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2852 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2854 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2857 INSERT INTO groups (tournament, round, parallel) VALUES (
2858 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2860 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2861 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2863 (SELECT song FROM songs WHERE lower(title)=lower('Remember You'))
2865 UPDATE rounds SET randomsongs=1 WHERE
2866 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2868 UPDATE rounds SET chosensongs=1 WHERE
2869 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2871 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2874 (SELECT player FROM players WHERE nick='Bonzo'),
2877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2880 (SELECT player FROM players WHERE nick='Bonzo'),
2882 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2885 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2888 (SELECT player FROM players WHERE nick='Bonzo'),
2890 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2893 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2896 (SELECT player FROM players WHERE nick='Nameless'),
2899 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2902 (SELECT player FROM players WHERE nick='Nameless'),
2904 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2907 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2908 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2910 (SELECT player FROM players WHERE nick='Nameless'),
2912 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2915 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2916 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2918 (SELECT player FROM players WHERE nick='Snofox'),
2921 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2922 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2924 (SELECT player FROM players WHERE nick='Snofox'),
2926 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2929 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2930 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2932 (SELECT player FROM players WHERE nick='Snofox'),
2934 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2937 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2938 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2940 (SELECT player FROM players WHERE nick='Haggar'),
2943 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2944 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2946 (SELECT player FROM players WHERE nick='Haggar'),
2948 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2951 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2952 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2954 (SELECT player FROM players WHERE nick='Haggar'),
2956 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2959 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2960 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2962 (SELECT player FROM players WHERE nick='Snute'),
2965 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2966 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2968 (SELECT player FROM players WHERE nick='Snute'),
2970 (SELECT song FROM songs WHERE lower(title)=lower('Remember You')),
2973 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2974 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2976 (SELECT player FROM players WHERE nick='Snute'),
2978 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2981 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2983 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2986 INSERT INTO groups (tournament, round, parallel) VALUES (
2987 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2989 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2990 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
2992 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
2994 UPDATE rounds SET randomsongs=1 WHERE
2995 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
2997 UPDATE rounds SET chosensongs=1 WHERE
2998 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3001 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3003 (SELECT player FROM players WHERE nick='Snofox'),
3006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3007 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3009 (SELECT player FROM players WHERE nick='Snofox'),
3011 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3017 (SELECT player FROM players WHERE nick='Snofox'),
3019 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
3022 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3025 (SELECT player FROM players WHERE nick='Haggar'),
3028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3029 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3031 (SELECT player FROM players WHERE nick='Haggar'),
3033 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3036 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3037 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3039 (SELECT player FROM players WHERE nick='Haggar'),
3041 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
3044 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3045 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3047 (SELECT player FROM players WHERE nick='Nameless'),
3050 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3053 (SELECT player FROM players WHERE nick='Nameless'),
3055 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3058 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3059 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3061 (SELECT player FROM players WHERE nick='Nameless'),
3063 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
3066 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3067 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3069 (SELECT player FROM players WHERE nick='Snute'),
3072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3073 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3075 (SELECT player FROM players WHERE nick='Snute'),
3077 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3081 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3083 (SELECT player FROM players WHERE nick='Snute'),
3085 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
3088 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
3090 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3093 INSERT INTO groups (tournament, round, parallel) VALUES (
3094 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3096 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3097 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3099 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
3101 UPDATE rounds SET randomsongs=1 WHERE
3102 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3104 UPDATE rounds SET chosensongs=1 WHERE
3105 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3107 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3110 (SELECT player FROM players WHERE nick='Nameless'),
3113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3116 (SELECT player FROM players WHERE nick='Nameless'),
3118 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
3121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3124 (SELECT player FROM players WHERE nick='Nameless'),
3126 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
3129 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3130 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3132 (SELECT player FROM players WHERE nick='Haggar'),
3135 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3136 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3138 (SELECT player FROM players WHERE nick='Haggar'),
3140 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
3143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3144 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3146 (SELECT player FROM players WHERE nick='Haggar'),
3148 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
3151 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3152 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3154 (SELECT player FROM players WHERE nick='Snute'),
3157 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3160 (SELECT player FROM players WHERE nick='Snute'),
3162 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
3165 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3168 (SELECT player FROM players WHERE nick='Snute'),
3170 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3173 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
3175 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3178 INSERT INTO groups (tournament, round, parallel) VALUES (
3179 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3181 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3184 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
3186 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3187 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3189 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
3191 UPDATE rounds SET randomsongs=2 WHERE
3192 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7') AND
3194 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3197 (SELECT player FROM players WHERE nick='Haggar'),
3200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3203 (SELECT player FROM players WHERE nick='Haggar'),
3205 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
3208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3211 (SELECT player FROM players WHERE nick='Haggar'),
3213 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
3216 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3219 (SELECT player FROM players WHERE nick='Snute'),
3222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3223 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3225 (SELECT player FROM players WHERE nick='Snute'),
3227 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
3230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3231 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'),
3233 (SELECT player FROM players WHERE nick='Snute'),
3235 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),