2 INSERT INTO tournaments
3 (season, name, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE name='Norway'),
7 'Fredrikstad Mestern Bowling',
9 (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
12 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
14 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
28 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
37 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
38 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
40 (SELECT player FROM players WHERE nick='Pyro'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
46 (SELECT player FROM players WHERE nick='Pyro'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
53 (SELECT player FROM players WHERE nick='Pyro'),
54 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
57 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
60 (SELECT player FROM players WHERE nick='Pyro'),
61 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
64 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
65 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
66 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
68 (SELECT player FROM players WHERE nick='Th0rny'),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
74 (SELECT player FROM players WHERE nick='Th0rny'),
75 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
81 (SELECT player FROM players WHERE nick='Th0rny'),
82 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
88 (SELECT player FROM players WHERE nick='Th0rny'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
93 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
94 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
96 (SELECT player FROM players WHERE nick='Glukko'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
102 (SELECT player FROM players WHERE nick='Glukko'),
103 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
109 (SELECT player FROM players WHERE nick='Glukko'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
116 (SELECT player FROM players WHERE nick='Glukko'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
121 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
124 (SELECT player FROM players WHERE nick='Daniil'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
130 (SELECT player FROM players WHERE nick='Daniil'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
137 (SELECT player FROM players WHERE nick='Daniil'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
144 (SELECT player FROM players WHERE nick='Daniil'),
145 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
152 (SELECT player FROM players WHERE nick='Snofox'),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
158 (SELECT player FROM players WHERE nick='Snofox'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
165 (SELECT player FROM players WHERE nick='Snofox'),
166 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
172 (SELECT player FROM players WHERE nick='Snofox'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
176 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
177 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
180 (SELECT player FROM players WHERE nick='Snute'),
183 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
186 (SELECT player FROM players WHERE nick='Snute'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
190 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
191 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
193 (SELECT player FROM players WHERE nick='Snute'),
194 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
197 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
198 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
200 (SELECT player FROM players WHERE nick='Snute'),
201 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
204 INSERT INTO groups (tournament, round, parallel) VALUES (
205 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
207 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
208 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
210 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
212 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
213 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
215 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
217 UPDATE rounds SET randomsongs=2 WHERE
218 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
220 UPDATE rounds SET chosensongs=1 WHERE
221 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
227 (SELECT player FROM players WHERE nick='Glock'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
233 (SELECT player FROM players WHERE nick='Glock'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
240 (SELECT player FROM players WHERE nick='Glock'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
247 (SELECT player FROM players WHERE nick='Glock'),
248 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
255 (SELECT player FROM players WHERE nick='Athena'),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
261 (SELECT player FROM players WHERE nick='Athena'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
268 (SELECT player FROM players WHERE nick='Athena'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
275 (SELECT player FROM players WHERE nick='Athena'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
283 (SELECT player FROM players WHERE nick='Matsi'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
289 (SELECT player FROM players WHERE nick='Matsi'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
296 (SELECT player FROM players WHERE nick='Matsi'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
303 (SELECT player FROM players WHERE nick='Matsi'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
311 (SELECT player FROM players WHERE nick='Bonzo'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
317 (SELECT player FROM players WHERE nick='Bonzo'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
324 (SELECT player FROM players WHERE nick='Bonzo'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
331 (SELECT player FROM players WHERE nick='Bonzo'),
332 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
335 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
339 (SELECT player FROM players WHERE nick='Smiph'),
342 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
345 (SELECT player FROM players WHERE nick='Smiph'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
349 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
352 (SELECT player FROM players WHERE nick='Smiph'),
353 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
356 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
357 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
359 (SELECT player FROM players WHERE nick='Smiph'),
360 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
363 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
367 (SELECT player FROM players WHERE nick='DufF'),
370 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
373 (SELECT player FROM players WHERE nick='DufF'),
374 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
377 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
378 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
380 (SELECT player FROM players WHERE nick='DufF'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
384 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
387 (SELECT player FROM players WHERE nick='DufF'),
388 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
391 INSERT INTO groups (tournament, round, parallel) VALUES (
392 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
394 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
395 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
397 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
399 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
402 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
404 UPDATE rounds SET randomsongs=2 WHERE
405 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
407 UPDATE rounds SET chosensongs=1 WHERE
408 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
411 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
414 (SELECT player FROM players WHERE nick='Ifrit'),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
420 (SELECT player FROM players WHERE nick='Ifrit'),
421 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
427 (SELECT player FROM players WHERE nick='Ifrit'),
428 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
431 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
434 (SELECT player FROM players WHERE nick='Ifrit'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
439 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
440 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
442 (SELECT player FROM players WHERE nick='ViD'),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
448 (SELECT player FROM players WHERE nick='ViD'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
452 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
455 (SELECT player FROM players WHERE nick='ViD'),
456 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
459 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
462 (SELECT player FROM players WHERE nick='ViD'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
466 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
470 (SELECT player FROM players WHERE nick='Hyper'),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
476 (SELECT player FROM players WHERE nick='Hyper'),
477 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
483 (SELECT player FROM players WHERE nick='Hyper'),
484 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
490 (SELECT player FROM players WHERE nick='Hyper'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
494 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
498 (SELECT player FROM players WHERE nick='Andeplane'),
501 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
504 (SELECT player FROM players WHERE nick='Andeplane'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
508 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
511 (SELECT player FROM players WHERE nick='Andeplane'),
512 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
515 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
518 (SELECT player FROM players WHERE nick='Andeplane'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
522 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
526 (SELECT player FROM players WHERE nick='Gogo'),
529 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
532 (SELECT player FROM players WHERE nick='Gogo'),
533 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
536 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
537 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
539 (SELECT player FROM players WHERE nick='Gogo'),
540 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
543 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
544 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
546 (SELECT player FROM players WHERE nick='Gogo'),
547 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
550 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
551 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
554 (SELECT player FROM players WHERE nick='Duckling'),
557 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
560 (SELECT player FROM players WHERE nick='Duckling'),
561 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
564 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
565 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
567 (SELECT player FROM players WHERE nick='Duckling'),
568 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
571 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
574 (SELECT player FROM players WHERE nick='Duckling'),
575 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
578 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
579 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
580 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
582 (SELECT player FROM players WHERE nick='OJK'),
585 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
586 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
588 (SELECT player FROM players WHERE nick='OJK'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
592 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
593 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
595 (SELECT player FROM players WHERE nick='OJK'),
596 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
599 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
600 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
602 (SELECT player FROM players WHERE nick='OJK'),
603 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
606 INSERT INTO groups (tournament, round, parallel) VALUES (
607 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
609 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
612 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
614 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
615 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
617 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
619 UPDATE rounds SET randomsongs=2 WHERE
620 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
622 UPDATE rounds SET chosensongs=1 WHERE
623 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
625 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
626 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
629 (SELECT player FROM players WHERE nick='Electron'),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
635 (SELECT player FROM players WHERE nick='Electron'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
639 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
642 (SELECT player FROM players WHERE nick='Electron'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
646 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
649 (SELECT player FROM players WHERE nick='Electron'),
650 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
653 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
654 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
657 (SELECT player FROM players WHERE nick='Guru'),
660 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
663 (SELECT player FROM players WHERE nick='Guru'),
664 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
667 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
668 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
670 (SELECT player FROM players WHERE nick='Guru'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
674 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
677 (SELECT player FROM players WHERE nick='Guru'),
678 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
685 (SELECT player FROM players WHERE nick='Annkakri'),
688 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
691 (SELECT player FROM players WHERE nick='Annkakri'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
695 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
698 (SELECT player FROM players WHERE nick='Annkakri'),
699 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
702 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
703 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
705 (SELECT player FROM players WHERE nick='Annkakri'),
706 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
709 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
710 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
711 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
713 (SELECT player FROM players WHERE nick='Felz'),
716 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
717 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
719 (SELECT player FROM players WHERE nick='Felz'),
720 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
723 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
726 (SELECT player FROM players WHERE nick='Felz'),
727 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
730 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
731 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
733 (SELECT player FROM players WHERE nick='Felz'),
734 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
737 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
738 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
741 (SELECT player FROM players WHERE nick='Draconia'),
744 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
747 (SELECT player FROM players WHERE nick='Draconia'),
748 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
751 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
754 (SELECT player FROM players WHERE nick='Draconia'),
755 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
758 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
759 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
761 (SELECT player FROM players WHERE nick='Draconia'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
765 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
766 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
769 (SELECT player FROM players WHERE nick='Ylini'),
772 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
773 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
775 (SELECT player FROM players WHERE nick='Ylini'),
776 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
779 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
782 (SELECT player FROM players WHERE nick='Ylini'),
783 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
786 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
787 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
789 (SELECT player FROM players WHERE nick='Ylini'),
790 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
793 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
797 (SELECT player FROM players WHERE nick='Haggar'),
800 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
801 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
803 (SELECT player FROM players WHERE nick='Haggar'),
804 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
807 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
808 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
810 (SELECT player FROM players WHERE nick='Haggar'),
811 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
814 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
815 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
817 (SELECT player FROM players WHERE nick='Haggar'),
818 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
821 INSERT INTO groups (tournament, round, parallel) VALUES (
822 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
824 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
825 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
827 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
829 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
830 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
834 UPDATE rounds SET randomsongs=2 WHERE
835 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
837 UPDATE rounds SET chosensongs=1 WHERE
838 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
840 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
841 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
842 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
844 (SELECT player FROM players WHERE nick='Goku'),
847 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
850 (SELECT player FROM players WHERE nick='Goku'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
854 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
855 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
857 (SELECT player FROM players WHERE nick='Goku'),
858 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
861 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
862 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
864 (SELECT player FROM players WHERE nick='Goku'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
868 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
869 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
872 (SELECT player FROM players WHERE nick='Montana'),
875 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
876 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
878 (SELECT player FROM players WHERE nick='Montana'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
882 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
885 (SELECT player FROM players WHERE nick='Montana'),
886 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
889 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
890 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
892 (SELECT player FROM players WHERE nick='Montana'),
893 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
896 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
897 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
900 (SELECT player FROM players WHERE nick='JonAnders'),
903 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
904 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
906 (SELECT player FROM players WHERE nick='JonAnders'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
910 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
913 (SELECT player FROM players WHERE nick='JonAnders'),
914 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
917 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
918 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
920 (SELECT player FROM players WHERE nick='JonAnders'),
921 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
924 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
925 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
928 (SELECT player FROM players WHERE nick='Alexxz'),
931 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
932 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
934 (SELECT player FROM players WHERE nick='Alexxz'),
935 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
938 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
939 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
941 (SELECT player FROM players WHERE nick='Alexxz'),
942 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
945 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
946 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
948 (SELECT player FROM players WHERE nick='Alexxz'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
952 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
953 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
954 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
956 (SELECT player FROM players WHERE nick='Pingo'),
959 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
960 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
962 (SELECT player FROM players WHERE nick='Pingo'),
963 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
966 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
969 (SELECT player FROM players WHERE nick='Pingo'),
970 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
973 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
974 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
976 (SELECT player FROM players WHERE nick='Pingo'),
977 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
980 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
981 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
982 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
984 (SELECT player FROM players WHERE nick='Nameless'),
987 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
988 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
990 (SELECT player FROM players WHERE nick='Nameless'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
994 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
997 (SELECT player FROM players WHERE nick='Nameless'),
998 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1001 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1002 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1004 (SELECT player FROM players WHERE nick='Nameless'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1008 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1009 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1010 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1012 (SELECT player FROM players WHERE nick='RiChY'),
1015 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1016 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1018 (SELECT player FROM players WHERE nick='RiChY'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
1022 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1023 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1025 (SELECT player FROM players WHERE nick='RiChY'),
1026 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1029 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1030 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1032 (SELECT player FROM players WHERE nick='RiChY'),
1033 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1036 INSERT INTO groups (tournament, round, parallel) VALUES (
1037 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1039 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1040 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1044 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1045 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1049 UPDATE rounds SET randomsongs=2 WHERE
1050 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1052 UPDATE rounds SET chosensongs=1 WHERE
1053 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1055 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
1056 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1059 (SELECT player FROM players WHERE nick='Matti'),
1062 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1063 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1065 (SELECT player FROM players WHERE nick='Matti'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1069 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1070 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1072 (SELECT player FROM players WHERE nick='Matti'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1076 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1079 (SELECT player FROM players WHERE nick='Matti'),
1080 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1083 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
1084 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1087 (SELECT player FROM players WHERE nick='v|per'),
1090 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1091 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1093 (SELECT player FROM players WHERE nick='v|per'),
1094 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1097 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1098 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1100 (SELECT player FROM players WHERE nick='v|per'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1104 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1107 (SELECT player FROM players WHERE nick='v|per'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1111 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
1112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1115 (SELECT player FROM players WHERE nick='Zackie'),
1118 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1121 (SELECT player FROM players WHERE nick='Zackie'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1125 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1128 (SELECT player FROM players WHERE nick='Zackie'),
1129 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1132 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1133 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1135 (SELECT player FROM players WHERE nick='Zackie'),
1136 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1139 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1140 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1141 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1143 (SELECT player FROM players WHERE nick='Mync'),
1146 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1149 (SELECT player FROM players WHERE nick='Mync'),
1150 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1153 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1156 (SELECT player FROM players WHERE nick='Mync'),
1157 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1160 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1161 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1163 (SELECT player FROM players WHERE nick='Mync'),
1164 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1167 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1171 (SELECT player FROM players WHERE nick='Ozon'),
1174 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1175 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1177 (SELECT player FROM players WHERE nick='Ozon'),
1178 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1181 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1184 (SELECT player FROM players WHERE nick='Ozon'),
1185 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1191 (SELECT player FROM players WHERE nick='Ozon'),
1192 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1195 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1199 (SELECT player FROM players WHERE nick='T|na'),
1202 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1205 (SELECT player FROM players WHERE nick='T|na'),
1206 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1212 (SELECT player FROM players WHERE nick='T|na'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1219 (SELECT player FROM players WHERE nick='T|na'),
1220 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1227 (SELECT player FROM players WHERE nick='Oliyzia'),
1230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1233 (SELECT player FROM players WHERE nick='Oliyzia'),
1234 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1240 (SELECT player FROM players WHERE nick='Oliyzia'),
1241 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1247 (SELECT player FROM players WHERE nick='Oliyzia'),
1248 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1251 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1256 INSERT INTO groups (tournament, round, parallel) VALUES (
1257 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1259 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1260 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1262 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
1264 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1265 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1267 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1269 UPDATE rounds SET randomsongs=2 WHERE
1270 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1272 UPDATE rounds SET chosensongs=1 WHERE
1273 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1275 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1277 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1279 (SELECT player FROM players WHERE nick='Daniil'),
1282 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1283 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1285 (SELECT player FROM players WHERE nick='Daniil'),
1286 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1289 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1290 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1292 (SELECT player FROM players WHERE nick='Daniil'),
1293 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1296 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1297 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1299 (SELECT player FROM players WHERE nick='Daniil'),
1300 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
1304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1307 (SELECT player FROM players WHERE nick='ViD'),
1310 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1313 (SELECT player FROM players WHERE nick='ViD'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1317 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1320 (SELECT player FROM players WHERE nick='ViD'),
1321 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1324 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1325 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1327 (SELECT player FROM players WHERE nick='ViD'),
1328 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1331 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1332 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1333 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1335 (SELECT player FROM players WHERE nick='Ylini'),
1338 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1339 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1341 (SELECT player FROM players WHERE nick='Ylini'),
1342 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1345 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1346 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1348 (SELECT player FROM players WHERE nick='Ylini'),
1349 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1352 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1353 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1355 (SELECT player FROM players WHERE nick='Ylini'),
1356 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1359 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1360 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1361 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1363 (SELECT player FROM players WHERE nick='Bonzo'),
1366 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1367 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1369 (SELECT player FROM players WHERE nick='Bonzo'),
1370 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1373 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1374 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1376 (SELECT player FROM players WHERE nick='Bonzo'),
1377 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1380 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1381 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1383 (SELECT player FROM players WHERE nick='Bonzo'),
1384 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1387 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1388 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1389 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1391 (SELECT player FROM players WHERE nick='Snute'),
1394 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1395 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1397 (SELECT player FROM players WHERE nick='Snute'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1401 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1402 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1404 (SELECT player FROM players WHERE nick='Snute'),
1405 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1408 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1409 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1411 (SELECT player FROM players WHERE nick='Snute'),
1412 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1415 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1416 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1417 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1419 (SELECT player FROM players WHERE nick='Gogo'),
1422 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1423 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1425 (SELECT player FROM players WHERE nick='Gogo'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1429 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1430 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1432 (SELECT player FROM players WHERE nick='Gogo'),
1433 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1436 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1437 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1439 (SELECT player FROM players WHERE nick='Gogo'),
1440 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1443 INSERT INTO groups (tournament, round, parallel) VALUES (
1444 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1446 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1447 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1449 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1451 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1454 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
1456 UPDATE rounds SET randomsongs=2 WHERE
1457 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1459 UPDATE rounds SET chosensongs=1 WHERE
1460 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1462 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
1463 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1464 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1466 (SELECT player FROM players WHERE nick='Felz'),
1469 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1470 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1472 (SELECT player FROM players WHERE nick='Felz'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1476 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1477 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1479 (SELECT player FROM players WHERE nick='Felz'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1483 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1486 (SELECT player FROM players WHERE nick='Felz'),
1487 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1490 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1491 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1494 (SELECT player FROM players WHERE nick='Mync'),
1497 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1498 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1500 (SELECT player FROM players WHERE nick='Mync'),
1501 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1504 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1505 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1507 (SELECT player FROM players WHERE nick='Mync'),
1508 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1511 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1512 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1514 (SELECT player FROM players WHERE nick='Mync'),
1515 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1518 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1519 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1520 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1522 (SELECT player FROM players WHERE nick='OJK'),
1525 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1526 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1528 (SELECT player FROM players WHERE nick='OJK'),
1529 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1532 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1535 (SELECT player FROM players WHERE nick='OJK'),
1536 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1539 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1542 (SELECT player FROM players WHERE nick='OJK'),
1543 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1546 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1547 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1548 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1550 (SELECT player FROM players WHERE nick='T|na'),
1553 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1556 (SELECT player FROM players WHERE nick='T|na'),
1557 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1560 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1561 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1563 (SELECT player FROM players WHERE nick='T|na'),
1564 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1567 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1570 (SELECT player FROM players WHERE nick='T|na'),
1571 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1574 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1575 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1576 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1578 (SELECT player FROM players WHERE nick='DufF'),
1581 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1584 (SELECT player FROM players WHERE nick='DufF'),
1585 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1588 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1589 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1591 (SELECT player FROM players WHERE nick='DufF'),
1592 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1595 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1596 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1598 (SELECT player FROM players WHERE nick='DufF'),
1599 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
1602 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1603 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1604 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1606 (SELECT player FROM players WHERE nick='Nameless'),
1609 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1610 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1612 (SELECT player FROM players WHERE nick='Nameless'),
1613 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1616 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1617 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1619 (SELECT player FROM players WHERE nick='Nameless'),
1620 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1623 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1624 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1626 (SELECT player FROM players WHERE nick='Nameless'),
1627 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1630 INSERT INTO groups (tournament, round, parallel) VALUES (
1631 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1633 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1634 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1636 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
1638 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1641 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1643 UPDATE rounds SET randomsongs=2 WHERE
1644 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1646 UPDATE rounds SET chosensongs=1 WHERE
1647 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1649 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1650 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1651 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1653 (SELECT player FROM players WHERE nick='Smiph'),
1656 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1657 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1659 (SELECT player FROM players WHERE nick='Smiph'),
1660 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1663 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1664 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1666 (SELECT player FROM players WHERE nick='Smiph'),
1667 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1670 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1671 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1673 (SELECT player FROM players WHERE nick='Smiph'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1677 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1678 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1679 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1681 (SELECT player FROM players WHERE nick='RiChY'),
1684 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1685 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1687 (SELECT player FROM players WHERE nick='RiChY'),
1688 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1691 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1692 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1694 (SELECT player FROM players WHERE nick='RiChY'),
1695 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1698 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1699 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1701 (SELECT player FROM players WHERE nick='RiChY'),
1702 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1705 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1706 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1707 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1709 (SELECT player FROM players WHERE nick='Snofox'),
1712 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1713 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1715 (SELECT player FROM players WHERE nick='Snofox'),
1716 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1719 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1722 (SELECT player FROM players WHERE nick='Snofox'),
1723 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1726 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1727 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1729 (SELECT player FROM players WHERE nick='Snofox'),
1730 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1733 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1735 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1737 (SELECT player FROM players WHERE nick='Pingo'),
1740 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1741 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1743 (SELECT player FROM players WHERE nick='Pingo'),
1744 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1747 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1750 (SELECT player FROM players WHERE nick='Pingo'),
1751 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1754 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1755 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1757 (SELECT player FROM players WHERE nick='Pingo'),
1758 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1761 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1762 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1763 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1765 (SELECT player FROM players WHERE nick='Haggar'),
1768 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1769 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1771 (SELECT player FROM players WHERE nick='Haggar'),
1772 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1775 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1778 (SELECT player FROM players WHERE nick='Haggar'),
1779 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1782 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1783 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1785 (SELECT player FROM players WHERE nick='Haggar'),
1786 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1789 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1790 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1791 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1793 (SELECT player FROM players WHERE nick='Oliyzia'),
1796 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1799 (SELECT player FROM players WHERE nick='Oliyzia'),
1800 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1803 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1804 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1806 (SELECT player FROM players WHERE nick='Oliyzia'),
1807 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1810 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1811 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1813 (SELECT player FROM players WHERE nick='Oliyzia'),
1814 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1817 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1819 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1822 INSERT INTO groups (tournament, round, parallel) VALUES (
1823 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1825 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1828 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1830 UPDATE rounds SET randomsongs=1 WHERE
1831 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1833 UPDATE rounds SET chosensongs=1 WHERE
1834 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1836 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1837 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1838 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1840 (SELECT player FROM players WHERE nick='Nameless'),
1843 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1844 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1846 (SELECT player FROM players WHERE nick='Nameless'),
1847 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1850 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1851 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1853 (SELECT player FROM players WHERE nick='Nameless'),
1854 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1857 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1858 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1859 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1861 (SELECT player FROM players WHERE nick='Oliyzia'),
1864 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1865 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1867 (SELECT player FROM players WHERE nick='Oliyzia'),
1868 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1871 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1872 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1874 (SELECT player FROM players WHERE nick='Oliyzia'),
1875 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1878 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1879 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1880 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1882 (SELECT player FROM players WHERE nick='Bonzo'),
1885 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1886 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1888 (SELECT player FROM players WHERE nick='Bonzo'),
1889 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1892 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1893 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1895 (SELECT player FROM players WHERE nick='Bonzo'),
1896 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1899 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1900 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1901 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1903 (SELECT player FROM players WHERE nick='Ylini'),
1906 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1907 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1909 (SELECT player FROM players WHERE nick='Ylini'),
1910 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1913 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1914 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1916 (SELECT player FROM players WHERE nick='Ylini'),
1917 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1920 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1921 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1922 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1924 (SELECT player FROM players WHERE nick='OJK'),
1927 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1928 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1930 (SELECT player FROM players WHERE nick='OJK'),
1931 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1934 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1935 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1937 (SELECT player FROM players WHERE nick='OJK'),
1938 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1941 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1942 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1943 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1945 (SELECT player FROM players WHERE nick='Snofox'),
1948 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1949 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1951 (SELECT player FROM players WHERE nick='Snofox'),
1952 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1955 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1956 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1958 (SELECT player FROM players WHERE nick='Snofox'),
1959 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1962 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1963 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1964 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1966 (SELECT player FROM players WHERE nick='DufF'),
1969 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1970 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1972 (SELECT player FROM players WHERE nick='DufF'),
1973 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1976 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1977 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1979 (SELECT player FROM players WHERE nick='DufF'),
1980 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1983 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1984 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1985 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1987 (SELECT player FROM players WHERE nick='Snute'),
1990 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1991 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1993 (SELECT player FROM players WHERE nick='Snute'),
1994 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1997 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1998 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2000 (SELECT player FROM players WHERE nick='Snute'),
2001 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2004 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2005 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2006 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2008 (SELECT player FROM players WHERE nick='Haggar'),
2011 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2012 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2014 (SELECT player FROM players WHERE nick='Haggar'),
2015 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2018 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2019 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2021 (SELECT player FROM players WHERE nick='Haggar'),
2022 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2025 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2027 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2030 INSERT INTO groups (tournament, round, parallel) VALUES (
2031 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2033 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2034 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2036 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
2038 UPDATE rounds SET randomsongs=1 WHERE
2039 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2041 UPDATE rounds SET chosensongs=1 WHERE
2042 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2044 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2045 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2046 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2048 (SELECT player FROM players WHERE nick='Nameless'),
2051 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2052 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2054 (SELECT player FROM players WHERE nick='Nameless'),
2055 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2058 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2059 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2061 (SELECT player FROM players WHERE nick='Nameless'),
2062 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2065 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2066 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2067 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2069 (SELECT player FROM players WHERE nick='Oliyzia'),
2072 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2073 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2075 (SELECT player FROM players WHERE nick='Oliyzia'),
2076 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2079 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2080 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2082 (SELECT player FROM players WHERE nick='Oliyzia'),
2083 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2086 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2087 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2088 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2090 (SELECT player FROM players WHERE nick='Haggar'),
2093 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2096 (SELECT player FROM players WHERE nick='Haggar'),
2097 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2100 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2103 (SELECT player FROM players WHERE nick='Haggar'),
2104 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2107 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2109 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2111 (SELECT player FROM players WHERE nick='Snofox'),
2114 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2115 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2117 (SELECT player FROM players WHERE nick='Snofox'),
2118 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2121 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2124 (SELECT player FROM players WHERE nick='Snofox'),
2125 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2128 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2129 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2130 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2132 (SELECT player FROM players WHERE nick='DufF'),
2135 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2136 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2138 (SELECT player FROM players WHERE nick='DufF'),
2139 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2142 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2145 (SELECT player FROM players WHERE nick='DufF'),
2146 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2149 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2150 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2151 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2153 (SELECT player FROM players WHERE nick='OJK'),
2156 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2157 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2159 (SELECT player FROM players WHERE nick='OJK'),
2160 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2163 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2164 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2166 (SELECT player FROM players WHERE nick='OJK'),
2167 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2170 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2171 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2172 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2174 (SELECT player FROM players WHERE nick='Snute'),
2177 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2180 (SELECT player FROM players WHERE nick='Snute'),
2181 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
2184 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2187 (SELECT player FROM players WHERE nick='Snute'),
2188 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2191 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2193 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2196 INSERT INTO groups (tournament, round, parallel) VALUES (
2197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2199 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2200 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2202 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2204 UPDATE rounds SET randomsongs=1 WHERE
2205 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2207 UPDATE rounds SET chosensongs=1 WHERE
2208 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2212 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2214 (SELECT player FROM players WHERE nick='Snofox'),
2217 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2218 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2220 (SELECT player FROM players WHERE nick='Snofox'),
2221 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2224 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2227 (SELECT player FROM players WHERE nick='Snofox'),
2228 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2231 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2232 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2233 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2235 (SELECT player FROM players WHERE nick='DufF'),
2238 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2239 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2241 (SELECT player FROM players WHERE nick='DufF'),
2242 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2245 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2246 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2248 (SELECT player FROM players WHERE nick='DufF'),
2249 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2252 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2253 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2254 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2256 (SELECT player FROM players WHERE nick='OJK'),
2259 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2260 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2262 (SELECT player FROM players WHERE nick='OJK'),
2263 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2266 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2269 (SELECT player FROM players WHERE nick='OJK'),
2270 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2273 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
2274 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2275 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2277 (SELECT player FROM players WHERE nick='Oliyzia'),
2280 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2283 (SELECT player FROM players WHERE nick='Oliyzia'),
2284 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2287 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2290 (SELECT player FROM players WHERE nick='Oliyzia'),
2291 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2294 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2296 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2298 (SELECT player FROM players WHERE nick='Snute'),
2301 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2302 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2304 (SELECT player FROM players WHERE nick='Snute'),
2305 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2308 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2311 (SELECT player FROM players WHERE nick='Snute'),
2312 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2315 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2317 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2320 INSERT INTO groups (tournament, round, parallel) VALUES (
2321 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2323 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2324 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2326 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
2328 UPDATE rounds SET randomsongs=1 WHERE
2329 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2331 UPDATE rounds SET chosensongs=1 WHERE
2332 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2338 (SELECT player FROM players WHERE nick='OJK'),
2341 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2344 (SELECT player FROM players WHERE nick='OJK'),
2345 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2348 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2351 (SELECT player FROM players WHERE nick='OJK'),
2352 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2355 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2356 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2357 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2359 (SELECT player FROM players WHERE nick='Snofox'),
2362 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2363 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2365 (SELECT player FROM players WHERE nick='Snofox'),
2366 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2369 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2370 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2372 (SELECT player FROM players WHERE nick='Snofox'),
2373 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2376 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2377 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2378 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2380 (SELECT player FROM players WHERE nick='DufF'),
2383 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2386 (SELECT player FROM players WHERE nick='DufF'),
2387 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2390 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2393 (SELECT player FROM players WHERE nick='DufF'),
2394 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2397 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2398 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2399 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2401 (SELECT player FROM players WHERE nick='Snute'),
2404 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2405 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2407 (SELECT player FROM players WHERE nick='Snute'),
2408 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
2411 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2412 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2414 (SELECT player FROM players WHERE nick='Snute'),
2415 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2418 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2420 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2423 INSERT INTO groups (tournament, round, parallel) VALUES (
2424 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2426 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2427 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2429 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
2431 UPDATE rounds SET randomsongs=1 WHERE
2432 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2434 UPDATE rounds SET chosensongs=1 WHERE
2435 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2437 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2438 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2441 (SELECT player FROM players WHERE nick='OJK'),
2444 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2445 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2447 (SELECT player FROM players WHERE nick='OJK'),
2448 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2451 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2454 (SELECT player FROM players WHERE nick='OJK'),
2455 (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
2458 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2459 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2462 (SELECT player FROM players WHERE nick='DufF'),
2465 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2466 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2468 (SELECT player FROM players WHERE nick='DufF'),
2469 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2472 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2473 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2475 (SELECT player FROM players WHERE nick='DufF'),
2476 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2479 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2480 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2483 (SELECT player FROM players WHERE nick='Snute'),
2486 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2487 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2489 (SELECT player FROM players WHERE nick='Snute'),
2490 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
2493 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2494 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2496 (SELECT player FROM players WHERE nick='Snute'),
2497 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2500 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2505 INSERT INTO groups (tournament, round, parallel) VALUES (
2506 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2508 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2511 (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
2513 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2514 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2516 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
2518 UPDATE rounds SET randomsongs=2 WHERE
2519 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
2521 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2522 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2523 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2525 (SELECT player FROM players WHERE nick='DufF'),
2528 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2529 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2531 (SELECT player FROM players WHERE nick='DufF'),
2532 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
2535 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2538 (SELECT player FROM players WHERE nick='DufF'),
2539 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2542 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2543 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2544 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2546 (SELECT player FROM players WHERE nick='Snute'),
2549 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2550 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2552 (SELECT player FROM players WHERE nick='Snute'),
2553 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
2556 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2557 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
2559 (SELECT player FROM players WHERE nick='Snute'),
2560 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),