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'),
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 4'),
17 INSERT INTO groups (tournament, round, parallel) VALUES (
18 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
20 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
21 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
23 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
25 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
26 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
28 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
30 UPDATE rounds SET randomsongs=2 WHERE
31 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
33 UPDATE rounds SET chosensongs=1 WHERE
34 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' 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 4'),
40 (SELECT player FROM players WHERE nick='Pål Andre'),
43 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
46 (SELECT player FROM players WHERE nick='Pål Andre'),
47 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
50 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
51 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
53 (SELECT player FROM players WHERE nick='Pål Andre'),
54 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
57 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
58 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
60 (SELECT player FROM players WHERE nick='Pål Andre'),
61 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
64 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' 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 4'),
68 (SELECT player FROM players WHERE nick='Tassen'),
71 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
72 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
74 (SELECT player FROM players WHERE nick='Tassen'),
75 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
78 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
79 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
81 (SELECT player FROM players WHERE nick='Tassen'),
82 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
85 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
86 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
88 (SELECT player FROM players WHERE nick='Tassen'),
89 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
92 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' 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 4'),
96 (SELECT player FROM players WHERE nick='Haggar'),
99 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
102 (SELECT player FROM players WHERE nick='Haggar'),
103 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
106 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
109 (SELECT player FROM players WHERE nick='Haggar'),
110 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
113 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
116 (SELECT player FROM players WHERE nick='Haggar'),
117 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' 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 4'),
124 (SELECT player FROM players WHERE nick='Draconia'),
127 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
130 (SELECT player FROM players WHERE nick='Draconia'),
131 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
134 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
137 (SELECT player FROM players WHERE nick='Draconia'),
138 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
141 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
144 (SELECT player FROM players WHERE nick='Draconia'),
145 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
148 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' 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 4'),
152 (SELECT player FROM players WHERE nick='Snute'),
155 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
158 (SELECT player FROM players WHERE nick='Snute'),
159 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
162 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
165 (SELECT player FROM players WHERE nick='Snute'),
166 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
169 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
170 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
172 (SELECT player FROM players WHERE nick='Snute'),
173 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
176 INSERT INTO groups (tournament, round, parallel) VALUES (
177 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
179 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
180 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
182 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
184 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
189 UPDATE rounds SET randomsongs=2 WHERE
190 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
192 UPDATE rounds SET chosensongs=1 WHERE
193 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
195 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
197 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
199 (SELECT player FROM players WHERE nick='Mync'),
202 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
205 (SELECT player FROM players WHERE nick='Mync'),
206 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
209 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
210 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
212 (SELECT player FROM players WHERE nick='Mync'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
216 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
219 (SELECT player FROM players WHERE nick='Mync'),
220 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
223 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' 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 4'),
227 (SELECT player FROM players WHERE nick='Glukko'),
230 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
233 (SELECT player FROM players WHERE nick='Glukko'),
234 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
237 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
240 (SELECT player FROM players WHERE nick='Glukko'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
244 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
247 (SELECT player FROM players WHERE nick='Glukko'),
248 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
251 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' 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 4'),
255 (SELECT player FROM players WHERE nick='Mulefisk'),
258 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
261 (SELECT player FROM players WHERE nick='Mulefisk'),
262 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
265 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
266 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
268 (SELECT player FROM players WHERE nick='Mulefisk'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
272 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
275 (SELECT player FROM players WHERE nick='Mulefisk'),
276 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
279 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' 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 4'),
283 (SELECT player FROM players WHERE nick='Ylini'),
286 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
289 (SELECT player FROM players WHERE nick='Ylini'),
290 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
293 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
296 (SELECT player FROM players WHERE nick='Ylini'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
300 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
303 (SELECT player FROM players WHERE nick='Ylini'),
304 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
307 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' 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 4'),
311 (SELECT player FROM players WHERE nick='DufF'),
314 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
317 (SELECT player FROM players WHERE nick='DufF'),
318 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
321 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
322 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
324 (SELECT player FROM players WHERE nick='DufF'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
328 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
331 (SELECT player FROM players WHERE nick='DufF'),
332 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
335 INSERT INTO groups (tournament, round, parallel) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
338 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
339 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
341 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
343 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
348 UPDATE rounds SET randomsongs=2 WHERE
349 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
351 UPDATE rounds SET chosensongs=1 WHERE
352 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
354 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
355 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
356 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
358 (SELECT player FROM players WHERE nick='Pingo'),
361 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
364 (SELECT player FROM players WHERE nick='Pingo'),
365 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
368 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
371 (SELECT player FROM players WHERE nick='Pingo'),
372 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
375 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
378 (SELECT player FROM players WHERE nick='Pingo'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
382 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
384 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
386 (SELECT player FROM players WHERE nick='Jim Andre'),
389 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
392 (SELECT player FROM players WHERE nick='Jim Andre'),
393 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
396 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
397 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
399 (SELECT player FROM players WHERE nick='Jim Andre'),
400 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
403 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
406 (SELECT player FROM players WHERE nick='Jim Andre'),
407 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
410 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' 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 4'),
414 (SELECT player FROM players WHERE nick='Dabi'),
417 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
420 (SELECT player FROM players WHERE nick='Dabi'),
421 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
424 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
427 (SELECT player FROM players WHERE nick='Dabi'),
428 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
431 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
432 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
434 (SELECT player FROM players WHERE nick='Dabi'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
438 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 4'),
442 (SELECT player FROM players WHERE nick='Olemann'),
445 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
448 (SELECT player FROM players WHERE nick='Olemann'),
449 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
452 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
455 (SELECT player FROM players WHERE nick='Olemann'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
459 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
462 (SELECT player FROM players WHERE nick='Olemann'),
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, 'OJK' AS nick WHERE 'OJK' 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 4'),
470 (SELECT player FROM players WHERE nick='OJK'),
473 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
476 (SELECT player FROM players WHERE nick='OJK'),
477 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
480 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
481 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
483 (SELECT player FROM players WHERE nick='OJK'),
484 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
487 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
488 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
490 (SELECT player FROM players WHERE nick='OJK'),
491 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
494 INSERT INTO groups (tournament, round, parallel) VALUES (
495 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
497 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
498 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
500 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
502 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
503 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
507 UPDATE rounds SET randomsongs=2 WHERE
508 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
510 UPDATE rounds SET chosensongs=1 WHERE
511 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick WHERE 'Mario' 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 4'),
517 (SELECT player FROM players WHERE nick='Mario'),
520 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
521 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
523 (SELECT player FROM players WHERE nick='Mario'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
527 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
530 (SELECT player FROM players WHERE nick='Mario'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
534 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
535 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
537 (SELECT player FROM players WHERE nick='Mario'),
538 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
541 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
542 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
545 (SELECT player FROM players WHERE nick='Gogo'),
548 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
549 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
551 (SELECT player FROM players WHERE nick='Gogo'),
552 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
555 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
556 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
558 (SELECT player FROM players WHERE nick='Gogo'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
562 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
565 (SELECT player FROM players WHERE nick='Gogo'),
566 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
569 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
570 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
571 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
573 (SELECT player FROM players WHERE nick='Ted Kristian'),
576 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
579 (SELECT player FROM players WHERE nick='Ted Kristian'),
580 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
583 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
586 (SELECT player FROM players WHERE nick='Ted Kristian'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
590 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
593 (SELECT player FROM players WHERE nick='Ted Kristian'),
594 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
597 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' 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 4'),
601 (SELECT player FROM players WHERE nick='Duckling'),
604 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
607 (SELECT player FROM players WHERE nick='Duckling'),
608 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
611 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
614 (SELECT player FROM players WHERE nick='Duckling'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
618 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
619 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
621 (SELECT player FROM players WHERE nick='Duckling'),
622 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
625 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' 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 4'),
629 (SELECT player FROM players WHERE nick='Smiph'),
632 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
633 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
635 (SELECT player FROM players WHERE nick='Smiph'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
639 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
642 (SELECT player FROM players WHERE nick='Smiph'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
646 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
647 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
649 (SELECT player FROM players WHERE nick='Smiph'),
650 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
653 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' 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 4'),
657 (SELECT player FROM players WHERE nick='RiChY'),
660 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
661 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
663 (SELECT player FROM players WHERE nick='RiChY'),
664 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
667 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
668 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
670 (SELECT player FROM players WHERE nick='RiChY'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
674 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
677 (SELECT player FROM players WHERE nick='RiChY'),
678 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
681 INSERT INTO groups (tournament, round, parallel) VALUES (
682 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
684 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
685 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
687 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
689 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
690 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
694 UPDATE rounds SET randomsongs=2 WHERE
695 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
697 UPDATE rounds SET chosensongs=1 WHERE
698 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
700 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' 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 4'),
704 (SELECT player FROM players WHERE nick='Alexxz'),
707 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
710 (SELECT player FROM players WHERE nick='Alexxz'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
714 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
717 (SELECT player FROM players WHERE nick='Alexxz'),
718 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
721 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
722 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
724 (SELECT player FROM players WHERE nick='Alexxz'),
725 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
728 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick WHERE 'Zeek' NOT IN ( SELECT nick FROM players );
729 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
730 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
732 (SELECT player FROM players WHERE nick='Zeek'),
735 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
738 (SELECT player FROM players WHERE nick='Zeek'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
742 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
743 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
745 (SELECT player FROM players WHERE nick='Zeek'),
746 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
749 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
750 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
752 (SELECT player FROM players WHERE nick='Zeek'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
756 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
757 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
758 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
760 (SELECT player FROM players WHERE nick='Bonzo'),
763 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
764 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
766 (SELECT player FROM players WHERE nick='Bonzo'),
767 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
770 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
773 (SELECT player FROM players WHERE nick='Bonzo'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
777 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
778 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
780 (SELECT player FROM players WHERE nick='Bonzo'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
784 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' 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 4'),
788 (SELECT player FROM players WHERE nick='Tom'),
791 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
794 (SELECT player FROM players WHERE nick='Tom'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
798 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
801 (SELECT player FROM players WHERE nick='Tom'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
805 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
806 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
808 (SELECT player FROM players WHERE nick='Tom'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
812 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
816 (SELECT player FROM players WHERE nick='Snofox'),
819 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
822 (SELECT player FROM players WHERE nick='Snofox'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
826 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
829 (SELECT player FROM players WHERE nick='Snofox'),
830 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
833 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
834 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
836 (SELECT player FROM players WHERE nick='Snofox'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
840 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' 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 4'),
844 (SELECT player FROM players WHERE nick='T|na'),
847 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
848 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
850 (SELECT player FROM players WHERE nick='T|na'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
854 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
855 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
857 (SELECT player FROM players WHERE nick='T|na'),
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 4'),
864 (SELECT player FROM players WHERE nick='T|na'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
868 INSERT INTO groups (tournament, round, parallel) VALUES (
869 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
871 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
872 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
874 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
876 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
879 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
881 UPDATE rounds SET randomsongs=2 WHERE
882 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
884 UPDATE rounds SET chosensongs=1 WHERE
885 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' 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 4'),
891 (SELECT player FROM players WHERE nick='Ozon'),
894 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
897 (SELECT player FROM players WHERE nick='Ozon'),
898 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
901 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
902 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
904 (SELECT player FROM players WHERE nick='Ozon'),
905 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
908 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
909 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
911 (SELECT player FROM players WHERE nick='Ozon'),
912 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
915 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
916 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
917 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
919 (SELECT player FROM players WHERE nick='Hyper'),
922 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
923 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
925 (SELECT player FROM players WHERE nick='Hyper'),
926 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
929 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
930 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
932 (SELECT player FROM players WHERE nick='Hyper'),
933 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
936 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
939 (SELECT player FROM players WHERE nick='Hyper'),
940 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
943 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
944 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
945 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
947 (SELECT player FROM players WHERE nick='Nameless'),
950 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
953 (SELECT player FROM players WHERE nick='Nameless'),
954 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
957 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
960 (SELECT player FROM players WHERE nick='Nameless'),
961 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
964 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
967 (SELECT player FROM players WHERE nick='Nameless'),
968 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
971 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
972 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
973 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
975 (SELECT player FROM players WHERE nick='Daniil'),
978 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
981 (SELECT player FROM players WHERE nick='Daniil'),
982 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
985 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
986 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
988 (SELECT player FROM players WHERE nick='Daniil'),
989 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
992 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
993 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
995 (SELECT player FROM players WHERE nick='Daniil'),
996 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
999 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1000 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1001 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1003 (SELECT player FROM players WHERE nick='Oliyzia'),
1006 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1009 (SELECT player FROM players WHERE nick='Oliyzia'),
1010 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1013 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1014 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1016 (SELECT player FROM players WHERE nick='Oliyzia'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1020 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1021 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1023 (SELECT player FROM players WHERE nick='Oliyzia'),
1024 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1027 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1028 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1031 (SELECT player FROM players WHERE nick='Stream'),
1034 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1037 (SELECT player FROM players WHERE nick='Stream'),
1038 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1041 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1042 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1044 (SELECT player FROM players WHERE nick='Stream'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1048 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1051 (SELECT player FROM players WHERE nick='Stream'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1055 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1057 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1060 INSERT INTO groups (tournament, round, parallel) VALUES (
1061 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1063 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1064 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1068 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1069 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1073 UPDATE rounds SET randomsongs=2 WHERE
1074 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1076 UPDATE rounds SET chosensongs=1 WHERE
1077 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1079 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' 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 4'),
1083 (SELECT player FROM players WHERE nick='Olemann'),
1086 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1087 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1089 (SELECT player FROM players WHERE nick='Olemann'),
1090 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1093 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1096 (SELECT player FROM players WHERE nick='Olemann'),
1097 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1100 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1101 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1103 (SELECT player FROM players WHERE nick='Olemann'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1107 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1109 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1111 (SELECT player FROM players WHERE nick='T|na'),
1114 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1115 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1117 (SELECT player FROM players WHERE nick='T|na'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1121 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1124 (SELECT player FROM players WHERE nick='T|na'),
1125 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1128 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1129 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1131 (SELECT player FROM players WHERE nick='T|na'),
1132 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1135 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1136 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1137 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1139 (SELECT player FROM players WHERE nick='Oliyzia'),
1142 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1145 (SELECT player FROM players WHERE nick='Oliyzia'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1149 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1152 (SELECT player FROM players WHERE nick='Oliyzia'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1156 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1157 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1159 (SELECT player FROM players WHERE nick='Oliyzia'),
1160 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1163 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1164 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1165 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1167 (SELECT player FROM players WHERE nick='Snofox'),
1170 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1173 (SELECT player FROM players WHERE nick='Snofox'),
1174 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1177 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1178 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1180 (SELECT player FROM players WHERE nick='Snofox'),
1181 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1184 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1185 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1187 (SELECT player FROM players WHERE nick='Snofox'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1193 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1195 (SELECT player FROM players WHERE nick='Tom'),
1198 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1199 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1201 (SELECT player FROM players WHERE nick='Tom'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1205 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1206 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1208 (SELECT player FROM players WHERE nick='Tom'),
1209 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1212 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1213 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1215 (SELECT player FROM players WHERE nick='Tom'),
1216 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1219 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1220 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1221 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1223 (SELECT player FROM players WHERE nick='Snute'),
1226 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1227 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1229 (SELECT player FROM players WHERE nick='Snute'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1233 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1234 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1236 (SELECT player FROM players WHERE nick='Snute'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1240 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1241 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1243 (SELECT player FROM players WHERE nick='Snute'),
1244 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1247 INSERT INTO groups (tournament, round, parallel) VALUES (
1248 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1250 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1251 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1253 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
1255 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1256 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1258 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1260 UPDATE rounds SET randomsongs=2 WHERE
1261 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1263 UPDATE rounds SET chosensongs=1 WHERE
1264 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1266 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1267 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1268 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1270 (SELECT player FROM players WHERE nick='Duckling'),
1273 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1276 (SELECT player FROM players WHERE nick='Duckling'),
1277 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1280 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1281 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1283 (SELECT player FROM players WHERE nick='Duckling'),
1284 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1287 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1290 (SELECT player FROM players WHERE nick='Duckling'),
1291 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1294 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1296 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1298 (SELECT player FROM players WHERE nick='Daniil'),
1301 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1302 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1304 (SELECT player FROM players WHERE nick='Daniil'),
1305 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1308 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1309 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1311 (SELECT player FROM players WHERE nick='Daniil'),
1312 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1315 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1316 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1318 (SELECT player FROM players WHERE nick='Daniil'),
1319 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1322 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1323 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1324 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1326 (SELECT player FROM players WHERE nick='Mulefisk'),
1329 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1330 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1332 (SELECT player FROM players WHERE nick='Mulefisk'),
1333 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1336 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1337 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1339 (SELECT player FROM players WHERE nick='Mulefisk'),
1340 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1343 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1344 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1346 (SELECT player FROM players WHERE nick='Mulefisk'),
1347 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1350 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1351 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1352 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1354 (SELECT player FROM players WHERE nick='Haggar'),
1357 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1360 (SELECT player FROM players WHERE nick='Haggar'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1364 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1367 (SELECT player FROM players WHERE nick='Haggar'),
1368 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1371 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1372 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1374 (SELECT player FROM players WHERE nick='Haggar'),
1375 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1378 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1380 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1382 (SELECT player FROM players WHERE nick='Nameless'),
1385 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1388 (SELECT player FROM players WHERE nick='Nameless'),
1389 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1392 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1393 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1395 (SELECT player FROM players WHERE nick='Nameless'),
1396 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1399 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1402 (SELECT player FROM players WHERE nick='Nameless'),
1403 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1406 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1407 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1408 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1410 (SELECT player FROM players WHERE nick='OJK'),
1413 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1414 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1416 (SELECT player FROM players WHERE nick='OJK'),
1417 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1420 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1421 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1423 (SELECT player FROM players WHERE nick='OJK'),
1424 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1427 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1428 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1430 (SELECT player FROM players WHERE nick='OJK'),
1431 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1434 INSERT INTO groups (tournament, round, parallel) VALUES (
1435 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1437 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1438 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1440 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1442 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1443 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1445 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1447 UPDATE rounds SET randomsongs=2 WHERE
1448 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1450 UPDATE rounds SET chosensongs=1 WHERE
1451 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1453 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
1454 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1455 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1457 (SELECT player FROM players WHERE nick='Tassen'),
1460 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1463 (SELECT player FROM players WHERE nick='Tassen'),
1464 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1467 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1468 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1470 (SELECT player FROM players WHERE nick='Tassen'),
1471 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1474 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1475 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1477 (SELECT player FROM players WHERE nick='Tassen'),
1478 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1481 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1483 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1485 (SELECT player FROM players WHERE nick='Ylini'),
1488 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1489 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1491 (SELECT player FROM players WHERE nick='Ylini'),
1492 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1495 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1496 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1498 (SELECT player FROM players WHERE nick='Ylini'),
1499 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1502 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1503 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1505 (SELECT player FROM players WHERE nick='Ylini'),
1506 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1509 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1510 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1511 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1513 (SELECT player FROM players WHERE nick='Pingo'),
1516 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1519 (SELECT player FROM players WHERE nick='Pingo'),
1520 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1523 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1526 (SELECT player FROM players WHERE nick='Pingo'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1530 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1531 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1533 (SELECT player FROM players WHERE nick='Pingo'),
1534 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1537 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1538 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1539 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1541 (SELECT player FROM players WHERE nick='Gogo'),
1544 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1545 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1547 (SELECT player FROM players WHERE nick='Gogo'),
1548 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1551 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1552 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1554 (SELECT player FROM players WHERE nick='Gogo'),
1555 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1558 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1559 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1561 (SELECT player FROM players WHERE nick='Gogo'),
1562 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1565 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1567 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1569 (SELECT player FROM players WHERE nick='RiChY'),
1572 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1573 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1575 (SELECT player FROM players WHERE nick='RiChY'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1579 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1582 (SELECT player FROM players WHERE nick='RiChY'),
1583 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1586 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1587 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1589 (SELECT player FROM players WHERE nick='RiChY'),
1590 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1593 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1594 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1595 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1597 (SELECT player FROM players WHERE nick='DufF'),
1600 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1601 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1603 (SELECT player FROM players WHERE nick='DufF'),
1604 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1607 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1608 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1610 (SELECT player FROM players WHERE nick='DufF'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1614 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1615 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1617 (SELECT player FROM players WHERE nick='DufF'),
1618 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1621 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1623 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1626 INSERT INTO groups (tournament, round, parallel) VALUES (
1627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1629 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1630 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1632 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1634 UPDATE rounds SET randomsongs=1 WHERE
1635 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1637 UPDATE rounds SET chosensongs=1 WHERE
1638 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1640 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1641 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1642 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1644 (SELECT player FROM players WHERE nick='OJK'),
1647 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1648 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1650 (SELECT player FROM players WHERE nick='OJK'),
1651 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1654 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1655 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1657 (SELECT player FROM players WHERE nick='OJK'),
1658 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1661 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1662 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1663 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1665 (SELECT player FROM players WHERE nick='Pingo'),
1668 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1669 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1671 (SELECT player FROM players WHERE nick='Pingo'),
1672 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1675 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1676 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1678 (SELECT player FROM players WHERE nick='Pingo'),
1679 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1682 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1683 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1684 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1686 (SELECT player FROM players WHERE nick='Tom'),
1689 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1690 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1692 (SELECT player FROM players WHERE nick='Tom'),
1693 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1696 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1699 (SELECT player FROM players WHERE nick='Tom'),
1700 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1703 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1704 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1705 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1707 (SELECT player FROM players WHERE nick='Nameless'),
1710 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1711 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1713 (SELECT player FROM players WHERE nick='Nameless'),
1714 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1717 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1718 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1720 (SELECT player FROM players WHERE nick='Nameless'),
1721 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1724 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1725 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1726 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1728 (SELECT player FROM players WHERE nick='RiChY'),
1731 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1732 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1734 (SELECT player FROM players WHERE nick='RiChY'),
1735 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1738 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1739 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1741 (SELECT player FROM players WHERE nick='RiChY'),
1742 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1745 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1746 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1747 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1749 (SELECT player FROM players WHERE nick='Snofox'),
1752 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1753 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1755 (SELECT player FROM players WHERE nick='Snofox'),
1756 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1759 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1760 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1762 (SELECT player FROM players WHERE nick='Snofox'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1766 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1767 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1768 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1770 (SELECT player FROM players WHERE nick='Haggar'),
1773 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1774 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1776 (SELECT player FROM players WHERE nick='Haggar'),
1777 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1780 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1781 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1783 (SELECT player FROM players WHERE nick='Haggar'),
1784 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1787 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1788 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1789 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1791 (SELECT player FROM players WHERE nick='Snute'),
1794 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1797 (SELECT player FROM players WHERE nick='Snute'),
1798 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1801 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1802 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1804 (SELECT player FROM players WHERE nick='Snute'),
1805 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1808 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1809 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1810 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1812 (SELECT player FROM players WHERE nick='DufF'),
1815 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1816 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1818 (SELECT player FROM players WHERE nick='DufF'),
1819 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1822 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1823 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1825 (SELECT player FROM players WHERE nick='DufF'),
1826 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1829 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1831 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1834 INSERT INTO groups (tournament, round, parallel) VALUES (
1835 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1837 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1838 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1840 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
1842 UPDATE rounds SET randomsongs=1 WHERE
1843 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1845 UPDATE rounds SET chosensongs=1 WHERE
1846 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1848 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1849 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1850 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1852 (SELECT player FROM players WHERE nick='Haggar'),
1855 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1856 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1858 (SELECT player FROM players WHERE nick='Haggar'),
1859 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1862 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1863 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1865 (SELECT player FROM players WHERE nick='Haggar'),
1866 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1869 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1870 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1871 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1873 (SELECT player FROM players WHERE nick='Snofox'),
1876 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1877 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1879 (SELECT player FROM players WHERE nick='Snofox'),
1880 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1883 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1884 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1886 (SELECT player FROM players WHERE nick='Snofox'),
1887 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1890 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1892 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1894 (SELECT player FROM players WHERE nick='RiChY'),
1897 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1898 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1900 (SELECT player FROM players WHERE nick='RiChY'),
1901 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1904 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1905 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1907 (SELECT player FROM players WHERE nick='RiChY'),
1908 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1911 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1912 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1913 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1915 (SELECT player FROM players WHERE nick='Nameless'),
1918 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1919 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1921 (SELECT player FROM players WHERE nick='Nameless'),
1922 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1925 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1928 (SELECT player FROM players WHERE nick='Nameless'),
1929 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1932 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1934 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1936 (SELECT player FROM players WHERE nick='Snute'),
1939 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1940 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1942 (SELECT player FROM players WHERE nick='Snute'),
1943 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1946 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1949 (SELECT player FROM players WHERE nick='Snute'),
1950 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1953 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1954 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1955 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1957 (SELECT player FROM players WHERE nick='DufF'),
1960 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1961 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1963 (SELECT player FROM players WHERE nick='DufF'),
1964 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1967 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1968 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1970 (SELECT player FROM players WHERE nick='DufF'),
1971 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1974 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1975 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1976 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1978 (SELECT player FROM players WHERE nick='OJK'),
1981 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1982 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1984 (SELECT player FROM players WHERE nick='OJK'),
1985 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
1988 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
1989 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1991 (SELECT player FROM players WHERE nick='OJK'),
1992 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1995 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1997 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2000 INSERT INTO groups (tournament, round, parallel) VALUES (
2001 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2003 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2004 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2006 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2008 UPDATE rounds SET randomsongs=1 WHERE
2009 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2011 UPDATE rounds SET chosensongs=1 WHERE
2012 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2014 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2015 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2016 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2018 (SELECT player FROM players WHERE nick='Nameless'),
2021 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2022 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2024 (SELECT player FROM players WHERE nick='Nameless'),
2025 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2028 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2029 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2031 (SELECT player FROM players WHERE nick='Nameless'),
2032 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2035 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2037 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2039 (SELECT player FROM players WHERE nick='RiChY'),
2042 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2043 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2045 (SELECT player FROM players WHERE nick='RiChY'),
2046 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2049 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2052 (SELECT player FROM players WHERE nick='RiChY'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2056 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2057 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2058 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2060 (SELECT player FROM players WHERE nick='Haggar'),
2063 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2064 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2066 (SELECT player FROM players WHERE nick='Haggar'),
2067 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2070 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2071 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2073 (SELECT player FROM players WHERE nick='Haggar'),
2074 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2077 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2078 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2079 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2081 (SELECT player FROM players WHERE nick='Snute'),
2084 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2087 (SELECT player FROM players WHERE nick='Snute'),
2088 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2091 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2092 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2094 (SELECT player FROM players WHERE nick='Snute'),
2095 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2098 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2102 (SELECT player FROM players WHERE nick='DufF'),
2105 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2108 (SELECT player FROM players WHERE nick='DufF'),
2109 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2112 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2115 (SELECT player FROM players WHERE nick='DufF'),
2116 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2119 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2121 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2124 INSERT INTO groups (tournament, round, parallel) VALUES (
2125 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2127 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2128 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2130 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
2132 UPDATE rounds SET randomsongs=1 WHERE
2133 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2135 UPDATE rounds SET chosensongs=1 WHERE
2136 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2139 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2140 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2142 (SELECT player FROM players WHERE nick='RiChY'),
2145 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2146 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2148 (SELECT player FROM players WHERE nick='RiChY'),
2149 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2152 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2155 (SELECT player FROM players WHERE nick='RiChY'),
2156 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2159 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2160 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2161 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2163 (SELECT player FROM players WHERE nick='Haggar'),
2166 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2167 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2169 (SELECT player FROM players WHERE nick='Haggar'),
2170 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2173 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2174 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2176 (SELECT player FROM players WHERE nick='Haggar'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2181 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2184 (SELECT player FROM players WHERE nick='DufF'),
2187 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2188 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2190 (SELECT player FROM players WHERE nick='DufF'),
2191 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2194 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2195 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2197 (SELECT player FROM players WHERE nick='DufF'),
2198 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2201 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2202 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2203 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2205 (SELECT player FROM players WHERE nick='Snute'),
2208 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2209 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2211 (SELECT player FROM players WHERE nick='Snute'),
2212 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2215 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2216 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2218 (SELECT player FROM players WHERE nick='Snute'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2222 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2224 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2227 INSERT INTO groups (tournament, round, parallel) VALUES (
2228 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2231 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2233 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
2235 UPDATE rounds SET randomsongs=1 WHERE
2236 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2238 UPDATE rounds SET chosensongs=1 WHERE
2239 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2243 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2245 (SELECT player FROM players WHERE nick='RiChY'),
2248 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2251 (SELECT player FROM players WHERE nick='RiChY'),
2252 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2255 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2256 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2258 (SELECT player FROM players WHERE nick='RiChY'),
2259 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2262 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2263 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2264 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2266 (SELECT player FROM players WHERE nick='DufF'),
2269 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2272 (SELECT player FROM players WHERE nick='DufF'),
2273 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2276 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2277 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2279 (SELECT player FROM players WHERE nick='DufF'),
2280 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2283 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2284 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2285 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2287 (SELECT player FROM players WHERE nick='Snute'),
2290 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2291 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2293 (SELECT player FROM players WHERE nick='Snute'),
2294 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2297 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2298 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2300 (SELECT player FROM players WHERE nick='Snute'),
2301 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2304 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2306 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2309 INSERT INTO groups (tournament, round, parallel) VALUES (
2310 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2312 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2313 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2315 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2317 UPDATE rounds SET randomsongs=1 WHERE
2318 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2320 UPDATE rounds SET chosensongs=1 WHERE
2321 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2323 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2324 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2325 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2327 (SELECT player FROM players WHERE nick='Snute'),
2330 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2331 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2333 (SELECT player FROM players WHERE nick='Snute'),
2334 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2337 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2338 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2340 (SELECT player FROM players WHERE nick='Snute'),
2341 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2344 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2345 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2346 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2348 (SELECT player FROM players WHERE nick='DufF'),
2351 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2352 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2354 (SELECT player FROM players WHERE nick='DufF'),
2355 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2358 INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
2359 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2361 (SELECT player FROM players WHERE nick='DufF'),
2362 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),