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, songnumber, song, chosen, score) VALUES (
44 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
46 (SELECT player FROM players WHERE nick='Pål Andre'),
48 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
51 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
52 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
54 (SELECT player FROM players WHERE nick='Pål Andre'),
56 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
59 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
60 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
62 (SELECT player FROM players WHERE nick='Pål Andre'),
64 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
67 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
68 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
69 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
71 (SELECT player FROM players WHERE nick='Tassen'),
74 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
75 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
77 (SELECT player FROM players WHERE nick='Tassen'),
79 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
82 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
83 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
85 (SELECT player FROM players WHERE nick='Tassen'),
87 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
90 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
91 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
93 (SELECT player FROM players WHERE nick='Tassen'),
95 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
98 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
99 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
102 (SELECT player FROM players WHERE nick='Haggar'),
105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
106 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
108 (SELECT player FROM players WHERE nick='Haggar'),
110 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
114 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
116 (SELECT player FROM players WHERE nick='Haggar'),
118 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
122 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
124 (SELECT player FROM players WHERE nick='Haggar'),
126 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
133 (SELECT player FROM players WHERE nick='Draconia'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
139 (SELECT player FROM players WHERE nick='Draconia'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
147 (SELECT player FROM players WHERE nick='Draconia'),
149 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
155 (SELECT player FROM players WHERE nick='Draconia'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
162 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
164 (SELECT player FROM players WHERE nick='Snute'),
167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
170 (SELECT player FROM players WHERE nick='Snute'),
172 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
178 (SELECT player FROM players WHERE nick='Snute'),
180 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
184 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
186 (SELECT player FROM players WHERE nick='Snute'),
188 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
191 INSERT INTO groups (tournament, round, parallel) VALUES (
192 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
194 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
195 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
197 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
199 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
200 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
202 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
204 UPDATE rounds SET randomsongs=2 WHERE
205 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
207 UPDATE rounds SET chosensongs=1 WHERE
208 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
212 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
214 (SELECT player FROM players WHERE nick='Mync'),
217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
218 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
220 (SELECT player FROM players WHERE nick='Mync'),
222 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
226 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
228 (SELECT player FROM players WHERE nick='Mync'),
230 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
234 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
236 (SELECT player FROM players WHERE nick='Mync'),
238 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
241 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
245 (SELECT player FROM players WHERE nick='Glukko'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
251 (SELECT player FROM players WHERE nick='Glukko'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
259 (SELECT player FROM players WHERE nick='Glukko'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
267 (SELECT player FROM players WHERE nick='Glukko'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
272 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
274 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
276 (SELECT player FROM players WHERE nick='Mulefisk'),
279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
280 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
282 (SELECT player FROM players WHERE nick='Mulefisk'),
284 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
288 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
290 (SELECT player FROM players WHERE nick='Mulefisk'),
292 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
295 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
296 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
298 (SELECT player FROM players WHERE nick='Mulefisk'),
300 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
303 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
305 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
307 (SELECT player FROM players WHERE nick='Ylini'),
310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
311 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
313 (SELECT player FROM players WHERE nick='Ylini'),
315 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
321 (SELECT player FROM players WHERE nick='Ylini'),
323 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
329 (SELECT player FROM players WHERE nick='Ylini'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
334 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
335 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
336 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
338 (SELECT player FROM players WHERE nick='DufF'),
341 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
342 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
344 (SELECT player FROM players WHERE nick='DufF'),
346 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
349 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
350 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
352 (SELECT player FROM players WHERE nick='DufF'),
354 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
357 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
360 (SELECT player FROM players WHERE nick='DufF'),
362 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
365 INSERT INTO groups (tournament, round, parallel) VALUES (
366 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
368 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
369 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
371 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
373 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
374 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
376 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
378 UPDATE rounds SET randomsongs=2 WHERE
379 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
381 UPDATE rounds SET chosensongs=1 WHERE
382 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
384 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
385 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
386 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
388 (SELECT player FROM players WHERE nick='Pingo'),
391 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
392 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
394 (SELECT player FROM players WHERE nick='Pingo'),
396 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
399 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
400 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
402 (SELECT player FROM players WHERE nick='Pingo'),
404 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
408 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
410 (SELECT player FROM players WHERE nick='Pingo'),
412 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
415 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
416 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
417 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
419 (SELECT player FROM players WHERE nick='Jim Andre'),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
425 (SELECT player FROM players WHERE nick='Jim Andre'),
427 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
433 (SELECT player FROM players WHERE nick='Jim Andre'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
439 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
441 (SELECT player FROM players WHERE nick='Jim Andre'),
443 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
446 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
448 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
450 (SELECT player FROM players WHERE nick='Dabi'),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
456 (SELECT player FROM players WHERE nick='Dabi'),
458 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
461 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
462 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
464 (SELECT player FROM players WHERE nick='Dabi'),
466 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
469 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
470 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
472 (SELECT player FROM players WHERE nick='Dabi'),
474 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
477 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
479 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
481 (SELECT player FROM players WHERE nick='Olemann'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
487 (SELECT player FROM players WHERE nick='Olemann'),
489 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
495 (SELECT player FROM players WHERE nick='Olemann'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
503 (SELECT player FROM players WHERE nick='Olemann'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
508 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
509 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
510 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
512 (SELECT player FROM players WHERE nick='OJK'),
515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
516 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
518 (SELECT player FROM players WHERE nick='OJK'),
520 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
526 (SELECT player FROM players WHERE nick='OJK'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
534 (SELECT player FROM players WHERE nick='OJK'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
539 INSERT INTO groups (tournament, round, parallel) VALUES (
540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
542 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
543 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
547 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
548 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
550 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
552 UPDATE rounds SET randomsongs=2 WHERE
553 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
555 UPDATE rounds SET chosensongs=1 WHERE
556 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
558 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick WHERE 'Mario' NOT IN ( SELECT nick FROM players );
559 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
560 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
562 (SELECT player FROM players WHERE nick='Mario'),
565 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
566 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
568 (SELECT player FROM players WHERE nick='Mario'),
570 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
574 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
576 (SELECT player FROM players WHERE nick='Mario'),
578 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
582 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
584 (SELECT player FROM players WHERE nick='Mario'),
586 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
589 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
591 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
593 (SELECT player FROM players WHERE nick='Gogo'),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
599 (SELECT player FROM players WHERE nick='Gogo'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
605 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
607 (SELECT player FROM players WHERE nick='Gogo'),
609 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
612 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
613 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
615 (SELECT player FROM players WHERE nick='Gogo'),
617 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
620 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
621 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
622 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
624 (SELECT player FROM players WHERE nick='Ted Kristian'),
627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
630 (SELECT player FROM players WHERE nick='Ted Kristian'),
632 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
638 (SELECT player FROM players WHERE nick='Ted Kristian'),
640 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
644 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
646 (SELECT player FROM players WHERE nick='Ted Kristian'),
648 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
651 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
652 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
653 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
655 (SELECT player FROM players WHERE nick='Duckling'),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
661 (SELECT player FROM players WHERE nick='Duckling'),
663 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
669 (SELECT player FROM players WHERE nick='Duckling'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
675 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
677 (SELECT player FROM players WHERE nick='Duckling'),
679 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
682 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
683 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
684 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
686 (SELECT player FROM players WHERE nick='Smiph'),
689 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
690 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
692 (SELECT player FROM players WHERE nick='Smiph'),
694 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
697 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
698 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
700 (SELECT player FROM players WHERE nick='Smiph'),
702 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
705 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
706 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
708 (SELECT player FROM players WHERE nick='Smiph'),
710 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
713 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
715 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
717 (SELECT player FROM players WHERE nick='RiChY'),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
723 (SELECT player FROM players WHERE nick='RiChY'),
725 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
729 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
731 (SELECT player FROM players WHERE nick='RiChY'),
733 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
739 (SELECT player FROM players WHERE nick='RiChY'),
741 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
744 INSERT INTO groups (tournament, round, parallel) VALUES (
745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
747 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
748 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
750 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
752 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
753 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
755 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
757 UPDATE rounds SET randomsongs=2 WHERE
758 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
760 UPDATE rounds SET chosensongs=1 WHERE
761 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
763 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
765 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
767 (SELECT player FROM players WHERE nick='Alexxz'),
770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
773 (SELECT player FROM players WHERE nick='Alexxz'),
775 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
779 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
781 (SELECT player FROM players WHERE nick='Alexxz'),
783 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
786 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
787 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
789 (SELECT player FROM players WHERE nick='Alexxz'),
791 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
794 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick WHERE 'Zeek' NOT IN ( SELECT nick FROM players );
795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
796 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
798 (SELECT player FROM players WHERE nick='Zeek'),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
804 (SELECT player FROM players WHERE nick='Zeek'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
812 (SELECT player FROM players WHERE nick='Zeek'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
817 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
818 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
820 (SELECT player FROM players WHERE nick='Zeek'),
822 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
825 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
826 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
827 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
829 (SELECT player FROM players WHERE nick='Bonzo'),
832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
833 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
835 (SELECT player FROM players WHERE nick='Bonzo'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
843 (SELECT player FROM players WHERE nick='Bonzo'),
845 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
851 (SELECT player FROM players WHERE nick='Bonzo'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
856 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
857 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
858 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
860 (SELECT player FROM players WHERE nick='Tom'),
863 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
864 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
866 (SELECT player FROM players WHERE nick='Tom'),
868 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
871 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
872 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
874 (SELECT player FROM players WHERE nick='Tom'),
876 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
880 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
882 (SELECT player FROM players WHERE nick='Tom'),
884 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
887 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' 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='Snofox'),
894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
897 (SELECT player FROM players WHERE nick='Snofox'),
899 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
905 (SELECT player FROM players WHERE nick='Snofox'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
913 (SELECT player FROM players WHERE nick='Snofox'),
915 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
918 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
919 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
920 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
922 (SELECT player FROM players WHERE nick='T|na'),
925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
928 (SELECT player FROM players WHERE nick='T|na'),
930 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
933 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
934 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
936 (SELECT player FROM players WHERE nick='T|na'),
938 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
942 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
944 (SELECT player FROM players WHERE nick='T|na'),
946 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
949 INSERT INTO groups (tournament, round, parallel) VALUES (
950 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
952 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
953 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
955 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
957 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
958 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
960 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
962 UPDATE rounds SET randomsongs=2 WHERE
963 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
965 UPDATE rounds SET chosensongs=1 WHERE
966 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
968 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
969 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
970 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
972 (SELECT player FROM players WHERE nick='Ozon'),
975 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
976 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
978 (SELECT player FROM players WHERE nick='Ozon'),
980 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
983 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
984 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
986 (SELECT player FROM players WHERE nick='Ozon'),
988 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
991 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
992 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
994 (SELECT player FROM players WHERE nick='Ozon'),
996 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
999 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' 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='Hyper'),
1006 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1007 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1009 (SELECT player FROM players WHERE nick='Hyper'),
1011 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1017 (SELECT player FROM players WHERE nick='Hyper'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1022 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1023 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1025 (SELECT player FROM players WHERE nick='Hyper'),
1027 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1030 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1031 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1032 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1034 (SELECT player FROM players WHERE nick='Nameless'),
1037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1038 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1040 (SELECT player FROM players WHERE nick='Nameless'),
1042 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1046 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1048 (SELECT player FROM players WHERE nick='Nameless'),
1050 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1053 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1054 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1056 (SELECT player FROM players WHERE nick='Nameless'),
1058 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1061 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1062 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1063 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1065 (SELECT player FROM players WHERE nick='Daniil'),
1068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1069 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1071 (SELECT player FROM players WHERE nick='Daniil'),
1073 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1076 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1077 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1079 (SELECT player FROM players WHERE nick='Daniil'),
1081 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1084 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1087 (SELECT player FROM players WHERE nick='Daniil'),
1089 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1092 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1093 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1094 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1096 (SELECT player FROM players WHERE nick='Oliyzia'),
1099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1100 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1102 (SELECT player FROM players WHERE nick='Oliyzia'),
1104 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1107 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1108 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1110 (SELECT player FROM players WHERE nick='Oliyzia'),
1112 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1115 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1116 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1118 (SELECT player FROM players WHERE nick='Oliyzia'),
1120 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1123 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1124 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1125 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1127 (SELECT player FROM players WHERE nick='Stream'),
1130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1131 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1133 (SELECT player FROM players WHERE nick='Stream'),
1135 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1139 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1141 (SELECT player FROM players WHERE nick='Stream'),
1143 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1149 (SELECT player FROM players WHERE nick='Stream'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1154 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1156 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1159 INSERT INTO groups (tournament, round, parallel) VALUES (
1160 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1162 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1163 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1165 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1167 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1168 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1170 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1172 UPDATE rounds SET randomsongs=2 WHERE
1173 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1175 UPDATE rounds SET chosensongs=1 WHERE
1176 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1178 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1179 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1180 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1182 (SELECT player FROM players WHERE nick='Olemann'),
1185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1186 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1188 (SELECT player FROM players WHERE nick='Olemann'),
1190 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1193 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1194 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1196 (SELECT player FROM players WHERE nick='Olemann'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1201 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1202 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1204 (SELECT player FROM players WHERE nick='Olemann'),
1206 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1209 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1211 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1213 (SELECT player FROM players WHERE nick='T|na'),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1219 (SELECT player FROM players WHERE nick='T|na'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1227 (SELECT player FROM players WHERE nick='T|na'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1233 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1235 (SELECT player FROM players WHERE nick='T|na'),
1237 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1240 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1242 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1244 (SELECT player FROM players WHERE nick='Oliyzia'),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1250 (SELECT player FROM players WHERE nick='Oliyzia'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1258 (SELECT player FROM players WHERE nick='Oliyzia'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1264 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1266 (SELECT player FROM players WHERE nick='Oliyzia'),
1268 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1271 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1272 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1273 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1275 (SELECT player FROM players WHERE nick='Snofox'),
1278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1279 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1281 (SELECT player FROM players WHERE nick='Snofox'),
1283 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1287 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1289 (SELECT player FROM players WHERE nick='Snofox'),
1291 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1295 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1297 (SELECT player FROM players WHERE nick='Snofox'),
1299 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1302 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1303 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1304 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1306 (SELECT player FROM players WHERE nick='Tom'),
1309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1310 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1312 (SELECT player FROM players WHERE nick='Tom'),
1314 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1317 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1318 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1320 (SELECT player FROM players WHERE nick='Tom'),
1322 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1325 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1326 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1328 (SELECT player FROM players WHERE nick='Tom'),
1330 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1333 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1334 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1335 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1337 (SELECT player FROM players WHERE nick='Snute'),
1340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1343 (SELECT player FROM players WHERE nick='Snute'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1351 (SELECT player FROM players WHERE nick='Snute'),
1353 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1357 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1359 (SELECT player FROM players WHERE nick='Snute'),
1361 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1364 INSERT INTO groups (tournament, round, parallel) VALUES (
1365 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1367 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1368 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1370 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
1372 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1373 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1375 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1377 UPDATE rounds SET randomsongs=2 WHERE
1378 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1380 UPDATE rounds SET chosensongs=1 WHERE
1381 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1383 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1384 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1385 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1387 (SELECT player FROM players WHERE nick='Duckling'),
1390 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1391 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1393 (SELECT player FROM players WHERE nick='Duckling'),
1395 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1399 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1401 (SELECT player FROM players WHERE nick='Duckling'),
1403 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1406 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1407 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1409 (SELECT player FROM players WHERE nick='Duckling'),
1411 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1414 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1416 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1418 (SELECT player FROM players WHERE nick='Daniil'),
1421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1422 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1424 (SELECT player FROM players WHERE nick='Daniil'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1430 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1432 (SELECT player FROM players WHERE nick='Daniil'),
1434 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1440 (SELECT player FROM players WHERE nick='Daniil'),
1442 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1445 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1446 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1447 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1449 (SELECT player FROM players WHERE nick='Mulefisk'),
1452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1453 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1455 (SELECT player FROM players WHERE nick='Mulefisk'),
1457 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1461 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1463 (SELECT player FROM players WHERE nick='Mulefisk'),
1465 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1469 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1471 (SELECT player FROM players WHERE nick='Mulefisk'),
1473 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1476 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1477 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1478 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1480 (SELECT player FROM players WHERE nick='Haggar'),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1486 (SELECT player FROM players WHERE nick='Haggar'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1491 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1494 (SELECT player FROM players WHERE nick='Haggar'),
1496 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1499 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1500 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1502 (SELECT player FROM players WHERE nick='Haggar'),
1504 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1507 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1508 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1509 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1511 (SELECT player FROM players WHERE nick='Nameless'),
1514 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1517 (SELECT player FROM players WHERE nick='Nameless'),
1519 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1522 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1523 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1525 (SELECT player FROM players WHERE nick='Nameless'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1531 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1533 (SELECT player FROM players WHERE nick='Nameless'),
1535 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1538 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1539 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1542 (SELECT player FROM players WHERE nick='OJK'),
1545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1546 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1548 (SELECT player FROM players WHERE nick='OJK'),
1550 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1554 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1556 (SELECT player FROM players WHERE nick='OJK'),
1558 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1562 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1564 (SELECT player FROM players WHERE nick='OJK'),
1566 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1569 INSERT INTO groups (tournament, round, parallel) VALUES (
1570 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1572 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1573 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1575 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1577 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1578 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1580 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1582 UPDATE rounds SET randomsongs=2 WHERE
1583 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1585 UPDATE rounds SET chosensongs=1 WHERE
1586 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1588 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
1589 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1590 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1592 (SELECT player FROM players WHERE nick='Tassen'),
1595 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1596 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1598 (SELECT player FROM players WHERE nick='Tassen'),
1600 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1604 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1606 (SELECT player FROM players WHERE nick='Tassen'),
1608 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1611 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1612 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1614 (SELECT player FROM players WHERE nick='Tassen'),
1616 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1619 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1620 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1621 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1623 (SELECT player FROM players WHERE nick='Ylini'),
1626 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1627 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1629 (SELECT player FROM players WHERE nick='Ylini'),
1631 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1634 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1635 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1637 (SELECT player FROM players WHERE nick='Ylini'),
1639 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1642 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1643 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1645 (SELECT player FROM players WHERE nick='Ylini'),
1647 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1650 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1652 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1654 (SELECT player FROM players WHERE nick='Pingo'),
1657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1658 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1660 (SELECT player FROM players WHERE nick='Pingo'),
1662 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1666 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1668 (SELECT player FROM players WHERE nick='Pingo'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1673 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1674 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1676 (SELECT player FROM players WHERE nick='Pingo'),
1678 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1681 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1683 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1685 (SELECT player FROM players WHERE nick='Gogo'),
1688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1689 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1691 (SELECT player FROM players WHERE nick='Gogo'),
1693 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1699 (SELECT player FROM players WHERE nick='Gogo'),
1701 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1704 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1705 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1707 (SELECT player FROM players WHERE nick='Gogo'),
1709 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1712 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1713 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1714 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1716 (SELECT player FROM players WHERE nick='RiChY'),
1719 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1720 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1722 (SELECT player FROM players WHERE nick='RiChY'),
1724 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1727 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1728 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1730 (SELECT player FROM players WHERE nick='RiChY'),
1732 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1735 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1736 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1738 (SELECT player FROM players WHERE nick='RiChY'),
1740 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1743 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1744 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1745 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1747 (SELECT player FROM players WHERE nick='DufF'),
1750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1751 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1753 (SELECT player FROM players WHERE nick='DufF'),
1755 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1759 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1761 (SELECT player FROM players WHERE nick='DufF'),
1763 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1766 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1767 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1769 (SELECT player FROM players WHERE nick='DufF'),
1771 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1774 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1776 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1779 INSERT INTO groups (tournament, round, parallel) VALUES (
1780 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1782 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1783 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1785 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1787 UPDATE rounds SET randomsongs=1 WHERE
1788 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1790 UPDATE rounds SET chosensongs=1 WHERE
1791 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
1793 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1795 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1797 (SELECT player FROM players WHERE nick='OJK'),
1800 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1801 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1803 (SELECT player FROM players WHERE nick='OJK'),
1805 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1808 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1809 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1811 (SELECT player FROM players WHERE nick='OJK'),
1813 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1816 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1817 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1818 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1820 (SELECT player FROM players WHERE nick='Pingo'),
1823 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1824 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1826 (SELECT player FROM players WHERE nick='Pingo'),
1828 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1831 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1832 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1834 (SELECT player FROM players WHERE nick='Pingo'),
1836 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1839 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1840 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1841 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1843 (SELECT player FROM players WHERE nick='Tom'),
1846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1847 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1849 (SELECT player FROM players WHERE nick='Tom'),
1851 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1854 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1855 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1857 (SELECT player FROM players WHERE nick='Tom'),
1859 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1862 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1863 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1864 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1866 (SELECT player FROM players WHERE nick='Nameless'),
1869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1870 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1872 (SELECT player FROM players WHERE nick='Nameless'),
1874 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1878 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1880 (SELECT player FROM players WHERE nick='Nameless'),
1882 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1885 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1886 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1887 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1889 (SELECT player FROM players WHERE nick='RiChY'),
1892 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1893 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1895 (SELECT player FROM players WHERE nick='RiChY'),
1897 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1900 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1901 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1903 (SELECT player FROM players WHERE nick='RiChY'),
1905 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1908 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1909 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1910 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1912 (SELECT player FROM players WHERE nick='Snofox'),
1915 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1916 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1918 (SELECT player FROM players WHERE nick='Snofox'),
1920 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1923 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1924 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1926 (SELECT player FROM players WHERE nick='Snofox'),
1928 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1931 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1932 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1933 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1935 (SELECT player FROM players WHERE nick='Haggar'),
1938 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1939 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1941 (SELECT player FROM players WHERE nick='Haggar'),
1943 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1946 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1947 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1949 (SELECT player FROM players WHERE nick='Haggar'),
1951 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1954 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1955 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1956 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1958 (SELECT player FROM players WHERE nick='Snute'),
1961 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1962 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1964 (SELECT player FROM players WHERE nick='Snute'),
1966 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1970 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1972 (SELECT player FROM players WHERE nick='Snute'),
1974 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1977 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1978 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1979 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1981 (SELECT player FROM players WHERE nick='DufF'),
1984 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1985 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1987 (SELECT player FROM players WHERE nick='DufF'),
1989 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1992 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1993 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
1995 (SELECT player FROM players WHERE nick='DufF'),
1997 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2000 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2002 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2005 INSERT INTO groups (tournament, round, parallel) VALUES (
2006 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2008 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2009 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2011 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
2013 UPDATE rounds SET randomsongs=1 WHERE
2014 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2016 UPDATE rounds SET chosensongs=1 WHERE
2017 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2019 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2020 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2021 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2023 (SELECT player FROM players WHERE nick='Haggar'),
2026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2027 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2029 (SELECT player FROM players WHERE nick='Haggar'),
2031 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2035 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2037 (SELECT player FROM players WHERE nick='Haggar'),
2039 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2042 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2043 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2044 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2046 (SELECT player FROM players WHERE nick='Snofox'),
2049 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2050 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2052 (SELECT player FROM players WHERE nick='Snofox'),
2054 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2057 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2058 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2060 (SELECT player FROM players WHERE nick='Snofox'),
2062 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2065 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2066 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2067 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2069 (SELECT player FROM players WHERE nick='RiChY'),
2072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2073 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2075 (SELECT player FROM players WHERE nick='RiChY'),
2077 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2081 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2083 (SELECT player FROM players WHERE nick='RiChY'),
2085 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2088 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2089 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2090 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2092 (SELECT player FROM players WHERE nick='Nameless'),
2095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2096 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2098 (SELECT player FROM players WHERE nick='Nameless'),
2100 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2104 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2106 (SELECT player FROM players WHERE nick='Nameless'),
2108 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2111 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2113 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2115 (SELECT player FROM players WHERE nick='Snute'),
2118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2119 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2121 (SELECT player FROM players WHERE nick='Snute'),
2123 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2127 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2129 (SELECT player FROM players WHERE nick='Snute'),
2131 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2134 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2135 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2136 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2138 (SELECT player FROM players WHERE nick='DufF'),
2141 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2142 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2144 (SELECT player FROM players WHERE nick='DufF'),
2146 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2149 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2150 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2152 (SELECT player FROM players WHERE nick='DufF'),
2154 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2157 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2158 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2159 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2161 (SELECT player FROM players WHERE nick='OJK'),
2164 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2165 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2167 (SELECT player FROM players WHERE nick='OJK'),
2169 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2173 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2175 (SELECT player FROM players WHERE nick='OJK'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2180 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2182 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2185 INSERT INTO groups (tournament, round, parallel) VALUES (
2186 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2188 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2189 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2191 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2193 UPDATE rounds SET randomsongs=1 WHERE
2194 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2196 UPDATE rounds SET chosensongs=1 WHERE
2197 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2199 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2200 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2201 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2203 (SELECT player FROM players WHERE nick='Nameless'),
2206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2207 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2209 (SELECT player FROM players WHERE nick='Nameless'),
2211 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2215 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2217 (SELECT player FROM players WHERE nick='Nameless'),
2219 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2224 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2226 (SELECT player FROM players WHERE nick='RiChY'),
2229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2230 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2232 (SELECT player FROM players WHERE nick='RiChY'),
2234 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2238 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2240 (SELECT player FROM players WHERE nick='RiChY'),
2242 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2245 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2247 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2249 (SELECT player FROM players WHERE nick='Haggar'),
2252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2253 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2255 (SELECT player FROM players WHERE nick='Haggar'),
2257 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2261 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2263 (SELECT player FROM players WHERE nick='Haggar'),
2265 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2268 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2269 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2270 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2272 (SELECT player FROM players WHERE nick='Snute'),
2275 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2276 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2278 (SELECT player FROM players WHERE nick='Snute'),
2280 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2283 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2284 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2286 (SELECT player FROM players WHERE nick='Snute'),
2288 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2291 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2292 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2293 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2295 (SELECT player FROM players WHERE nick='DufF'),
2298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2299 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2301 (SELECT player FROM players WHERE nick='DufF'),
2303 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2307 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2309 (SELECT player FROM players WHERE nick='DufF'),
2311 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2314 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2316 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2319 INSERT INTO groups (tournament, round, parallel) VALUES (
2320 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2322 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2323 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2325 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
2327 UPDATE rounds SET randomsongs=1 WHERE
2328 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2330 UPDATE rounds SET chosensongs=1 WHERE
2331 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2333 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2334 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2335 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2337 (SELECT player FROM players WHERE nick='RiChY'),
2340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2341 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2343 (SELECT player FROM players WHERE nick='RiChY'),
2345 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2349 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2351 (SELECT player FROM players WHERE nick='RiChY'),
2353 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2356 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2357 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2358 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2360 (SELECT player FROM players WHERE nick='Haggar'),
2363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2364 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2366 (SELECT player FROM players WHERE nick='Haggar'),
2368 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2372 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2374 (SELECT player FROM players WHERE nick='Haggar'),
2376 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2379 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2380 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2381 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2383 (SELECT player FROM players WHERE nick='DufF'),
2386 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2387 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2389 (SELECT player FROM players WHERE nick='DufF'),
2391 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2395 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2397 (SELECT player FROM players WHERE nick='DufF'),
2399 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2402 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2404 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2406 (SELECT player FROM players WHERE nick='Snute'),
2409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2410 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2412 (SELECT player FROM players WHERE nick='Snute'),
2414 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2418 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2420 (SELECT player FROM players WHERE nick='Snute'),
2422 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2425 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2427 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2430 INSERT INTO groups (tournament, round, parallel) VALUES (
2431 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2433 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2434 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2436 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
2438 UPDATE rounds SET randomsongs=1 WHERE
2439 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2441 UPDATE rounds SET chosensongs=1 WHERE
2442 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2444 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2446 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2448 (SELECT player FROM players WHERE nick='RiChY'),
2451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2452 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2454 (SELECT player FROM players WHERE nick='RiChY'),
2456 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2460 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2462 (SELECT player FROM players WHERE nick='RiChY'),
2464 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2467 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2468 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2469 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2471 (SELECT player FROM players WHERE nick='DufF'),
2474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2475 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2477 (SELECT player FROM players WHERE nick='DufF'),
2479 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2483 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2485 (SELECT player FROM players WHERE nick='DufF'),
2487 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2490 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2491 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2492 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2494 (SELECT player FROM players WHERE nick='Snute'),
2497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2498 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2500 (SELECT player FROM players WHERE nick='Snute'),
2502 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2505 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2506 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2508 (SELECT player FROM players WHERE nick='Snute'),
2510 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2513 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2515 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2518 INSERT INTO groups (tournament, round, parallel) VALUES (
2519 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2521 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2522 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2524 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2526 UPDATE rounds SET randomsongs=1 WHERE
2527 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2529 UPDATE rounds SET chosensongs=1 WHERE
2530 tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 4') AND
2532 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2533 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2534 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2536 (SELECT player FROM players WHERE nick='Snute'),
2539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2540 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2542 (SELECT player FROM players WHERE nick='Snute'),
2544 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2547 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2548 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2550 (SELECT player FROM players WHERE nick='Snute'),
2552 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2555 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2556 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2557 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2559 (SELECT player FROM players WHERE nick='DufF'),
2562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2563 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2565 (SELECT player FROM players WHERE nick='DufF'),
2567 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2570 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2571 (SELECT tournament FROM tournaments WHERE name='Challenge Cup 4'),
2573 (SELECT player FROM players WHERE nick='DufF'),
2575 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),