2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Challenge Cup 2004'),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
13 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
15 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
16 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
18 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
19 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
21 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
22 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
24 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
25 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
27 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
28 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
30 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
31 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
33 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
34 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
36 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
37 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
39 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
40 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
42 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
43 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
45 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
46 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
48 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
49 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
51 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
52 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
54 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
55 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
57 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
58 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
60 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
61 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
63 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
64 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
66 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
69 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
70 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
72 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
75 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
76 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
78 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
79 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
80 23, 'Ted Kristian', 33);
81 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
82 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
84 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
85 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
87 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
88 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
90 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
91 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
93 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
94 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
96 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
97 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
99 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
102 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
105 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
108 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
111 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
113 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
116 INSERT INTO groups (tournament, round, parallel) VALUES (
117 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
119 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
122 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
124 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
125 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
127 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
129 UPDATE rounds SET randomsongs=2 WHERE
130 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
132 UPDATE rounds SET chosensongs=1 WHERE
133 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
135 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 );
136 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
139 (SELECT player FROM players WHERE nick='Pål Andre'),
142 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
145 (SELECT player FROM players WHERE nick='Pål Andre'),
147 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
151 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
153 (SELECT player FROM players WHERE nick='Pål Andre'),
155 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
161 (SELECT player FROM players WHERE nick='Pål Andre'),
163 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
166 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
170 (SELECT player FROM players WHERE nick='Tassen'),
173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
174 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
176 (SELECT player FROM players WHERE nick='Tassen'),
178 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
184 (SELECT player FROM players WHERE nick='Tassen'),
186 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
190 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
192 (SELECT player FROM players WHERE nick='Tassen'),
194 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
197 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
201 (SELECT player FROM players WHERE nick='Haggar'),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
207 (SELECT player FROM players WHERE nick='Haggar'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
215 (SELECT player FROM players WHERE nick='Haggar'),
217 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
221 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
223 (SELECT player FROM players WHERE nick='Haggar'),
225 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
228 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
229 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
232 (SELECT player FROM players WHERE nick='Draconia'),
235 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
238 (SELECT player FROM players WHERE nick='Draconia'),
240 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
243 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
244 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
246 (SELECT player FROM players WHERE nick='Draconia'),
248 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
251 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
252 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
254 (SELECT player FROM players WHERE nick='Draconia'),
256 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
259 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
260 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
263 (SELECT player FROM players WHERE nick='Snute'),
266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
269 (SELECT player FROM players WHERE nick='Snute'),
271 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
275 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
277 (SELECT player FROM players WHERE nick='Snute'),
279 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
283 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
285 (SELECT player FROM players WHERE nick='Snute'),
287 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
290 INSERT INTO groups (tournament, round, parallel) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
293 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
294 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
296 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
298 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
299 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
301 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
303 UPDATE rounds SET randomsongs=2 WHERE
304 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
306 UPDATE rounds SET chosensongs=1 WHERE
307 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
309 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
310 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
313 (SELECT player FROM players WHERE nick='Mync'),
316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
319 (SELECT player FROM players WHERE nick='Mync'),
321 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
327 (SELECT player FROM players WHERE nick='Mync'),
329 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
335 (SELECT player FROM players WHERE nick='Mync'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
340 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
341 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
342 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
344 (SELECT player FROM players WHERE nick='Glukko'),
347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
348 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
350 (SELECT player FROM players WHERE nick='Glukko'),
352 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
356 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
358 (SELECT player FROM players WHERE nick='Glukko'),
360 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
364 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
366 (SELECT player FROM players WHERE nick='Glukko'),
368 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
371 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
372 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
373 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
375 (SELECT player FROM players WHERE nick='Mulefisk'),
378 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
381 (SELECT player FROM players WHERE nick='Mulefisk'),
383 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
386 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
387 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
389 (SELECT player FROM players WHERE nick='Mulefisk'),
391 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
395 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
397 (SELECT player FROM players WHERE nick='Mulefisk'),
399 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
402 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
403 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
404 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
406 (SELECT player FROM players WHERE nick='Ylini'),
409 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
410 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
412 (SELECT player FROM players WHERE nick='Ylini'),
414 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
417 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
418 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
420 (SELECT player FROM players WHERE nick='Ylini'),
422 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
425 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
426 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
428 (SELECT player FROM players WHERE nick='Ylini'),
430 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
433 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
434 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
435 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
437 (SELECT player FROM players WHERE nick='DufF'),
440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
443 (SELECT player FROM players WHERE nick='DufF'),
445 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
448 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
451 (SELECT player FROM players WHERE nick='DufF'),
453 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
456 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
457 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
459 (SELECT player FROM players WHERE nick='DufF'),
461 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
464 INSERT INTO groups (tournament, round, parallel) VALUES (
465 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
467 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
470 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
472 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
473 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
475 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
477 UPDATE rounds SET randomsongs=2 WHERE
478 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
480 UPDATE rounds SET chosensongs=1 WHERE
481 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
483 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
484 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
487 (SELECT player FROM players WHERE nick='Pingo'),
490 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
491 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
493 (SELECT player FROM players WHERE nick='Pingo'),
495 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
498 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
499 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
501 (SELECT player FROM players WHERE nick='Pingo'),
503 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
506 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
509 (SELECT player FROM players WHERE nick='Pingo'),
511 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
514 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jim Andre' AS nick WHERE 'Jim Andre' NOT IN ( SELECT nick FROM players );
515 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
516 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
518 (SELECT player FROM players WHERE nick='Jim Andre'),
521 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
522 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
524 (SELECT player FROM players WHERE nick='Jim Andre'),
526 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
532 (SELECT player FROM players WHERE nick='Jim Andre'),
534 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
538 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
540 (SELECT player FROM players WHERE nick='Jim Andre'),
542 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
545 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
546 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
549 (SELECT player FROM players WHERE nick='Dabi'),
552 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
553 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
555 (SELECT player FROM players WHERE nick='Dabi'),
557 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
560 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
563 (SELECT player FROM players WHERE nick='Dabi'),
565 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
571 (SELECT player FROM players WHERE nick='Dabi'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
576 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
577 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
578 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
580 (SELECT player FROM players WHERE nick='Olemann'),
583 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
586 (SELECT player FROM players WHERE nick='Olemann'),
588 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
591 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
592 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
594 (SELECT player FROM players WHERE nick='Olemann'),
596 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
599 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
600 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
602 (SELECT player FROM players WHERE nick='Olemann'),
604 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
607 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
608 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
611 (SELECT player FROM players WHERE nick='OJK'),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
617 (SELECT player FROM players WHERE nick='OJK'),
619 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
622 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
625 (SELECT player FROM players WHERE nick='OJK'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
630 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
633 (SELECT player FROM players WHERE nick='OJK'),
635 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
638 INSERT INTO groups (tournament, round, parallel) VALUES (
639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
641 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
642 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
646 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
649 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
651 UPDATE rounds SET randomsongs=2 WHERE
652 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
654 UPDATE rounds SET chosensongs=1 WHERE
655 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
657 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mario' AS nick WHERE 'Mario' NOT IN ( SELECT nick FROM players );
658 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
661 (SELECT player FROM players WHERE nick='Mario'),
664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
665 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
667 (SELECT player FROM players WHERE nick='Mario'),
669 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
672 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
673 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
675 (SELECT player FROM players WHERE nick='Mario'),
677 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
681 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
683 (SELECT player FROM players WHERE nick='Mario'),
685 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
688 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
689 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
690 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
692 (SELECT player FROM players WHERE nick='Gogo'),
695 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
698 (SELECT player FROM players WHERE nick='Gogo'),
700 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
703 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
704 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
706 (SELECT player FROM players WHERE nick='Gogo'),
708 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
711 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
712 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
714 (SELECT player FROM players WHERE nick='Gogo'),
716 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
719 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ted Kristian' AS nick WHERE 'Ted Kristian' NOT IN ( SELECT nick FROM players );
720 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
723 (SELECT player FROM players WHERE nick='Ted Kristian'),
726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
729 (SELECT player FROM players WHERE nick='Ted Kristian'),
731 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
734 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
735 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
737 (SELECT player FROM players WHERE nick='Ted Kristian'),
739 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
742 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
745 (SELECT player FROM players WHERE nick='Ted Kristian'),
747 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
750 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
751 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
752 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
754 (SELECT player FROM players WHERE nick='Duckling'),
757 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
758 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
760 (SELECT player FROM players WHERE nick='Duckling'),
762 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
765 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
768 (SELECT player FROM players WHERE nick='Duckling'),
770 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
773 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
774 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
776 (SELECT player FROM players WHERE nick='Duckling'),
778 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
781 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
782 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
783 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
785 (SELECT player FROM players WHERE nick='Smiph'),
788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
789 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
791 (SELECT player FROM players WHERE nick='Smiph'),
793 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
799 (SELECT player FROM players WHERE nick='Smiph'),
801 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
807 (SELECT player FROM players WHERE nick='Smiph'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
812 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
816 (SELECT player FROM players WHERE nick='RiChY'),
819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
822 (SELECT player FROM players WHERE nick='RiChY'),
824 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
827 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
828 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
830 (SELECT player FROM players WHERE nick='RiChY'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
836 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
838 (SELECT player FROM players WHERE nick='RiChY'),
840 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
843 INSERT INTO groups (tournament, round, parallel) VALUES (
844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
846 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
847 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
851 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
852 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
854 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
856 UPDATE rounds SET randomsongs=2 WHERE
857 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
859 UPDATE rounds SET chosensongs=1 WHERE
860 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
862 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
863 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
866 (SELECT player FROM players WHERE nick='Alexxz'),
869 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
872 (SELECT player FROM players WHERE nick='Alexxz'),
874 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
877 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
880 (SELECT player FROM players WHERE nick='Alexxz'),
882 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
885 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
886 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
888 (SELECT player FROM players WHERE nick='Alexxz'),
890 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
893 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zeek' AS nick WHERE 'Zeek' NOT IN ( SELECT nick FROM players );
894 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
897 (SELECT player FROM players WHERE nick='Zeek'),
900 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
901 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
903 (SELECT player FROM players WHERE nick='Zeek'),
905 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
908 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
909 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
911 (SELECT player FROM players WHERE nick='Zeek'),
913 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
916 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
917 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
919 (SELECT player FROM players WHERE nick='Zeek'),
921 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
924 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
925 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
926 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
928 (SELECT player FROM players WHERE nick='Bonzo'),
931 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
932 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
934 (SELECT player FROM players WHERE nick='Bonzo'),
936 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
940 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
942 (SELECT player FROM players WHERE nick='Bonzo'),
944 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
948 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
950 (SELECT player FROM players WHERE nick='Bonzo'),
952 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
955 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
956 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
959 (SELECT player FROM players WHERE nick='Tom'),
962 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
965 (SELECT player FROM players WHERE nick='Tom'),
967 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
970 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
971 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
973 (SELECT player FROM players WHERE nick='Tom'),
975 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
981 (SELECT player FROM players WHERE nick='Tom'),
983 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
986 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
987 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
988 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
990 (SELECT player FROM players WHERE nick='Snofox'),
993 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
994 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
996 (SELECT player FROM players WHERE nick='Snofox'),
998 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1001 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1002 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1004 (SELECT player FROM players WHERE nick='Snofox'),
1006 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1009 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1010 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1012 (SELECT player FROM players WHERE nick='Snofox'),
1014 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1017 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1018 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1021 (SELECT player FROM players WHERE nick='T|na'),
1024 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1025 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1027 (SELECT player FROM players WHERE nick='T|na'),
1029 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
1032 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1033 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1035 (SELECT player FROM players WHERE nick='T|na'),
1037 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1041 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1043 (SELECT player FROM players WHERE nick='T|na'),
1045 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1048 INSERT INTO groups (tournament, round, parallel) VALUES (
1049 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1051 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1052 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1054 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
1056 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1059 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
1061 UPDATE rounds SET randomsongs=2 WHERE
1062 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1064 UPDATE rounds SET chosensongs=1 WHERE
1065 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1067 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
1068 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1071 (SELECT player FROM players WHERE nick='Ozon'),
1074 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1077 (SELECT player FROM players WHERE nick='Ozon'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1082 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1083 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1085 (SELECT player FROM players WHERE nick='Ozon'),
1087 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1090 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1091 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1093 (SELECT player FROM players WHERE nick='Ozon'),
1095 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1098 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
1099 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1100 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1102 (SELECT player FROM players WHERE nick='Hyper'),
1105 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1106 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1108 (SELECT player FROM players WHERE nick='Hyper'),
1110 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1114 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1116 (SELECT player FROM players WHERE nick='Hyper'),
1118 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1122 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1124 (SELECT player FROM players WHERE nick='Hyper'),
1126 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1129 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1131 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1133 (SELECT player FROM players WHERE nick='Nameless'),
1136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1137 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1139 (SELECT player FROM players WHERE nick='Nameless'),
1141 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1145 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1147 (SELECT player FROM players WHERE nick='Nameless'),
1149 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1153 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1155 (SELECT player FROM players WHERE nick='Nameless'),
1157 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1160 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1164 (SELECT player FROM players WHERE nick='Daniil'),
1167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1168 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1170 (SELECT player FROM players WHERE nick='Daniil'),
1172 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1178 (SELECT player FROM players WHERE nick='Daniil'),
1180 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1183 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1186 (SELECT player FROM players WHERE nick='Daniil'),
1188 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1191 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1193 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1195 (SELECT player FROM players WHERE nick='Oliyzia'),
1198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1199 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1201 (SELECT player FROM players WHERE nick='Oliyzia'),
1203 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1207 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1209 (SELECT player FROM players WHERE nick='Oliyzia'),
1211 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1215 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1217 (SELECT player FROM players WHERE nick='Oliyzia'),
1219 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
1223 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1224 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1226 (SELECT player FROM players WHERE nick='Stream'),
1229 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1230 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1232 (SELECT player FROM players WHERE nick='Stream'),
1234 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
1237 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1238 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1240 (SELECT player FROM players WHERE nick='Stream'),
1242 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1245 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1246 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1248 (SELECT player FROM players WHERE nick='Stream'),
1250 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1253 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1255 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1258 INSERT INTO groups (tournament, round, parallel) VALUES (
1259 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1261 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1262 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1264 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1266 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1267 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1269 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
1271 UPDATE rounds SET randomsongs=2 WHERE
1272 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1274 UPDATE rounds SET chosensongs=1 WHERE
1275 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1277 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
1278 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1281 (SELECT player FROM players WHERE nick='Olemann'),
1284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1287 (SELECT player FROM players WHERE nick='Olemann'),
1289 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1292 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1293 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1295 (SELECT player FROM players WHERE nick='Olemann'),
1297 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1301 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1303 (SELECT player FROM players WHERE nick='Olemann'),
1305 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1308 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
1309 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1310 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1312 (SELECT player FROM players WHERE nick='T|na'),
1315 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1316 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1318 (SELECT player FROM players WHERE nick='T|na'),
1320 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1323 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1324 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1326 (SELECT player FROM players WHERE nick='T|na'),
1328 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1334 (SELECT player FROM players WHERE nick='T|na'),
1336 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1339 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
1340 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1341 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1343 (SELECT player FROM players WHERE nick='Oliyzia'),
1346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1347 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1349 (SELECT player FROM players WHERE nick='Oliyzia'),
1351 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1355 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1357 (SELECT player FROM players WHERE nick='Oliyzia'),
1359 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1362 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1363 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1365 (SELECT player FROM players WHERE nick='Oliyzia'),
1367 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1370 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
1371 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1372 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1374 (SELECT player FROM players WHERE nick='Snofox'),
1377 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1378 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1380 (SELECT player FROM players WHERE nick='Snofox'),
1382 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1388 (SELECT player FROM players WHERE nick='Snofox'),
1390 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1394 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1396 (SELECT player FROM players WHERE nick='Snofox'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1401 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1402 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1403 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1405 (SELECT player FROM players WHERE nick='Tom'),
1408 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1409 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1411 (SELECT player FROM players WHERE nick='Tom'),
1413 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1416 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1417 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1419 (SELECT player FROM players WHERE nick='Tom'),
1421 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1424 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1425 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1427 (SELECT player FROM players WHERE nick='Tom'),
1429 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1432 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
1433 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1436 (SELECT player FROM players WHERE nick='Snute'),
1439 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1442 (SELECT player FROM players WHERE nick='Snute'),
1444 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1447 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1450 (SELECT player FROM players WHERE nick='Snute'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
1455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1458 (SELECT player FROM players WHERE nick='Snute'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1463 INSERT INTO groups (tournament, round, parallel) VALUES (
1464 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1466 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1467 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1469 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
1471 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1472 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1474 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
1476 UPDATE rounds SET randomsongs=2 WHERE
1477 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1479 UPDATE rounds SET chosensongs=1 WHERE
1480 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1482 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
1483 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1486 (SELECT player FROM players WHERE nick='Duckling'),
1489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1490 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1492 (SELECT player FROM players WHERE nick='Duckling'),
1494 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1498 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1500 (SELECT player FROM players WHERE nick='Duckling'),
1502 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1505 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1506 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1508 (SELECT player FROM players WHERE nick='Duckling'),
1510 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1513 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
1514 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1515 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1517 (SELECT player FROM players WHERE nick='Daniil'),
1520 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1521 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1523 (SELECT player FROM players WHERE nick='Daniil'),
1525 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1528 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1529 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1531 (SELECT player FROM players WHERE nick='Daniil'),
1533 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1536 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1537 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1539 (SELECT player FROM players WHERE nick='Daniil'),
1541 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1544 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
1545 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1546 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1548 (SELECT player FROM players WHERE nick='Mulefisk'),
1551 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1552 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1554 (SELECT player FROM players WHERE nick='Mulefisk'),
1556 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1560 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1562 (SELECT player FROM players WHERE nick='Mulefisk'),
1564 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1570 (SELECT player FROM players WHERE nick='Mulefisk'),
1572 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1575 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
1576 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1577 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1579 (SELECT player FROM players WHERE nick='Haggar'),
1582 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1583 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1585 (SELECT player FROM players WHERE nick='Haggar'),
1587 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1590 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1593 (SELECT player FROM players WHERE nick='Haggar'),
1595 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1599 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1601 (SELECT player FROM players WHERE nick='Haggar'),
1603 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
1606 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1607 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1608 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1610 (SELECT player FROM players WHERE nick='Nameless'),
1613 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1614 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1616 (SELECT player FROM players WHERE nick='Nameless'),
1618 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1622 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1624 (SELECT player FROM players WHERE nick='Nameless'),
1626 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1630 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1632 (SELECT player FROM players WHERE nick='Nameless'),
1634 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1637 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1641 (SELECT player FROM players WHERE nick='OJK'),
1644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1645 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1647 (SELECT player FROM players WHERE nick='OJK'),
1649 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1653 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1655 (SELECT player FROM players WHERE nick='OJK'),
1657 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
1660 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1661 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1663 (SELECT player FROM players WHERE nick='OJK'),
1665 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1668 INSERT INTO groups (tournament, round, parallel) VALUES (
1669 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1671 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1672 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1674 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1676 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1677 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1679 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1681 UPDATE rounds SET randomsongs=2 WHERE
1682 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1684 UPDATE rounds SET chosensongs=1 WHERE
1685 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1687 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tassen' AS nick WHERE 'Tassen' NOT IN ( SELECT nick FROM players );
1688 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1689 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1691 (SELECT player FROM players WHERE nick='Tassen'),
1694 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1695 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1697 (SELECT player FROM players WHERE nick='Tassen'),
1699 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1702 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1703 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1705 (SELECT player FROM players WHERE nick='Tassen'),
1707 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1711 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1713 (SELECT player FROM players WHERE nick='Tassen'),
1715 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1718 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
1719 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1720 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1722 (SELECT player FROM players WHERE nick='Ylini'),
1725 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1726 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1728 (SELECT player FROM players WHERE nick='Ylini'),
1730 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1733 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1734 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1736 (SELECT player FROM players WHERE nick='Ylini'),
1738 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1741 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1742 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1744 (SELECT player FROM players WHERE nick='Ylini'),
1746 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1749 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1750 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1751 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1753 (SELECT player FROM players WHERE nick='Pingo'),
1756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1757 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1759 (SELECT player FROM players WHERE nick='Pingo'),
1761 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1764 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1765 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1767 (SELECT player FROM players WHERE nick='Pingo'),
1769 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1772 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1773 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1775 (SELECT player FROM players WHERE nick='Pingo'),
1777 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1780 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
1781 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1782 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1784 (SELECT player FROM players WHERE nick='Gogo'),
1787 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1788 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1790 (SELECT player FROM players WHERE nick='Gogo'),
1792 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1795 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1796 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1798 (SELECT player FROM players WHERE nick='Gogo'),
1800 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1803 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1804 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1806 (SELECT player FROM players WHERE nick='Gogo'),
1808 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1811 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1812 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1813 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1815 (SELECT player FROM players WHERE nick='RiChY'),
1818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1819 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1821 (SELECT player FROM players WHERE nick='RiChY'),
1823 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1826 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1827 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1829 (SELECT player FROM players WHERE nick='RiChY'),
1831 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1835 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1837 (SELECT player FROM players WHERE nick='RiChY'),
1839 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1842 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
1843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1844 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1846 (SELECT player FROM players WHERE nick='DufF'),
1849 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1850 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1852 (SELECT player FROM players WHERE nick='DufF'),
1854 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1858 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1860 (SELECT player FROM players WHERE nick='DufF'),
1862 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1866 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1868 (SELECT player FROM players WHERE nick='DufF'),
1870 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1873 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1875 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1878 INSERT INTO groups (tournament, round, parallel) VALUES (
1879 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1881 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1882 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1884 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\''))
1886 UPDATE rounds SET randomsongs=1 WHERE
1887 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1889 UPDATE rounds SET chosensongs=1 WHERE
1890 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
1892 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
1893 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1894 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1896 (SELECT player FROM players WHERE nick='OJK'),
1899 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1900 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1902 (SELECT player FROM players WHERE nick='OJK'),
1904 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1907 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1908 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1910 (SELECT player FROM players WHERE nick='OJK'),
1912 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1915 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
1916 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1917 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1919 (SELECT player FROM players WHERE nick='Pingo'),
1922 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1923 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1925 (SELECT player FROM players WHERE nick='Pingo'),
1927 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1931 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1933 (SELECT player FROM players WHERE nick='Pingo'),
1935 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1938 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
1939 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1940 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1942 (SELECT player FROM players WHERE nick='Tom'),
1945 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1946 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1948 (SELECT player FROM players WHERE nick='Tom'),
1950 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1953 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1954 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1956 (SELECT player FROM players WHERE nick='Tom'),
1958 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1961 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
1962 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1963 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1965 (SELECT player FROM players WHERE nick='Nameless'),
1968 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1969 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1971 (SELECT player FROM players WHERE nick='Nameless'),
1973 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1976 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1977 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1979 (SELECT player FROM players WHERE nick='Nameless'),
1981 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1984 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
1985 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1986 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1988 (SELECT player FROM players WHERE nick='RiChY'),
1991 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1992 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
1994 (SELECT player FROM players WHERE nick='RiChY'),
1996 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
1999 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2000 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2002 (SELECT player FROM players WHERE nick='RiChY'),
2004 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
2007 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2008 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2009 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2011 (SELECT player FROM players WHERE nick='Snofox'),
2014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2015 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2017 (SELECT player FROM players WHERE nick='Snofox'),
2019 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
2022 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2023 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2025 (SELECT player FROM players WHERE nick='Snofox'),
2027 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2030 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2031 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2032 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2034 (SELECT player FROM players WHERE nick='Haggar'),
2037 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2038 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2040 (SELECT player FROM players WHERE nick='Haggar'),
2042 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
2045 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2046 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2048 (SELECT player FROM players WHERE nick='Haggar'),
2050 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2053 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2054 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2055 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2057 (SELECT player FROM players WHERE nick='Snute'),
2060 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2061 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2063 (SELECT player FROM players WHERE nick='Snute'),
2065 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
2068 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2069 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2071 (SELECT player FROM players WHERE nick='Snute'),
2073 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2076 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2077 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2080 (SELECT player FROM players WHERE nick='DufF'),
2083 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2084 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2086 (SELECT player FROM players WHERE nick='DufF'),
2088 (SELECT song FROM songs WHERE lower(title)=lower('Love This Feelin\'')),
2091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2092 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2094 (SELECT player FROM players WHERE nick='DufF'),
2096 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2099 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2101 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2104 INSERT INTO groups (tournament, round, parallel) VALUES (
2105 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2107 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2108 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2110 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
2112 UPDATE rounds SET randomsongs=1 WHERE
2113 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2115 UPDATE rounds SET chosensongs=1 WHERE
2116 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2118 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2119 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2120 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2122 (SELECT player FROM players WHERE nick='Haggar'),
2125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2126 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2128 (SELECT player FROM players WHERE nick='Haggar'),
2130 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2133 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2134 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2136 (SELECT player FROM players WHERE nick='Haggar'),
2138 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2141 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
2142 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2143 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2145 (SELECT player FROM players WHERE nick='Snofox'),
2148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2149 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2151 (SELECT player FROM players WHERE nick='Snofox'),
2153 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2156 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2157 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2159 (SELECT player FROM players WHERE nick='Snofox'),
2161 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2164 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2165 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2166 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2168 (SELECT player FROM players WHERE nick='RiChY'),
2171 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2172 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2174 (SELECT player FROM players WHERE nick='RiChY'),
2176 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2179 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2180 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2182 (SELECT player FROM players WHERE nick='RiChY'),
2184 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2187 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2188 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2189 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2191 (SELECT player FROM players WHERE nick='Nameless'),
2194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2195 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2197 (SELECT player FROM players WHERE nick='Nameless'),
2199 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2203 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2205 (SELECT player FROM players WHERE nick='Nameless'),
2207 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2212 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2214 (SELECT player FROM players WHERE nick='Snute'),
2217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2218 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2220 (SELECT player FROM players WHERE nick='Snute'),
2222 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2226 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2228 (SELECT player FROM players WHERE nick='Snute'),
2230 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2233 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2234 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2235 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2237 (SELECT player FROM players WHERE nick='DufF'),
2240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2241 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2243 (SELECT player FROM players WHERE nick='DufF'),
2245 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2249 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2251 (SELECT player FROM players WHERE nick='DufF'),
2253 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2256 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
2257 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2258 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2260 (SELECT player FROM players WHERE nick='OJK'),
2263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2264 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2266 (SELECT player FROM players WHERE nick='OJK'),
2268 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
2271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2272 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2274 (SELECT player FROM players WHERE nick='OJK'),
2276 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2279 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2281 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2284 INSERT INTO groups (tournament, round, parallel) VALUES (
2285 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2287 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2288 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2290 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2292 UPDATE rounds SET randomsongs=1 WHERE
2293 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2295 UPDATE rounds SET chosensongs=1 WHERE
2296 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2298 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
2299 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2300 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2302 (SELECT player FROM players WHERE nick='Nameless'),
2305 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2306 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2308 (SELECT player FROM players WHERE nick='Nameless'),
2310 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2313 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2314 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2316 (SELECT player FROM players WHERE nick='Nameless'),
2318 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2321 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2322 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2323 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2325 (SELECT player FROM players WHERE nick='RiChY'),
2328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2329 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2331 (SELECT player FROM players WHERE nick='RiChY'),
2333 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2336 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2337 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2339 (SELECT player FROM players WHERE nick='RiChY'),
2341 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2344 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2345 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2346 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2348 (SELECT player FROM players WHERE nick='Haggar'),
2351 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2352 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2354 (SELECT player FROM players WHERE nick='Haggar'),
2356 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2359 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2360 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2362 (SELECT player FROM players WHERE nick='Haggar'),
2364 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2367 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2368 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2369 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2371 (SELECT player FROM players WHERE nick='Snute'),
2374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2375 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2377 (SELECT player FROM players WHERE nick='Snute'),
2379 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2382 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2383 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2385 (SELECT player FROM players WHERE nick='Snute'),
2387 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2390 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2392 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2394 (SELECT player FROM players WHERE nick='DufF'),
2397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2398 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2400 (SELECT player FROM players WHERE nick='DufF'),
2402 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2406 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2408 (SELECT player FROM players WHERE nick='DufF'),
2410 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2413 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2415 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2418 INSERT INTO groups (tournament, round, parallel) VALUES (
2419 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2421 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2422 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2424 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
2426 UPDATE rounds SET randomsongs=1 WHERE
2427 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2429 UPDATE rounds SET chosensongs=1 WHERE
2430 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2432 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2433 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2434 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2436 (SELECT player FROM players WHERE nick='RiChY'),
2439 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2440 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2442 (SELECT player FROM players WHERE nick='RiChY'),
2444 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2447 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2448 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2450 (SELECT player FROM players WHERE nick='RiChY'),
2452 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2455 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
2456 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2457 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2459 (SELECT player FROM players WHERE nick='Haggar'),
2462 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2463 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2465 (SELECT player FROM players WHERE nick='Haggar'),
2467 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2471 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2473 (SELECT player FROM players WHERE nick='Haggar'),
2475 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2478 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2479 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2480 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2482 (SELECT player FROM players WHERE nick='DufF'),
2485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2486 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2488 (SELECT player FROM players WHERE nick='DufF'),
2490 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2494 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2496 (SELECT player FROM players WHERE nick='DufF'),
2498 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2501 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2502 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2503 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2505 (SELECT player FROM players WHERE nick='Snute'),
2508 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2509 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2511 (SELECT player FROM players WHERE nick='Snute'),
2513 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
2516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2517 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2519 (SELECT player FROM players WHERE nick='Snute'),
2521 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2524 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2526 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2529 INSERT INTO groups (tournament, round, parallel) VALUES (
2530 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2532 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2533 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2535 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
2537 UPDATE rounds SET randomsongs=1 WHERE
2538 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2540 UPDATE rounds SET chosensongs=1 WHERE
2541 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2543 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
2544 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2545 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2547 (SELECT player FROM players WHERE nick='RiChY'),
2550 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2551 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2553 (SELECT player FROM players WHERE nick='RiChY'),
2555 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2559 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2561 (SELECT player FROM players WHERE nick='RiChY'),
2563 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2566 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2568 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2570 (SELECT player FROM players WHERE nick='DufF'),
2573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2574 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2576 (SELECT player FROM players WHERE nick='DufF'),
2578 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2582 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2584 (SELECT player FROM players WHERE nick='DufF'),
2586 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2589 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2591 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2593 (SELECT player FROM players WHERE nick='Snute'),
2596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2597 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2599 (SELECT player FROM players WHERE nick='Snute'),
2601 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
2604 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2605 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2607 (SELECT player FROM players WHERE nick='Snute'),
2609 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2612 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2614 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2617 INSERT INTO groups (tournament, round, parallel) VALUES (
2618 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2620 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2621 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2623 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
2625 UPDATE rounds SET randomsongs=1 WHERE
2626 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2628 UPDATE rounds SET chosensongs=1 WHERE
2629 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND
2631 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
2632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2633 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2635 (SELECT player FROM players WHERE nick='Snute'),
2638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2639 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2641 (SELECT player FROM players WHERE nick='Snute'),
2643 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2646 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2647 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2649 (SELECT player FROM players WHERE nick='Snute'),
2651 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2654 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
2655 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2656 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2658 (SELECT player FROM players WHERE nick='DufF'),
2661 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2662 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2664 (SELECT player FROM players WHERE nick='DufF'),
2666 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2670 (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
2672 (SELECT player FROM players WHERE nick='DufF'),
2674 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),