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 'Fredrikstad Mestern 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 tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
57 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
58 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
60 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
61 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
63 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
66 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
69 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
70 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
72 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
75 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
76 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
78 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
79 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
81 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
82 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
84 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
85 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
87 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
88 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
90 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
93 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
96 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
99 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
102 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
105 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
108 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
111 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
112 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
114 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
117 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
118 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
120 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
121 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
123 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
126 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
127 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
128 39, 'JonAnders', 17);
129 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
130 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
132 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
137 INSERT INTO groups (tournament, round, parallel) VALUES (
138 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
140 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
141 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
143 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
145 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
148 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
150 UPDATE rounds SET randomsongs=2 WHERE
151 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
153 UPDATE rounds SET chosensongs=1 WHERE
154 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
157 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
160 (SELECT player FROM players WHERE nick='Pyro'),
163 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
166 (SELECT player FROM players WHERE nick='Pyro'),
168 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
171 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
172 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
174 (SELECT player FROM players WHERE nick='Pyro'),
176 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
179 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
182 (SELECT player FROM players WHERE nick='Pyro'),
184 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
187 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
188 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
191 (SELECT player FROM players WHERE nick='Th0rny'),
194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
197 (SELECT player FROM players WHERE nick='Th0rny'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
205 (SELECT player FROM players WHERE nick='Th0rny'),
207 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
210 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
211 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
213 (SELECT player FROM players WHERE nick='Th0rny'),
215 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
218 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
219 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
220 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
222 (SELECT player FROM players WHERE nick='Glukko'),
225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
228 (SELECT player FROM players WHERE nick='Glukko'),
230 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
234 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
236 (SELECT player FROM players WHERE nick='Glukko'),
238 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
241 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
242 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
244 (SELECT player FROM players WHERE nick='Glukko'),
246 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
249 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
250 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
253 (SELECT player FROM players WHERE nick='Daniil'),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
259 (SELECT player FROM players WHERE nick='Daniil'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
267 (SELECT player FROM players WHERE nick='Daniil'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
272 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
275 (SELECT player FROM players WHERE nick='Daniil'),
277 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
280 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
281 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
284 (SELECT player FROM players WHERE nick='Snofox'),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
290 (SELECT player FROM players WHERE nick='Snofox'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
298 (SELECT player FROM players WHERE nick='Snofox'),
300 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
303 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
304 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
306 (SELECT player FROM players WHERE nick='Snofox'),
308 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
311 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
315 (SELECT player FROM players WHERE nick='Snute'),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
321 (SELECT player FROM players WHERE nick='Snute'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
329 (SELECT player FROM players WHERE nick='Snute'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
335 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
337 (SELECT player FROM players WHERE nick='Snute'),
339 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
342 INSERT INTO groups (tournament, round, parallel) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
345 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
346 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
348 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
350 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
353 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
355 UPDATE rounds SET randomsongs=2 WHERE
356 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
358 UPDATE rounds SET chosensongs=1 WHERE
359 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
361 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
362 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
365 (SELECT player FROM players WHERE nick='Glock'),
368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
371 (SELECT player FROM players WHERE nick='Glock'),
373 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
379 (SELECT player FROM players WHERE nick='Glock'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
387 (SELECT player FROM players WHERE nick='Glock'),
389 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
392 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
393 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
396 (SELECT player FROM players WHERE nick='Athena'),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
402 (SELECT player FROM players WHERE nick='Athena'),
404 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
410 (SELECT player FROM players WHERE nick='Athena'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
418 (SELECT player FROM players WHERE nick='Athena'),
420 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
423 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
424 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
427 (SELECT player FROM players WHERE nick='Matsi'),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
433 (SELECT player FROM players WHERE nick='Matsi'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
441 (SELECT player FROM players WHERE nick='Matsi'),
443 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
446 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
447 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
449 (SELECT player FROM players WHERE nick='Matsi'),
451 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
454 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
455 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
458 (SELECT player FROM players WHERE nick='Bonzo'),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
464 (SELECT player FROM players WHERE nick='Bonzo'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
472 (SELECT player FROM players WHERE nick='Bonzo'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
477 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
478 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
480 (SELECT player FROM players WHERE nick='Bonzo'),
482 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
485 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
486 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
489 (SELECT player FROM players WHERE nick='Smiph'),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
495 (SELECT player FROM players WHERE nick='Smiph'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
503 (SELECT player FROM players WHERE nick='Smiph'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
511 (SELECT player FROM players WHERE nick='Smiph'),
513 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
516 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
517 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
518 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
520 (SELECT player FROM players WHERE nick='DufF'),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
526 (SELECT player FROM players WHERE nick='DufF'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
534 (SELECT player FROM players WHERE nick='DufF'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
540 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
542 (SELECT player FROM players WHERE nick='DufF'),
544 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
547 INSERT INTO groups (tournament, round, parallel) VALUES (
548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
550 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
553 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
555 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
556 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
558 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
560 UPDATE rounds SET randomsongs=2 WHERE
561 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
563 UPDATE rounds SET chosensongs=1 WHERE
564 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
566 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
570 (SELECT player FROM players WHERE nick='Ifrit'),
573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
576 (SELECT player FROM players WHERE nick='Ifrit'),
578 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
582 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
584 (SELECT player FROM players WHERE nick='Ifrit'),
586 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
589 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
590 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
592 (SELECT player FROM players WHERE nick='Ifrit'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
601 (SELECT player FROM players WHERE nick='ViD'),
604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
607 (SELECT player FROM players WHERE nick='ViD'),
609 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
612 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
613 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
615 (SELECT player FROM players WHERE nick='ViD'),
617 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
620 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
623 (SELECT player FROM players WHERE nick='ViD'),
625 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
628 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
629 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
632 (SELECT player FROM players WHERE nick='Hyper'),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
638 (SELECT player FROM players WHERE nick='Hyper'),
640 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
646 (SELECT player FROM players WHERE nick='Hyper'),
648 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
651 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
652 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
654 (SELECT player FROM players WHERE nick='Hyper'),
656 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
659 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
660 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
663 (SELECT player FROM players WHERE nick='Andeplane'),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
669 (SELECT player FROM players WHERE nick='Andeplane'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
677 (SELECT player FROM players WHERE nick='Andeplane'),
679 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
682 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
683 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
685 (SELECT player FROM players WHERE nick='Andeplane'),
687 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
690 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
691 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
692 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
694 (SELECT player FROM players WHERE nick='Gogo'),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
700 (SELECT player FROM players WHERE nick='Gogo'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
705 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
708 (SELECT player FROM players WHERE nick='Gogo'),
710 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
713 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
714 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
716 (SELECT player FROM players WHERE nick='Gogo'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
725 (SELECT player FROM players WHERE nick='Duckling'),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
731 (SELECT player FROM players WHERE nick='Duckling'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
739 (SELECT player FROM players WHERE nick='Duckling'),
741 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
744 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
745 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
747 (SELECT player FROM players WHERE nick='Duckling'),
749 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
752 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
753 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
756 (SELECT player FROM players WHERE nick='OJK'),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
762 (SELECT player FROM players WHERE nick='OJK'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
770 (SELECT player FROM players WHERE nick='OJK'),
772 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
778 (SELECT player FROM players WHERE nick='OJK'),
780 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
783 INSERT INTO groups (tournament, round, parallel) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
786 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
787 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
789 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
791 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
792 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
794 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
796 UPDATE rounds SET randomsongs=2 WHERE
797 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
799 UPDATE rounds SET chosensongs=1 WHERE
800 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
802 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
803 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
804 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
806 (SELECT player FROM players WHERE nick='Electron'),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
812 (SELECT player FROM players WHERE nick='Electron'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
820 (SELECT player FROM players WHERE nick='Electron'),
822 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
825 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
826 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
828 (SELECT player FROM players WHERE nick='Electron'),
830 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
833 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
834 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
837 (SELECT player FROM players WHERE nick='Guru'),
840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
843 (SELECT player FROM players WHERE nick='Guru'),
845 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
851 (SELECT player FROM players WHERE nick='Guru'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
857 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
859 (SELECT player FROM players WHERE nick='Guru'),
861 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
864 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
865 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
866 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
868 (SELECT player FROM players WHERE nick='Annkakri'),
871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
872 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
874 (SELECT player FROM players WHERE nick='Annkakri'),
876 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
880 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
882 (SELECT player FROM players WHERE nick='Annkakri'),
884 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
887 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
888 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
890 (SELECT player FROM players WHERE nick='Annkakri'),
892 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
895 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
896 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
897 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
899 (SELECT player FROM players WHERE nick='Felz'),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
905 (SELECT player FROM players WHERE nick='Felz'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
913 (SELECT player FROM players WHERE nick='Felz'),
915 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
918 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
921 (SELECT player FROM players WHERE nick='Felz'),
923 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
926 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
927 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
928 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
930 (SELECT player FROM players WHERE nick='Draconia'),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
936 (SELECT player FROM players WHERE nick='Draconia'),
938 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
942 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
944 (SELECT player FROM players WHERE nick='Draconia'),
946 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
949 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
950 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
952 (SELECT player FROM players WHERE nick='Draconia'),
954 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
957 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
958 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
961 (SELECT player FROM players WHERE nick='Ylini'),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
967 (SELECT player FROM players WHERE nick='Ylini'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
975 (SELECT player FROM players WHERE nick='Ylini'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
980 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
983 (SELECT player FROM players WHERE nick='Ylini'),
985 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
988 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
989 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
990 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
992 (SELECT player FROM players WHERE nick='Haggar'),
995 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
996 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
998 (SELECT player FROM players WHERE nick='Haggar'),
1000 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1003 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1004 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1006 (SELECT player FROM players WHERE nick='Haggar'),
1008 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1011 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1012 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1014 (SELECT player FROM players WHERE nick='Haggar'),
1016 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1019 INSERT INTO groups (tournament, round, parallel) VALUES (
1020 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1022 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1025 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
1027 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1028 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1030 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1032 UPDATE rounds SET randomsongs=2 WHERE
1033 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1035 UPDATE rounds SET chosensongs=1 WHERE
1036 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1038 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
1039 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1040 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1042 (SELECT player FROM players WHERE nick='Goku'),
1045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1048 (SELECT player FROM players WHERE nick='Goku'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1053 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1054 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1056 (SELECT player FROM players WHERE nick='Goku'),
1058 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1061 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1062 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1064 (SELECT player FROM players WHERE nick='Goku'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1069 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
1070 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1071 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1073 (SELECT player FROM players WHERE nick='Montana'),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1079 (SELECT player FROM players WHERE nick='Montana'),
1081 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1084 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1087 (SELECT player FROM players WHERE nick='Montana'),
1089 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1092 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1093 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1095 (SELECT player FROM players WHERE nick='Montana'),
1097 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1100 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
1101 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1102 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1104 (SELECT player FROM players WHERE nick='JonAnders'),
1107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1110 (SELECT player FROM players WHERE nick='JonAnders'),
1112 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1115 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1116 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1118 (SELECT player FROM players WHERE nick='JonAnders'),
1120 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1123 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1124 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1126 (SELECT player FROM players WHERE nick='JonAnders'),
1128 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1131 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
1132 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1133 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1135 (SELECT player FROM players WHERE nick='Alexxz'),
1138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1141 (SELECT player FROM players WHERE nick='Alexxz'),
1143 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1149 (SELECT player FROM players WHERE nick='Alexxz'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1154 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1155 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1157 (SELECT player FROM players WHERE nick='Alexxz'),
1159 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1163 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1164 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1166 (SELECT player FROM players WHERE nick='Pingo'),
1169 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1170 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1172 (SELECT player FROM players WHERE nick='Pingo'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1180 (SELECT player FROM players WHERE nick='Pingo'),
1182 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1186 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1188 (SELECT player FROM players WHERE nick='Pingo'),
1190 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1193 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1194 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1197 (SELECT player FROM players WHERE nick='Nameless'),
1200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1203 (SELECT player FROM players WHERE nick='Nameless'),
1205 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1211 (SELECT player FROM players WHERE nick='Nameless'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1219 (SELECT player FROM players WHERE nick='Nameless'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1224 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1225 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1228 (SELECT player FROM players WHERE nick='RiChY'),
1231 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1234 (SELECT player FROM players WHERE nick='RiChY'),
1236 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1239 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1240 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1242 (SELECT player FROM players WHERE nick='RiChY'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1250 (SELECT player FROM players WHERE nick='RiChY'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1255 INSERT INTO groups (tournament, round, parallel) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1258 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1261 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1263 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1266 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1268 UPDATE rounds SET randomsongs=2 WHERE
1269 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1271 UPDATE rounds SET chosensongs=1 WHERE
1272 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1274 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
1275 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1276 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1278 (SELECT player FROM players WHERE nick='Matti'),
1281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1282 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1284 (SELECT player FROM players WHERE nick='Matti'),
1286 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1289 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1290 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1292 (SELECT player FROM players WHERE nick='Matti'),
1294 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1297 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1298 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1300 (SELECT player FROM players WHERE nick='Matti'),
1302 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1305 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1309 (SELECT player FROM players WHERE nick='v|per'),
1312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1315 (SELECT player FROM players WHERE nick='v|per'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1321 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1323 (SELECT player FROM players WHERE nick='v|per'),
1325 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1331 (SELECT player FROM players WHERE nick='v|per'),
1333 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1336 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
1337 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1338 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1340 (SELECT player FROM players WHERE nick='Zackie'),
1343 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1346 (SELECT player FROM players WHERE nick='Zackie'),
1348 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1354 (SELECT player FROM players WHERE nick='Zackie'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1359 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1362 (SELECT player FROM players WHERE nick='Zackie'),
1364 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1367 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1368 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1371 (SELECT player FROM players WHERE nick='Mync'),
1374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1377 (SELECT player FROM players WHERE nick='Mync'),
1379 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1382 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1383 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1385 (SELECT player FROM players WHERE nick='Mync'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1390 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1391 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1393 (SELECT player FROM players WHERE nick='Mync'),
1395 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1398 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1399 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1400 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1402 (SELECT player FROM players WHERE nick='Ozon'),
1405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1408 (SELECT player FROM players WHERE nick='Ozon'),
1410 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1413 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1416 (SELECT player FROM players WHERE nick='Ozon'),
1418 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1424 (SELECT player FROM players WHERE nick='Ozon'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1429 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1430 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1431 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1433 (SELECT player FROM players WHERE nick='T|na'),
1436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1437 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1439 (SELECT player FROM players WHERE nick='T|na'),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1445 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1447 (SELECT player FROM players WHERE nick='T|na'),
1449 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1453 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1455 (SELECT player FROM players WHERE nick='T|na'),
1457 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1460 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1461 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1462 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1464 (SELECT player FROM players WHERE nick='Oliyzia'),
1467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1470 (SELECT player FROM players WHERE nick='Oliyzia'),
1472 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1478 (SELECT player FROM players WHERE nick='Oliyzia'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1486 (SELECT player FROM players WHERE nick='Oliyzia'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1491 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1493 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1496 INSERT INTO groups (tournament, round, parallel) VALUES (
1497 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1499 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1500 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1502 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
1504 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1505 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1507 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1509 UPDATE rounds SET randomsongs=2 WHERE
1510 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1512 UPDATE rounds SET chosensongs=1 WHERE
1513 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1515 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1516 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1519 (SELECT player FROM players WHERE nick='Daniil'),
1522 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1523 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1525 (SELECT player FROM players WHERE nick='Daniil'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1531 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1533 (SELECT player FROM players WHERE nick='Daniil'),
1535 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1539 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1541 (SELECT player FROM players WHERE nick='Daniil'),
1543 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1546 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
1547 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1548 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1550 (SELECT player FROM players WHERE nick='ViD'),
1553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1556 (SELECT player FROM players WHERE nick='ViD'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1562 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1564 (SELECT player FROM players WHERE nick='ViD'),
1566 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1569 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1570 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1572 (SELECT player FROM players WHERE nick='ViD'),
1574 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1577 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1579 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1581 (SELECT player FROM players WHERE nick='Ylini'),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1587 (SELECT player FROM players WHERE nick='Ylini'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1595 (SELECT player FROM players WHERE nick='Ylini'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1601 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1603 (SELECT player FROM players WHERE nick='Ylini'),
1605 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1608 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1609 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1610 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1612 (SELECT player FROM players WHERE nick='Bonzo'),
1615 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1616 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1618 (SELECT player FROM players WHERE nick='Bonzo'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1623 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1626 (SELECT player FROM players WHERE nick='Bonzo'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1631 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1632 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1634 (SELECT player FROM players WHERE nick='Bonzo'),
1636 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1639 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1640 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1641 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1643 (SELECT player FROM players WHERE nick='Snute'),
1646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1649 (SELECT player FROM players WHERE nick='Snute'),
1651 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1654 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1657 (SELECT player FROM players WHERE nick='Snute'),
1659 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1662 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1663 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1665 (SELECT player FROM players WHERE nick='Snute'),
1667 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1670 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1671 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1672 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1674 (SELECT player FROM players WHERE nick='Gogo'),
1677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1680 (SELECT player FROM players WHERE nick='Gogo'),
1682 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1688 (SELECT player FROM players WHERE nick='Gogo'),
1690 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1693 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1694 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1696 (SELECT player FROM players WHERE nick='Gogo'),
1698 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1701 INSERT INTO groups (tournament, round, parallel) VALUES (
1702 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1704 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1705 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1707 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1709 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1710 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1712 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
1714 UPDATE rounds SET randomsongs=2 WHERE
1715 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1717 UPDATE rounds SET chosensongs=1 WHERE
1718 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1720 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
1721 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1722 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1724 (SELECT player FROM players WHERE nick='Felz'),
1727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1730 (SELECT player FROM players WHERE nick='Felz'),
1732 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1735 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1736 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1738 (SELECT player FROM players WHERE nick='Felz'),
1740 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1743 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1744 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1746 (SELECT player FROM players WHERE nick='Felz'),
1748 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1751 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1752 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1753 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1755 (SELECT player FROM players WHERE nick='Mync'),
1758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1761 (SELECT player FROM players WHERE nick='Mync'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1769 (SELECT player FROM players WHERE nick='Mync'),
1771 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1774 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1775 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1777 (SELECT player FROM players WHERE nick='Mync'),
1779 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1782 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1786 (SELECT player FROM players WHERE nick='OJK'),
1789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1790 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1792 (SELECT player FROM players WHERE nick='OJK'),
1794 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1798 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1800 (SELECT player FROM players WHERE nick='OJK'),
1802 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1808 (SELECT player FROM players WHERE nick='OJK'),
1810 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1813 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1814 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1815 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1817 (SELECT player FROM players WHERE nick='T|na'),
1820 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1821 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1823 (SELECT player FROM players WHERE nick='T|na'),
1825 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1828 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1829 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1831 (SELECT player FROM players WHERE nick='T|na'),
1833 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1836 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1837 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1839 (SELECT player FROM players WHERE nick='T|na'),
1841 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1844 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1845 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1846 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1848 (SELECT player FROM players WHERE nick='DufF'),
1851 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1854 (SELECT player FROM players WHERE nick='DufF'),
1856 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1859 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1860 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1862 (SELECT player FROM players WHERE nick='DufF'),
1864 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1867 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1868 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1870 (SELECT player FROM players WHERE nick='DufF'),
1872 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1875 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1876 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1877 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1879 (SELECT player FROM players WHERE nick='Nameless'),
1882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1883 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1885 (SELECT player FROM players WHERE nick='Nameless'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1891 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1893 (SELECT player FROM players WHERE nick='Nameless'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1899 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1901 (SELECT player FROM players WHERE nick='Nameless'),
1903 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1906 INSERT INTO groups (tournament, round, parallel) VALUES (
1907 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1909 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1910 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1912 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
1914 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1915 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1917 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1919 UPDATE rounds SET randomsongs=2 WHERE
1920 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1922 UPDATE rounds SET chosensongs=1 WHERE
1923 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
1925 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1926 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1927 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1929 (SELECT player FROM players WHERE nick='Smiph'),
1932 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1933 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1935 (SELECT player FROM players WHERE nick='Smiph'),
1937 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1940 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1941 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1943 (SELECT player FROM players WHERE nick='Smiph'),
1945 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1949 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1951 (SELECT player FROM players WHERE nick='Smiph'),
1953 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1956 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1957 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1958 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1960 (SELECT player FROM players WHERE nick='RiChY'),
1963 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1964 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1966 (SELECT player FROM players WHERE nick='RiChY'),
1968 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1971 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1972 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1974 (SELECT player FROM players WHERE nick='RiChY'),
1976 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1979 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1980 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1982 (SELECT player FROM players WHERE nick='RiChY'),
1984 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1987 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1988 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1989 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1991 (SELECT player FROM players WHERE nick='Snofox'),
1994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1995 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
1997 (SELECT player FROM players WHERE nick='Snofox'),
1999 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2003 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2005 (SELECT player FROM players WHERE nick='Snofox'),
2007 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2010 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2011 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2013 (SELECT player FROM players WHERE nick='Snofox'),
2015 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2018 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
2019 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2020 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2022 (SELECT player FROM players WHERE nick='Pingo'),
2025 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2026 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2028 (SELECT player FROM players WHERE nick='Pingo'),
2030 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2034 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2036 (SELECT player FROM players WHERE nick='Pingo'),
2038 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2041 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2042 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2044 (SELECT player FROM players WHERE nick='Pingo'),
2046 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2049 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2050 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2051 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2053 (SELECT player FROM players WHERE nick='Haggar'),
2056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2059 (SELECT player FROM players WHERE nick='Haggar'),
2061 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2064 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2065 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2067 (SELECT player FROM players WHERE nick='Haggar'),
2069 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2073 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2075 (SELECT player FROM players WHERE nick='Haggar'),
2077 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2080 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2081 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2082 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2084 (SELECT player FROM players WHERE nick='Oliyzia'),
2087 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2088 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2090 (SELECT player FROM players WHERE nick='Oliyzia'),
2092 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2096 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2098 (SELECT player FROM players WHERE nick='Oliyzia'),
2100 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2104 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2106 (SELECT player FROM players WHERE nick='Oliyzia'),
2108 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2111 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2113 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2116 INSERT INTO groups (tournament, round, parallel) VALUES (
2117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2119 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2122 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
2124 UPDATE rounds SET randomsongs=1 WHERE
2125 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2127 UPDATE rounds SET chosensongs=1 WHERE
2128 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2130 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2131 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2132 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2134 (SELECT player FROM players WHERE nick='Nameless'),
2137 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2138 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2140 (SELECT player FROM players WHERE nick='Nameless'),
2142 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2145 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2146 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2148 (SELECT player FROM players WHERE nick='Nameless'),
2150 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2153 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2154 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2155 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2157 (SELECT player FROM players WHERE nick='Oliyzia'),
2160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2161 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2163 (SELECT player FROM players WHERE nick='Oliyzia'),
2165 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2168 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2169 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2171 (SELECT player FROM players WHERE nick='Oliyzia'),
2173 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2176 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
2177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2178 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2180 (SELECT player FROM players WHERE nick='Bonzo'),
2183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2186 (SELECT player FROM players WHERE nick='Bonzo'),
2188 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2191 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2192 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2194 (SELECT player FROM players WHERE nick='Bonzo'),
2196 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2199 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
2200 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2201 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2203 (SELECT player FROM players WHERE nick='Ylini'),
2206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2209 (SELECT player FROM players WHERE nick='Ylini'),
2211 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2217 (SELECT player FROM players WHERE nick='Ylini'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2226 (SELECT player FROM players WHERE nick='OJK'),
2229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2232 (SELECT player FROM players WHERE nick='OJK'),
2234 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2240 (SELECT player FROM players WHERE nick='OJK'),
2242 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2245 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2247 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2249 (SELECT player FROM players WHERE nick='Snofox'),
2252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2253 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2255 (SELECT player FROM players WHERE nick='Snofox'),
2257 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2263 (SELECT player FROM players WHERE nick='Snofox'),
2265 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2268 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2269 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2270 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2272 (SELECT player FROM players WHERE nick='DufF'),
2275 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2276 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2278 (SELECT player FROM players WHERE nick='DufF'),
2280 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2283 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2284 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2286 (SELECT player FROM players WHERE nick='DufF'),
2288 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2291 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2292 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2295 (SELECT player FROM players WHERE nick='Snute'),
2298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2301 (SELECT player FROM players WHERE nick='Snute'),
2303 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2307 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2309 (SELECT player FROM players WHERE nick='Snute'),
2311 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2314 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2315 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2316 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2318 (SELECT player FROM players WHERE nick='Haggar'),
2321 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2322 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2324 (SELECT player FROM players WHERE nick='Haggar'),
2326 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2329 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2330 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2332 (SELECT player FROM players WHERE nick='Haggar'),
2334 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2337 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2339 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2342 INSERT INTO groups (tournament, round, parallel) VALUES (
2343 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2345 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2346 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2348 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
2350 UPDATE rounds SET randomsongs=1 WHERE
2351 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2353 UPDATE rounds SET chosensongs=1 WHERE
2354 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2356 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2357 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2358 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2360 (SELECT player FROM players WHERE nick='Nameless'),
2363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2366 (SELECT player FROM players WHERE nick='Nameless'),
2368 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2374 (SELECT player FROM players WHERE nick='Nameless'),
2376 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2379 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2380 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2381 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2383 (SELECT player FROM players WHERE nick='Oliyzia'),
2386 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2387 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2389 (SELECT player FROM players WHERE nick='Oliyzia'),
2391 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2397 (SELECT player FROM players WHERE nick='Oliyzia'),
2399 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2402 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2406 (SELECT player FROM players WHERE nick='Haggar'),
2409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2412 (SELECT player FROM players WHERE nick='Haggar'),
2414 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2420 (SELECT player FROM players WHERE nick='Haggar'),
2422 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2425 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2426 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2427 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2429 (SELECT player FROM players WHERE nick='Snofox'),
2432 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2433 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2435 (SELECT player FROM players WHERE nick='Snofox'),
2437 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2443 (SELECT player FROM players WHERE nick='Snofox'),
2445 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2448 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2449 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2450 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2452 (SELECT player FROM players WHERE nick='DufF'),
2455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2458 (SELECT player FROM players WHERE nick='DufF'),
2460 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2466 (SELECT player FROM players WHERE nick='DufF'),
2468 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2471 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2472 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2473 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2475 (SELECT player FROM players WHERE nick='OJK'),
2478 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2479 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2481 (SELECT player FROM players WHERE nick='OJK'),
2483 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2486 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2487 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2489 (SELECT player FROM players WHERE nick='OJK'),
2491 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2496 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2498 (SELECT player FROM players WHERE nick='Snute'),
2501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2502 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2504 (SELECT player FROM players WHERE nick='Snute'),
2506 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2510 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2512 (SELECT player FROM players WHERE nick='Snute'),
2514 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2517 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2519 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2522 INSERT INTO groups (tournament, round, parallel) VALUES (
2523 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2525 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2528 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2530 UPDATE rounds SET randomsongs=1 WHERE
2531 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2533 UPDATE rounds SET chosensongs=1 WHERE
2534 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2536 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2537 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2540 (SELECT player FROM players WHERE nick='Snofox'),
2543 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2544 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2546 (SELECT player FROM players WHERE nick='Snofox'),
2548 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2551 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2554 (SELECT player FROM players WHERE nick='Snofox'),
2556 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2559 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2560 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2563 (SELECT player FROM players WHERE nick='DufF'),
2566 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2567 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2569 (SELECT player FROM players WHERE nick='DufF'),
2571 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2574 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2575 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2577 (SELECT player FROM players WHERE nick='DufF'),
2579 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2582 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2583 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2586 (SELECT player FROM players WHERE nick='OJK'),
2589 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2590 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2592 (SELECT player FROM players WHERE nick='OJK'),
2594 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2597 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2598 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2600 (SELECT player FROM players WHERE nick='OJK'),
2602 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2605 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2606 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2607 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2609 (SELECT player FROM players WHERE nick='Oliyzia'),
2612 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2613 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2615 (SELECT player FROM players WHERE nick='Oliyzia'),
2617 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2620 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2623 (SELECT player FROM players WHERE nick='Oliyzia'),
2625 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2628 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2629 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2632 (SELECT player FROM players WHERE nick='Snute'),
2635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2636 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2638 (SELECT player FROM players WHERE nick='Snute'),
2640 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2644 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2646 (SELECT player FROM players WHERE nick='Snute'),
2648 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2651 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2656 INSERT INTO groups (tournament, round, parallel) VALUES (
2657 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2659 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2660 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2662 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
2664 UPDATE rounds SET randomsongs=1 WHERE
2665 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2667 UPDATE rounds SET chosensongs=1 WHERE
2668 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2670 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2671 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2672 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2674 (SELECT player FROM players WHERE nick='OJK'),
2677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2678 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2680 (SELECT player FROM players WHERE nick='OJK'),
2682 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2686 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2688 (SELECT player FROM players WHERE nick='OJK'),
2690 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2693 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2694 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2697 (SELECT player FROM players WHERE nick='Snofox'),
2700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2701 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2703 (SELECT player FROM players WHERE nick='Snofox'),
2705 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2709 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2711 (SELECT player FROM players WHERE nick='Snofox'),
2713 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2716 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2717 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2718 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2720 (SELECT player FROM players WHERE nick='DufF'),
2723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2724 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2726 (SELECT player FROM players WHERE nick='DufF'),
2728 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2732 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2734 (SELECT player FROM players WHERE nick='DufF'),
2736 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2739 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2740 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2741 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2743 (SELECT player FROM players WHERE nick='Snute'),
2746 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2747 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2749 (SELECT player FROM players WHERE nick='Snute'),
2751 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2754 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2755 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2757 (SELECT player FROM players WHERE nick='Snute'),
2759 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2762 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2764 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2767 INSERT INTO groups (tournament, round, parallel) VALUES (
2768 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2770 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2771 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2773 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2775 UPDATE rounds SET randomsongs=1 WHERE
2776 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2778 UPDATE rounds SET chosensongs=1 WHERE
2779 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2781 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2785 (SELECT player FROM players WHERE nick='OJK'),
2788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2791 (SELECT player FROM players WHERE nick='OJK'),
2793 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2797 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2799 (SELECT player FROM players WHERE nick='OJK'),
2801 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2804 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2805 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2806 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2808 (SELECT player FROM players WHERE nick='DufF'),
2811 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2812 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2814 (SELECT player FROM players WHERE nick='DufF'),
2816 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2822 (SELECT player FROM players WHERE nick='DufF'),
2824 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2827 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2828 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2829 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2831 (SELECT player FROM players WHERE nick='Snute'),
2834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2835 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2837 (SELECT player FROM players WHERE nick='Snute'),
2839 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2842 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2843 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2845 (SELECT player FROM players WHERE nick='Snute'),
2847 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2850 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2855 INSERT INTO groups (tournament, round, parallel) VALUES (
2856 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2858 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2859 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2861 (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
2863 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2866 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2868 UPDATE rounds SET randomsongs=2 WHERE
2869 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND
2871 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2872 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2873 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2875 (SELECT player FROM players WHERE nick='DufF'),
2878 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2879 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2881 (SELECT player FROM players WHERE nick='DufF'),
2883 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
2886 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2887 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2889 (SELECT player FROM players WHERE nick='DufF'),
2891 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2894 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2895 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2896 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2898 (SELECT player FROM players WHERE nick='Snute'),
2901 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2902 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2904 (SELECT player FROM players WHERE nick='Snute'),
2906 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
2909 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2910 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
2912 (SELECT player FROM players WHERE nick='Snute'),
2914 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),