2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6 (SELECT country FROM countries WHERE countryname='Norway'),
7 'Tønsberg - Sjøsenteret bowling',
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, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16 (SELECT player FROM players WHERE nick='OJK'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
22 (SELECT player FROM players WHERE nick='T|na'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
28 (SELECT player FROM players WHERE nick='Pfxp'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
34 (SELECT player FROM players WHERE nick='Jallaman'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'erikTman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'erikTman' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
40 (SELECT player FROM players WHERE nick='erikTman'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Benny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Benny' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
46 (SELECT player FROM players WHERE nick='Benny'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nypd' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nypd' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
52 (SELECT player FROM players WHERE nick='Nypd'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'msichana' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'msichana' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
58 (SELECT player FROM players WHERE nick='msichana'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nelly' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nelly' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
64 (SELECT player FROM players WHERE nick='Nelly'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tomi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tomi' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
70 (SELECT player FROM players WHERE nick='Tomi'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Annkakris' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
76 (SELECT player FROM players WHERE nick='Annkakris'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Henrik' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Henrik' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
82 (SELECT player FROM players WHERE nick='Henrik'),
84 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
86 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
89 INSERT INTO groups (tournament, round, parallel) VALUES (
90 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
92 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
93 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
95 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
97 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
100 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
102 UPDATE rounds SET randomsongs=2 WHERE
103 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
105 UPDATE rounds SET chosensongs=1 WHERE
106 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
111 (SELECT player FROM players WHERE nick='Nelly'),
114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
117 (SELECT player FROM players WHERE nick='Nelly'),
119 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
125 (SELECT player FROM players WHERE nick='Nelly'),
127 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
133 (SELECT player FROM players WHERE nick='Nelly'),
135 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
138 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
139 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
141 (SELECT player FROM players WHERE nick='Henrik'),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
147 (SELECT player FROM players WHERE nick='Henrik'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
152 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
155 (SELECT player FROM players WHERE nick='Henrik'),
157 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
161 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
163 (SELECT player FROM players WHERE nick='Henrik'),
165 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
169 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
171 (SELECT player FROM players WHERE nick='Jallaman'),
174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
177 (SELECT player FROM players WHERE nick='Jallaman'),
179 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
185 (SELECT player FROM players WHERE nick='Jallaman'),
187 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
191 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
193 (SELECT player FROM players WHERE nick='Jallaman'),
195 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
201 (SELECT player FROM players WHERE nick='msichana'),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
207 (SELECT player FROM players WHERE nick='msichana'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
215 (SELECT player FROM players WHERE nick='msichana'),
217 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
221 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
223 (SELECT player FROM players WHERE nick='msichana'),
225 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
228 INSERT INTO groups (tournament, round, parallel) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
231 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
232 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
234 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
236 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
237 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
239 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
241 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
242 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
244 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
246 UPDATE rounds SET randomsongs=3 WHERE
247 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
249 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
250 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
252 (SELECT player FROM players WHERE nick='Pfxp'),
255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
256 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
258 (SELECT player FROM players WHERE nick='Pfxp'),
260 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
264 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
266 (SELECT player FROM players WHERE nick='Pfxp'),
268 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
274 (SELECT player FROM players WHERE nick='Pfxp'),
276 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
279 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
280 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
282 (SELECT player FROM players WHERE nick='Annkakris'),
285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
286 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
288 (SELECT player FROM players WHERE nick='Annkakris'),
290 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
294 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
296 (SELECT player FROM players WHERE nick='Annkakris'),
298 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
302 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
304 (SELECT player FROM players WHERE nick='Annkakris'),
306 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
309 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
310 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
312 (SELECT player FROM players WHERE nick='erikTman'),
315 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
316 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
318 (SELECT player FROM players WHERE nick='erikTman'),
320 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
323 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
324 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
326 (SELECT player FROM players WHERE nick='erikTman'),
328 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
332 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
334 (SELECT player FROM players WHERE nick='erikTman'),
336 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
339 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
340 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
342 (SELECT player FROM players WHERE nick='T|na'),
345 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
346 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
348 (SELECT player FROM players WHERE nick='T|na'),
350 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
353 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
354 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
356 (SELECT player FROM players WHERE nick='T|na'),
358 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
361 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
362 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
364 (SELECT player FROM players WHERE nick='T|na'),
366 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
369 INSERT INTO groups (tournament, round, parallel) VALUES (
370 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
372 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
373 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
375 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
377 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
378 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
380 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
382 UPDATE rounds SET randomsongs=2 WHERE
383 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
385 UPDATE rounds SET chosensongs=1 WHERE
386 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
388 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
391 (SELECT player FROM players WHERE nick='Tomi'),
394 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
395 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
397 (SELECT player FROM players WHERE nick='Tomi'),
399 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
403 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
405 (SELECT player FROM players WHERE nick='Tomi'),
407 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
411 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
413 (SELECT player FROM players WHERE nick='Tomi'),
415 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
418 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
419 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
421 (SELECT player FROM players WHERE nick='OJK'),
424 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
425 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
427 (SELECT player FROM players WHERE nick='OJK'),
429 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
432 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
433 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
435 (SELECT player FROM players WHERE nick='OJK'),
437 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
443 (SELECT player FROM players WHERE nick='OJK'),
445 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
448 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
451 (SELECT player FROM players WHERE nick='Nypd'),
454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
455 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
457 (SELECT player FROM players WHERE nick='Nypd'),
459 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
462 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
463 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
465 (SELECT player FROM players WHERE nick='Nypd'),
467 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
473 (SELECT player FROM players WHERE nick='Nypd'),
475 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
481 (SELECT player FROM players WHERE nick='Benny'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
487 (SELECT player FROM players WHERE nick='Benny'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
492 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
493 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
495 (SELECT player FROM players WHERE nick='Benny'),
497 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
503 (SELECT player FROM players WHERE nick='Benny'),
505 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
508 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
510 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
513 INSERT INTO groups (tournament, round, parallel) VALUES (
514 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
516 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
517 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
519 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
521 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
522 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
524 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
526 UPDATE rounds SET randomsongs=2 WHERE
527 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
529 UPDATE rounds SET chosensongs=1 WHERE
530 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
532 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
535 (SELECT player FROM players WHERE nick='Benny'),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
541 (SELECT player FROM players WHERE nick='Benny'),
543 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
549 (SELECT player FROM players WHERE nick='Benny'),
551 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
557 (SELECT player FROM players WHERE nick='Benny'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
562 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
565 (SELECT player FROM players WHERE nick='T|na'),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
571 (SELECT player FROM players WHERE nick='T|na'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
579 (SELECT player FROM players WHERE nick='T|na'),
581 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
587 (SELECT player FROM players WHERE nick='T|na'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
592 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
595 (SELECT player FROM players WHERE nick='msichana'),
598 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
601 (SELECT player FROM players WHERE nick='msichana'),
603 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
609 (SELECT player FROM players WHERE nick='msichana'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
617 (SELECT player FROM players WHERE nick='msichana'),
619 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
622 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
625 (SELECT player FROM players WHERE nick='OJK'),
628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
631 (SELECT player FROM players WHERE nick='OJK'),
633 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
639 (SELECT player FROM players WHERE nick='OJK'),
641 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
647 (SELECT player FROM players WHERE nick='OJK'),
649 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
652 INSERT INTO groups (tournament, round, parallel) VALUES (
653 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
655 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
656 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
658 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
660 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
661 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
663 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
665 UPDATE rounds SET randomsongs=2 WHERE
666 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
668 UPDATE rounds SET chosensongs=1 WHERE
669 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
671 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
672 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
674 (SELECT player FROM players WHERE nick='Nypd'),
677 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
678 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
680 (SELECT player FROM players WHERE nick='Nypd'),
682 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
686 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
688 (SELECT player FROM players WHERE nick='Nypd'),
690 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
693 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
694 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
696 (SELECT player FROM players WHERE nick='Nypd'),
698 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
701 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
702 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
704 (SELECT player FROM players WHERE nick='Jallaman'),
707 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
710 (SELECT player FROM players WHERE nick='Jallaman'),
712 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
715 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
716 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
718 (SELECT player FROM players WHERE nick='Jallaman'),
720 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
726 (SELECT player FROM players WHERE nick='Jallaman'),
728 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
731 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
732 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
734 (SELECT player FROM players WHERE nick='erikTman'),
737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
740 (SELECT player FROM players WHERE nick='erikTman'),
742 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
748 (SELECT player FROM players WHERE nick='erikTman'),
750 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
753 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
756 (SELECT player FROM players WHERE nick='erikTman'),
758 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
761 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
762 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
764 (SELECT player FROM players WHERE nick='Pfxp'),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
770 (SELECT player FROM players WHERE nick='Pfxp'),
772 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
778 (SELECT player FROM players WHERE nick='Pfxp'),
780 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
786 (SELECT player FROM players WHERE nick='Pfxp'),
788 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
791 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
793 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
796 INSERT INTO groups (tournament, round, parallel) VALUES (
797 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
799 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
800 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
802 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
804 UPDATE rounds SET randomsongs=1 WHERE
805 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
807 UPDATE rounds SET chosensongs=1 WHERE
808 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
810 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
811 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
813 (SELECT player FROM players WHERE nick='Benny'),
816 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
817 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
819 (SELECT player FROM players WHERE nick='Benny'),
821 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
824 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
825 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
827 (SELECT player FROM players WHERE nick='Benny'),
829 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
832 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
833 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
835 (SELECT player FROM players WHERE nick='erikTman'),
838 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
839 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
841 (SELECT player FROM players WHERE nick='erikTman'),
843 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
847 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
849 (SELECT player FROM players WHERE nick='erikTman'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
855 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
857 (SELECT player FROM players WHERE nick='Jallaman'),
860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
863 (SELECT player FROM players WHERE nick='Jallaman'),
865 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
868 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
871 (SELECT player FROM players WHERE nick='Jallaman'),
873 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
876 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
879 (SELECT player FROM players WHERE nick='T|na'),
882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
885 (SELECT player FROM players WHERE nick='T|na'),
887 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
893 (SELECT player FROM players WHERE nick='T|na'),
895 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
901 (SELECT player FROM players WHERE nick='Pfxp'),
904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
907 (SELECT player FROM players WHERE nick='Pfxp'),
909 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
913 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
915 (SELECT player FROM players WHERE nick='Pfxp'),
917 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
923 (SELECT player FROM players WHERE nick='OJK'),
926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
927 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
929 (SELECT player FROM players WHERE nick='OJK'),
931 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
937 (SELECT player FROM players WHERE nick='OJK'),
939 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
942 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
944 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
947 INSERT INTO groups (tournament, round, parallel) VALUES (
948 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
950 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
953 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
955 UPDATE rounds SET randomsongs=1 WHERE
956 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
958 UPDATE rounds SET chosensongs=1 WHERE
959 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
961 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
962 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
964 (SELECT player FROM players WHERE nick='Jallaman'),
967 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
968 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
970 (SELECT player FROM players WHERE nick='Jallaman'),
972 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
975 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
976 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
978 (SELECT player FROM players WHERE nick='Jallaman'),
980 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
983 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
984 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
986 (SELECT player FROM players WHERE nick='erikTman'),
989 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
990 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
992 (SELECT player FROM players WHERE nick='erikTman'),
994 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
997 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
998 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1000 (SELECT player FROM players WHERE nick='erikTman'),
1002 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1005 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1006 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1008 (SELECT player FROM players WHERE nick='T|na'),
1011 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1012 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1014 (SELECT player FROM players WHERE nick='T|na'),
1016 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
1019 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1020 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1022 (SELECT player FROM players WHERE nick='T|na'),
1024 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1027 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1028 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1030 (SELECT player FROM players WHERE nick='Pfxp'),
1033 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1034 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1036 (SELECT player FROM players WHERE nick='Pfxp'),
1038 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
1041 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1042 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1044 (SELECT player FROM players WHERE nick='Pfxp'),
1046 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1049 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1050 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1052 (SELECT player FROM players WHERE nick='OJK'),
1055 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1056 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1058 (SELECT player FROM players WHERE nick='OJK'),
1060 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
1063 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1064 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1066 (SELECT player FROM players WHERE nick='OJK'),
1068 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1071 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1073 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1076 INSERT INTO groups (tournament, round, parallel) VALUES (
1077 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1079 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1080 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1082 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
1084 UPDATE rounds SET randomsongs=1 WHERE
1085 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1087 UPDATE rounds SET chosensongs=1 WHERE
1088 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1090 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1091 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1093 (SELECT player FROM players WHERE nick='Jallaman'),
1096 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1099 (SELECT player FROM players WHERE nick='Jallaman'),
1101 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1104 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1105 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1107 (SELECT player FROM players WHERE nick='Jallaman'),
1109 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1113 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1115 (SELECT player FROM players WHERE nick='T|na'),
1118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1121 (SELECT player FROM players WHERE nick='T|na'),
1123 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1129 (SELECT player FROM players WHERE nick='T|na'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1134 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1135 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1137 (SELECT player FROM players WHERE nick='Pfxp'),
1140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1143 (SELECT player FROM players WHERE nick='Pfxp'),
1145 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1149 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1151 (SELECT player FROM players WHERE nick='Pfxp'),
1153 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1156 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1157 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1159 (SELECT player FROM players WHERE nick='OJK'),
1162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1163 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1165 (SELECT player FROM players WHERE nick='OJK'),
1167 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1171 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1173 (SELECT player FROM players WHERE nick='OJK'),
1175 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1178 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1180 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1183 INSERT INTO groups (tournament, round, parallel) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1186 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1189 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
1191 UPDATE rounds SET randomsongs=1 WHERE
1192 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1194 UPDATE rounds SET chosensongs=1 WHERE
1195 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1198 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1200 (SELECT player FROM players WHERE nick='T|na'),
1203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1204 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1206 (SELECT player FROM players WHERE nick='T|na'),
1208 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1212 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1214 (SELECT player FROM players WHERE nick='T|na'),
1216 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1219 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1222 (SELECT player FROM players WHERE nick='Pfxp'),
1225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1226 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1228 (SELECT player FROM players WHERE nick='Pfxp'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1234 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1236 (SELECT player FROM players WHERE nick='Pfxp'),
1238 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1244 (SELECT player FROM players WHERE nick='OJK'),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1250 (SELECT player FROM players WHERE nick='OJK'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1258 (SELECT player FROM players WHERE nick='OJK'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1263 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1265 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1268 INSERT INTO groups (tournament, round, parallel) VALUES (
1269 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1271 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1274 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
1276 UPDATE rounds SET randomsongs=1 WHERE
1277 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1279 UPDATE rounds SET chosensongs=1 WHERE
1280 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1282 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1283 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1285 (SELECT player FROM players WHERE nick='OJK'),
1288 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1289 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1291 (SELECT player FROM players WHERE nick='OJK'),
1293 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1296 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1297 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1299 (SELECT player FROM players WHERE nick='OJK'),
1301 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1304 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1307 (SELECT player FROM players WHERE nick='T|na'),
1310 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1311 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1313 (SELECT player FROM players WHERE nick='T|na'),
1315 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1319 (SELECT tournament FROM tournaments WHERE tournamentname='Tønsberg Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1321 (SELECT player FROM players WHERE nick='T|na'),
1323 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),