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 players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
58 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
59 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
61 (SELECT player FROM players WHERE nick='Th0rny'),
64 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
65 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
67 (SELECT player FROM players WHERE nick='Th0rny'),
68 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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('Make A Jam!')),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
79 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
80 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
82 (SELECT player FROM players WHERE nick='Glukko'),
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='Glukko'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
92 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
95 (SELECT player FROM players WHERE nick='Glukko'),
96 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
99 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
100 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
103 (SELECT player FROM players WHERE nick='Daniil'),
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='Daniil'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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='Daniil'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' 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='Snofox'),
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='Snofox'),
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='Snofox'),
138 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
141 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
142 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
145 (SELECT player FROM players WHERE nick='Snute'),
148 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
149 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
151 (SELECT player FROM players WHERE nick='Snute'),
152 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
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='Snute'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
162 INSERT INTO groups (tournament, round, parallel) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
165 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
166 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
168 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
170 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
173 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
175 UPDATE rounds SET randomsongs=2 WHERE
176 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
178 UPDATE rounds SET chosensongs=1 WHERE
179 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
181 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
185 (SELECT player FROM players WHERE nick='Glock'),
188 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
191 (SELECT player FROM players WHERE nick='Glock'),
192 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
195 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
196 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
198 (SELECT player FROM players WHERE nick='Glock'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
202 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
203 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
204 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
206 (SELECT player FROM players WHERE nick='Athena'),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
212 (SELECT player FROM players WHERE nick='Athena'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
219 (SELECT player FROM players WHERE nick='Athena'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' 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='Matsi'),
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='Matsi'),
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='Matsi'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
244 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
245 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
246 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
248 (SELECT player FROM players WHERE nick='Bonzo'),
251 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
254 (SELECT player FROM players WHERE nick='Bonzo'),
255 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
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='Bonzo'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
265 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
266 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
269 (SELECT player FROM players WHERE nick='Smiph'),
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='Smiph'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
279 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
282 (SELECT player FROM players WHERE nick='Smiph'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
286 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
287 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
290 (SELECT player FROM players WHERE nick='DufF'),
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='DufF'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
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='DufF'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
307 INSERT INTO groups (tournament, round, parallel) VALUES (
308 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
310 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
313 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
315 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
316 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
318 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
320 UPDATE rounds SET randomsongs=2 WHERE
321 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
323 UPDATE rounds SET chosensongs=1 WHERE
324 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
326 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
327 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
328 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
330 (SELECT player FROM players WHERE nick='Ifrit'),
333 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
334 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
336 (SELECT player FROM players WHERE nick='Ifrit'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
340 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
343 (SELECT player FROM players WHERE nick='Ifrit'),
344 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
347 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
348 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
351 (SELECT player FROM players WHERE nick='ViD'),
354 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
357 (SELECT player FROM players WHERE nick='ViD'),
358 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
364 (SELECT player FROM players WHERE nick='ViD'),
365 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
368 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
369 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
370 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
372 (SELECT player FROM players WHERE nick='Hyper'),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
378 (SELECT player FROM players WHERE nick='Hyper'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
382 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
383 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
385 (SELECT player FROM players WHERE nick='Hyper'),
386 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
389 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
390 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
393 (SELECT player FROM players WHERE nick='Andeplane'),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
399 (SELECT player FROM players WHERE nick='Andeplane'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
406 (SELECT player FROM players WHERE nick='Andeplane'),
407 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' 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='Gogo'),
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='Gogo'),
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='Gogo'),
428 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
431 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
432 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
433 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
435 (SELECT player FROM players WHERE nick='Duckling'),
438 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
441 (SELECT player FROM players WHERE nick='Duckling'),
442 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
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='Duckling'),
449 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
452 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
453 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
454 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
456 (SELECT player FROM players WHERE nick='OJK'),
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='OJK'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
466 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
467 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
469 (SELECT player FROM players WHERE nick='OJK'),
470 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
473 INSERT INTO groups (tournament, round, parallel) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
476 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
477 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
479 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
481 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
482 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
486 UPDATE rounds SET randomsongs=2 WHERE
487 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
489 UPDATE rounds SET chosensongs=1 WHERE
490 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
492 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
493 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
494 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
496 (SELECT player FROM players WHERE nick='Electron'),
499 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
502 (SELECT player FROM players WHERE nick='Electron'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
506 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
509 (SELECT player FROM players WHERE nick='Electron'),
510 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
514 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
517 (SELECT player FROM players WHERE nick='Guru'),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
523 (SELECT player FROM players WHERE nick='Guru'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
530 (SELECT player FROM players WHERE nick='Guru'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
534 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
538 (SELECT player FROM players WHERE nick='Annkakri'),
541 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
544 (SELECT player FROM players WHERE nick='Annkakri'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
551 (SELECT player FROM players WHERE nick='Annkakri'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
555 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
556 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
557 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
559 (SELECT player FROM players WHERE nick='Felz'),
562 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
565 (SELECT player FROM players WHERE nick='Felz'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
569 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
572 (SELECT player FROM players WHERE nick='Felz'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
576 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
577 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
580 (SELECT player FROM players WHERE nick='Draconia'),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
586 (SELECT player FROM players WHERE nick='Draconia'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
590 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
593 (SELECT player FROM players WHERE nick='Draconia'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
598 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
599 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
601 (SELECT player FROM players WHERE nick='Ylini'),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
607 (SELECT player FROM players WHERE nick='Ylini'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
614 (SELECT player FROM players WHERE nick='Ylini'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
618 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
619 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
620 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
622 (SELECT player FROM players WHERE nick='Haggar'),
625 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
626 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
628 (SELECT player FROM players WHERE nick='Haggar'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
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='Haggar'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
639 INSERT INTO groups (tournament, round, parallel) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
642 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
643 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
645 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!'))
647 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
648 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
650 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
652 UPDATE rounds SET randomsongs=2 WHERE
653 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
655 UPDATE rounds SET chosensongs=1 WHERE
656 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
658 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
659 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
660 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
662 (SELECT player FROM players WHERE nick='Goku'),
665 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
668 (SELECT player FROM players WHERE nick='Goku'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
672 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
673 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
675 (SELECT player FROM players WHERE nick='Goku'),
676 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
679 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
680 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
681 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
683 (SELECT player FROM players WHERE nick='Montana'),
686 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
687 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
689 (SELECT player FROM players WHERE nick='Montana'),
690 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
693 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
694 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
696 (SELECT player FROM players WHERE nick='Montana'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
700 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
701 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
702 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
704 (SELECT player FROM players WHERE nick='JonAnders'),
707 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
710 (SELECT player FROM players WHERE nick='JonAnders'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
714 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
717 (SELECT player FROM players WHERE nick='JonAnders'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
721 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
723 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
725 (SELECT player FROM players WHERE nick='Alexxz'),
728 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
731 (SELECT player FROM players WHERE nick='Alexxz'),
732 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
738 (SELECT player FROM players WHERE nick='Alexxz'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
742 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
743 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
744 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
746 (SELECT player FROM players WHERE nick='Pingo'),
749 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
752 (SELECT player FROM players WHERE nick='Pingo'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
756 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
759 (SELECT player FROM players WHERE nick='Pingo'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
763 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
765 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
767 (SELECT player FROM players WHERE nick='Nameless'),
770 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
773 (SELECT player FROM players WHERE nick='Nameless'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
777 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
780 (SELECT player FROM players WHERE nick='Nameless'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
785 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
786 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
788 (SELECT player FROM players WHERE nick='RiChY'),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
794 (SELECT player FROM players WHERE nick='RiChY'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
801 (SELECT player FROM players WHERE nick='RiChY'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
805 INSERT INTO groups (tournament, round, parallel) VALUES (
806 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
808 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
811 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
813 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
814 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
816 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
818 UPDATE rounds SET randomsongs=2 WHERE
819 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
821 UPDATE rounds SET chosensongs=1 WHERE
822 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
824 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
825 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
826 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
828 (SELECT player FROM players WHERE nick='Matti'),
831 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
832 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
834 (SELECT player FROM players WHERE nick='Matti'),
835 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
838 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
841 (SELECT player FROM players WHERE nick='Matti'),
842 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
845 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
846 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
847 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
849 (SELECT player FROM players WHERE nick='v|per'),
852 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
855 (SELECT player FROM players WHERE nick='v|per'),
856 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
859 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
860 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
862 (SELECT player FROM players WHERE nick='v|per'),
863 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
866 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
867 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
868 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
870 (SELECT player FROM players WHERE nick='Zackie'),
873 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
874 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
876 (SELECT player FROM players WHERE nick='Zackie'),
877 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
880 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
881 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
883 (SELECT player FROM players WHERE nick='Zackie'),
884 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
888 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
889 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
891 (SELECT player FROM players WHERE nick='Mync'),
894 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
897 (SELECT player FROM players WHERE nick='Mync'),
898 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
901 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
902 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
904 (SELECT player FROM players WHERE nick='Mync'),
905 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
908 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
909 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
910 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
912 (SELECT player FROM players WHERE nick='Ozon'),
915 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
916 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
918 (SELECT player FROM players WHERE nick='Ozon'),
919 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
925 (SELECT player FROM players WHERE nick='Ozon'),
926 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
929 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
930 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
931 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
933 (SELECT player FROM players WHERE nick='T|na'),
936 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
939 (SELECT player FROM players WHERE nick='T|na'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
943 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
944 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
946 (SELECT player FROM players WHERE nick='T|na'),
947 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
950 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
951 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
952 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
954 (SELECT player FROM players WHERE nick='Oliyzia'),
957 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
960 (SELECT player FROM players WHERE nick='Oliyzia'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
964 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
967 (SELECT player FROM players WHERE nick='Oliyzia'),
968 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
971 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
973 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
976 INSERT INTO groups (tournament, round, parallel) VALUES (
977 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
979 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
980 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
982 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
984 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
985 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
987 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
989 UPDATE rounds SET randomsongs=2 WHERE
990 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
992 UPDATE rounds SET chosensongs=1 WHERE
993 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
995 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
996 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
997 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
999 (SELECT player FROM players WHERE nick='Daniil'),
1002 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1005 (SELECT player FROM players WHERE nick='Daniil'),
1006 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1009 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1010 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1012 (SELECT player FROM players WHERE nick='Daniil'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1016 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
1017 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1018 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1020 (SELECT player FROM players WHERE nick='ViD'),
1023 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1024 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1026 (SELECT player FROM players WHERE nick='ViD'),
1027 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1030 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1031 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1033 (SELECT player FROM players WHERE nick='ViD'),
1034 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1037 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1038 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1039 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1041 (SELECT player FROM players WHERE nick='Ylini'),
1044 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1045 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1047 (SELECT player FROM players WHERE nick='Ylini'),
1048 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1051 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1054 (SELECT player FROM players WHERE nick='Ylini'),
1055 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1058 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1059 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1060 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1062 (SELECT player FROM players WHERE nick='Bonzo'),
1065 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1068 (SELECT player FROM players WHERE nick='Bonzo'),
1069 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1072 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1073 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1075 (SELECT player FROM players WHERE nick='Bonzo'),
1076 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1079 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1080 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1081 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1083 (SELECT player FROM players WHERE nick='Snute'),
1086 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1089 (SELECT player FROM players WHERE nick='Snute'),
1090 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1093 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1096 (SELECT player FROM players WHERE nick='Snute'),
1097 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1100 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1101 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1102 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1104 (SELECT player FROM players WHERE nick='Gogo'),
1107 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1110 (SELECT player FROM players WHERE nick='Gogo'),
1111 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1114 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1115 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1117 (SELECT player FROM players WHERE nick='Gogo'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1121 INSERT INTO groups (tournament, round, parallel) VALUES (
1122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1124 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1125 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1127 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1129 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1130 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
1134 UPDATE rounds SET randomsongs=2 WHERE
1135 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1137 UPDATE rounds SET chosensongs=1 WHERE
1138 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1140 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
1141 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1144 (SELECT player FROM players WHERE nick='Felz'),
1147 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1148 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1150 (SELECT player FROM players WHERE nick='Felz'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1154 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1155 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1157 (SELECT player FROM players WHERE nick='Felz'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1161 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
1162 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1165 (SELECT player FROM players WHERE nick='Mync'),
1168 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1169 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1171 (SELECT player FROM players WHERE nick='Mync'),
1172 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1175 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1178 (SELECT player FROM players WHERE nick='Mync'),
1179 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1182 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1183 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1186 (SELECT player FROM players WHERE nick='OJK'),
1189 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1190 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1192 (SELECT player FROM players WHERE nick='OJK'),
1193 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1196 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1199 (SELECT player FROM players WHERE nick='OJK'),
1200 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1203 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1204 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1205 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1207 (SELECT player FROM players WHERE nick='T|na'),
1210 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1211 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1213 (SELECT player FROM players WHERE nick='T|na'),
1214 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1217 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1218 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1220 (SELECT player FROM players WHERE nick='T|na'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1224 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1225 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1226 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1228 (SELECT player FROM players WHERE nick='DufF'),
1231 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1232 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1234 (SELECT player FROM players WHERE nick='DufF'),
1235 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1238 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1241 (SELECT player FROM players WHERE nick='DufF'),
1242 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1245 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1247 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1249 (SELECT player FROM players WHERE nick='Nameless'),
1252 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1255 (SELECT player FROM players WHERE nick='Nameless'),
1256 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1259 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1260 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1262 (SELECT player FROM players WHERE nick='Nameless'),
1263 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
1266 INSERT INTO groups (tournament, round, parallel) VALUES (
1267 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1269 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1272 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
1274 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1275 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1277 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1279 UPDATE rounds SET randomsongs=2 WHERE
1280 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1282 UPDATE rounds SET chosensongs=1 WHERE
1283 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1285 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
1286 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1289 (SELECT player FROM players WHERE nick='Smiph'),
1292 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1293 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1295 (SELECT player FROM players WHERE nick='Smiph'),
1296 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1299 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1300 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1302 (SELECT player FROM players WHERE nick='Smiph'),
1303 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1306 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1307 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1308 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1310 (SELECT player FROM players WHERE nick='RiChY'),
1313 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1314 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1316 (SELECT player FROM players WHERE nick='RiChY'),
1317 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1320 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1321 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1323 (SELECT player FROM players WHERE nick='RiChY'),
1324 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1327 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1328 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1331 (SELECT player FROM players WHERE nick='Snofox'),
1334 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1335 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1337 (SELECT player FROM players WHERE nick='Snofox'),
1338 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1341 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1344 (SELECT player FROM players WHERE nick='Snofox'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1348 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1349 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1352 (SELECT player FROM players WHERE nick='Pingo'),
1355 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1358 (SELECT player FROM players WHERE nick='Pingo'),
1359 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1362 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1363 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1365 (SELECT player FROM players WHERE nick='Pingo'),
1366 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1369 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1370 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1371 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1373 (SELECT player FROM players WHERE nick='Haggar'),
1376 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1377 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1379 (SELECT player FROM players WHERE nick='Haggar'),
1380 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1383 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1386 (SELECT player FROM players WHERE nick='Haggar'),
1387 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1390 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1392 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1394 (SELECT player FROM players WHERE nick='Oliyzia'),
1397 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1398 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1400 (SELECT player FROM players WHERE nick='Oliyzia'),
1401 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1404 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1405 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1407 (SELECT player FROM players WHERE nick='Oliyzia'),
1408 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1411 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1413 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1416 INSERT INTO groups (tournament, round, parallel) VALUES (
1417 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1419 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1420 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1422 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1424 UPDATE rounds SET randomsongs=1 WHERE
1425 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1427 UPDATE rounds SET chosensongs=1 WHERE
1428 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1430 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1431 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1434 (SELECT player FROM players WHERE nick='Nameless'),
1437 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1440 (SELECT player FROM players WHERE nick='Nameless'),
1441 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1444 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1448 (SELECT player FROM players WHERE nick='Oliyzia'),
1451 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1454 (SELECT player FROM players WHERE nick='Oliyzia'),
1455 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1458 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
1459 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1462 (SELECT player FROM players WHERE nick='Bonzo'),
1465 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1466 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1468 (SELECT player FROM players WHERE nick='Bonzo'),
1469 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1472 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1473 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1476 (SELECT player FROM players WHERE nick='Ylini'),
1479 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1480 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1482 (SELECT player FROM players WHERE nick='Ylini'),
1483 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1486 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1487 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1490 (SELECT player FROM players WHERE nick='OJK'),
1493 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1494 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1496 (SELECT player FROM players WHERE nick='OJK'),
1497 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1500 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1501 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1502 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1504 (SELECT player FROM players WHERE nick='Snofox'),
1507 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1508 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1510 (SELECT player FROM players WHERE nick='Snofox'),
1511 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1514 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1515 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1518 (SELECT player FROM players WHERE nick='DufF'),
1521 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1522 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1524 (SELECT player FROM players WHERE nick='DufF'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1528 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1529 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1530 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1532 (SELECT player FROM players WHERE nick='Snute'),
1535 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1536 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1538 (SELECT player FROM players WHERE nick='Snute'),
1539 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1542 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1543 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1544 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1546 (SELECT player FROM players WHERE nick='Haggar'),
1549 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1550 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1552 (SELECT player FROM players WHERE nick='Haggar'),
1553 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1556 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1558 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1561 INSERT INTO groups (tournament, round, parallel) VALUES (
1562 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1564 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1565 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1567 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
1569 UPDATE rounds SET randomsongs=1 WHERE
1570 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1572 UPDATE rounds SET chosensongs=1 WHERE
1573 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1575 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1576 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1577 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1579 (SELECT player FROM players WHERE nick='Nameless'),
1582 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1583 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1585 (SELECT player FROM players WHERE nick='Nameless'),
1586 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1589 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1593 (SELECT player FROM players WHERE nick='Oliyzia'),
1596 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1597 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1599 (SELECT player FROM players WHERE nick='Oliyzia'),
1600 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1603 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1604 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1607 (SELECT player FROM players WHERE nick='Haggar'),
1610 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1611 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1613 (SELECT player FROM players WHERE nick='Haggar'),
1614 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1617 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1618 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1619 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1621 (SELECT player FROM players WHERE nick='Snofox'),
1624 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1625 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1627 (SELECT player FROM players WHERE nick='Snofox'),
1628 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1631 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1635 (SELECT player FROM players WHERE nick='DufF'),
1638 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1639 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1641 (SELECT player FROM players WHERE nick='DufF'),
1642 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1645 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1649 (SELECT player FROM players WHERE nick='OJK'),
1652 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1653 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1655 (SELECT player FROM players WHERE nick='OJK'),
1656 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1659 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1660 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1663 (SELECT player FROM players WHERE nick='Snute'),
1666 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1669 (SELECT player FROM players WHERE nick='Snute'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
1673 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1678 INSERT INTO groups (tournament, round, parallel) VALUES (
1679 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1681 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1682 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1684 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1686 UPDATE rounds SET randomsongs=1 WHERE
1687 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1689 UPDATE rounds SET chosensongs=1 WHERE
1690 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1692 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1693 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1694 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1696 (SELECT player FROM players WHERE nick='Snofox'),
1699 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1700 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1702 (SELECT player FROM players WHERE nick='Snofox'),
1703 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1706 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1707 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1710 (SELECT player FROM players WHERE nick='DufF'),
1713 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1714 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1716 (SELECT player FROM players WHERE nick='DufF'),
1717 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1720 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1721 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1722 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1724 (SELECT player FROM players WHERE nick='OJK'),
1727 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1730 (SELECT player FROM players WHERE nick='OJK'),
1731 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1734 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1735 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1738 (SELECT player FROM players WHERE nick='Oliyzia'),
1741 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1742 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1744 (SELECT player FROM players WHERE nick='Oliyzia'),
1745 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1748 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1749 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1752 (SELECT player FROM players WHERE nick='Snute'),
1755 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1756 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1758 (SELECT player FROM players WHERE nick='Snute'),
1759 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1762 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1764 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1767 INSERT INTO groups (tournament, round, parallel) VALUES (
1768 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1770 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1773 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
1775 UPDATE rounds SET randomsongs=1 WHERE
1776 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1778 UPDATE rounds SET chosensongs=1 WHERE
1779 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1781 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1783 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1785 (SELECT player FROM players WHERE nick='OJK'),
1788 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1789 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1791 (SELECT player FROM players WHERE nick='OJK'),
1792 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1795 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1796 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1797 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1799 (SELECT player FROM players WHERE nick='Snofox'),
1802 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1803 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1805 (SELECT player FROM players WHERE nick='Snofox'),
1806 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1809 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1810 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1811 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1813 (SELECT player FROM players WHERE nick='DufF'),
1816 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1817 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1819 (SELECT player FROM players WHERE nick='DufF'),
1820 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1823 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1824 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1825 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1827 (SELECT player FROM players WHERE nick='Snute'),
1830 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1831 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1833 (SELECT player FROM players WHERE nick='Snute'),
1834 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1837 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1839 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1842 INSERT INTO groups (tournament, round, parallel) VALUES (
1843 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1845 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1846 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1848 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1850 UPDATE rounds SET randomsongs=1 WHERE
1851 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1853 UPDATE rounds SET chosensongs=1 WHERE
1854 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1856 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1857 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1858 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1860 (SELECT player FROM players WHERE nick='OJK'),
1863 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1864 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1866 (SELECT player FROM players WHERE nick='OJK'),
1867 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1870 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1871 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1872 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1874 (SELECT player FROM players WHERE nick='DufF'),
1877 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1878 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1880 (SELECT player FROM players WHERE nick='DufF'),
1881 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1884 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1885 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1886 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1888 (SELECT player FROM players WHERE nick='Snute'),
1891 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1892 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1894 (SELECT player FROM players WHERE nick='Snute'),
1895 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1898 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1900 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1903 INSERT INTO groups (tournament, round, parallel) VALUES (
1904 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1906 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1907 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1909 (SELECT song FROM songs WHERE lower(title)=lower('Destiny'))
1911 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1912 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1914 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
1916 UPDATE rounds SET randomsongs=2 WHERE
1917 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 6') AND
1919 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1921 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1923 (SELECT player FROM players WHERE nick='DufF'),
1926 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1927 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1929 (SELECT player FROM players WHERE nick='DufF'),
1930 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
1933 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1934 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1936 (SELECT player FROM players WHERE nick='DufF'),
1937 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1940 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1941 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1942 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1944 (SELECT player FROM players WHERE nick='Snute'),
1947 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1948 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1950 (SELECT player FROM players WHERE nick='Snute'),
1951 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
1954 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1955 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 6'),
1957 (SELECT player FROM players WHERE nick='Snute'),
1958 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),