2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Beginner' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
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 players SELECT nextval('players_player_seq') AS player, 'Morbuz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Morbuz' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
16 (SELECT player FROM players WHERE nick='Morbuz'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Koala_Man' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Koala_Man' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
22 (SELECT player FROM players WHERE nick='Koala_Man'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Knuta' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Knuta' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
28 (SELECT player FROM players WHERE nick='Knuta'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Danner' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Danner' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
34 (SELECT player FROM players WHERE nick='Danner'),
36 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
38 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
41 INSERT INTO groups (tournament, round, parallel) VALUES (
42 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
44 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
45 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
47 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
49 UPDATE rounds SET randomsongs=1 WHERE
50 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
52 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
53 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
55 (SELECT player FROM players WHERE nick='Koala_Man'),
58 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
59 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
61 (SELECT player FROM players WHERE nick='Koala_Man'),
63 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
66 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
67 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
69 (SELECT player FROM players WHERE nick='Morbuz'),
72 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
73 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
75 (SELECT player FROM players WHERE nick='Morbuz'),
77 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
80 INSERT INTO groups (tournament, round, parallel) VALUES (
81 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
83 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
84 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
86 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
88 UPDATE rounds SET randomsongs=1 WHERE
89 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
91 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
94 (SELECT player FROM players WHERE nick='Knuta'),
97 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
100 (SELECT player FROM players WHERE nick='Knuta'),
102 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
105 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
108 (SELECT player FROM players WHERE nick='Danner'),
111 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
112 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
114 (SELECT player FROM players WHERE nick='Danner'),
116 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
119 INSERT INTO groups (tournament, round, parallel) VALUES (
120 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
122 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
125 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
127 UPDATE rounds SET randomsongs=1 WHERE
128 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
133 (SELECT player FROM players WHERE nick='Danner'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
139 (SELECT player FROM players WHERE nick='Danner'),
141 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
144 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
147 (SELECT player FROM players WHERE nick='Morbuz'),
150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
151 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
153 (SELECT player FROM players WHERE nick='Morbuz'),
155 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
158 INSERT INTO groups (tournament, round, parallel) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
161 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
162 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
164 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
166 UPDATE rounds SET randomsongs=1 WHERE
167 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
169 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
172 (SELECT player FROM players WHERE nick='Knuta'),
175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
178 (SELECT player FROM players WHERE nick='Knuta'),
180 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
183 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
184 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
186 (SELECT player FROM players WHERE nick='Koala_Man'),
189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
190 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
192 (SELECT player FROM players WHERE nick='Koala_Man'),
194 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
197 INSERT INTO groups (tournament, round, parallel) VALUES (
198 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
200 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
203 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
205 UPDATE rounds SET randomsongs=1 WHERE
206 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
208 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
209 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
211 (SELECT player FROM players WHERE nick='Knuta'),
214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
215 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
217 (SELECT player FROM players WHERE nick='Knuta'),
219 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
222 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
225 (SELECT player FROM players WHERE nick='Morbuz'),
228 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
231 (SELECT player FROM players WHERE nick='Morbuz'),
233 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
236 INSERT INTO groups (tournament, round, parallel) VALUES (
237 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
239 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
240 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
242 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
244 UPDATE rounds SET randomsongs=1 WHERE
245 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
247 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
248 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
250 (SELECT player FROM players WHERE nick='Koala_Man'),
253 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
254 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
256 (SELECT player FROM players WHERE nick='Koala_Man'),
258 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
261 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
262 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
264 (SELECT player FROM players WHERE nick='Danner'),
267 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
268 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
270 (SELECT player FROM players WHERE nick='Danner'),
272 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
275 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
277 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
280 INSERT INTO groups (tournament, round, parallel) VALUES (
281 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
283 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
284 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
286 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
288 UPDATE rounds SET randomsongs=1 WHERE
289 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
291 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
292 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
294 (SELECT player FROM players WHERE nick='Koala_Man'),
297 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
298 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
300 (SELECT player FROM players WHERE nick='Koala_Man'),
302 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
305 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
306 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
308 (SELECT player FROM players WHERE nick='Morbuz'),
311 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
312 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
314 (SELECT player FROM players WHERE nick='Morbuz'),
316 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
319 INSERT INTO groups (tournament, round, parallel) VALUES (
320 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
322 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
323 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
325 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
327 UPDATE rounds SET randomsongs=1 WHERE
328 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
330 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
331 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
333 (SELECT player FROM players WHERE nick='Knuta'),
336 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
339 (SELECT player FROM players WHERE nick='Knuta'),
341 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
344 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
347 (SELECT player FROM players WHERE nick='Danner'),
350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
353 (SELECT player FROM players WHERE nick='Danner'),
355 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
358 INSERT INTO groups (tournament, round, parallel) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
361 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
362 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
364 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
366 UPDATE rounds SET randomsongs=1 WHERE
367 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
369 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
370 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
372 (SELECT player FROM players WHERE nick='Danner'),
375 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
376 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
378 (SELECT player FROM players WHERE nick='Danner'),
380 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
384 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
386 (SELECT player FROM players WHERE nick='Morbuz'),
389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
392 (SELECT player FROM players WHERE nick='Morbuz'),
394 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
397 INSERT INTO groups (tournament, round, parallel) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
400 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
401 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
403 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
405 UPDATE rounds SET randomsongs=1 WHERE
406 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
408 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
409 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
411 (SELECT player FROM players WHERE nick='Knuta'),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
417 (SELECT player FROM players WHERE nick='Knuta'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
422 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
425 (SELECT player FROM players WHERE nick='Koala_Man'),
428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
431 (SELECT player FROM players WHERE nick='Koala_Man'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
436 INSERT INTO groups (tournament, round, parallel) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
439 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
442 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
444 UPDATE rounds SET randomsongs=1 WHERE
445 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
447 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
448 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
450 (SELECT player FROM players WHERE nick='Knuta'),
453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
454 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
456 (SELECT player FROM players WHERE nick='Knuta'),
458 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
461 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
462 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
464 (SELECT player FROM players WHERE nick='Morbuz'),
467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
470 (SELECT player FROM players WHERE nick='Morbuz'),
472 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
475 INSERT INTO groups (tournament, round, parallel) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
478 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
481 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
483 UPDATE rounds SET randomsongs=1 WHERE
484 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
486 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
487 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
489 (SELECT player FROM players WHERE nick='Koala_Man'),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
495 (SELECT player FROM players WHERE nick='Koala_Man'),
497 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
500 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
503 (SELECT player FROM players WHERE nick='Danner'),
506 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
507 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
509 (SELECT player FROM players WHERE nick='Danner'),
511 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
514 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
516 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
519 INSERT INTO groups (tournament, round, parallel) VALUES (
520 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
522 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
523 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
525 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
527 UPDATE rounds SET randomsongs=1 WHERE
528 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )) AND
530 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
531 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
533 (SELECT player FROM players WHERE nick='Koala_Man'),
536 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
537 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
539 (SELECT player FROM players WHERE nick='Koala_Man'),
541 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
544 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
545 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
547 (SELECT player FROM players WHERE nick='Morbuz'),
550 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
551 (SELECT tournament FROM tournaments WHERE tournamentname='Trondheimsturnering' AND season=( SELECT season FROM seasons WHERE seasonname='Beginner' )),
553 (SELECT player FROM players WHERE nick='Morbuz'),
555 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),