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' )),
5 'Fredrikstad Turnering',
6 (SELECT country FROM countries WHERE countryname='Norway'),
7 'Fredrikstad Mestern 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, 'FantNo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'FantNo' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16 (SELECT player FROM players WHERE nick='FantNo'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
22 (SELECT player FROM players WHERE nick='Purity'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Freaky Mama=)' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Freaky Mama=)' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
28 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ViD' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
34 (SELECT player FROM players WHERE nick='ViD'),
36 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 );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
40 (SELECT player FROM players WHERE nick='Pfxp'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Naughty' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Naughty' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
46 (SELECT player FROM players WHERE nick='Naughty'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
52 (SELECT player FROM players WHERE nick='T|na'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
58 (SELECT player FROM players WHERE nick='Snofox'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
64 (SELECT player FROM players WHERE nick='x3mnrj'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sniff' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sniff' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
70 (SELECT player FROM players WHERE nick='Sniff'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DiJam' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DiJam' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
76 (SELECT player FROM players WHERE nick='DiJam'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
82 (SELECT player FROM players WHERE nick='erikTman'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
88 (SELECT player FROM players WHERE nick='Smiph'),
90 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 );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
94 (SELECT player FROM players WHERE nick='Jallaman'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Svimse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Svimse' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
100 (SELECT player FROM players WHERE nick='Svimse'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jannemor' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jannemor' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
106 (SELECT player FROM players WHERE nick='Jannemor'),
108 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 );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
112 (SELECT player FROM players WHERE nick='Nypd'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyanid' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyanid' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
118 (SELECT player FROM players WHERE nick='Cyanid'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Joachim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Joachim' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
124 (SELECT player FROM players WHERE nick='Joachim'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haz' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
130 (SELECT player FROM players WHERE nick='Haz'),
132 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
134 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
137 INSERT INTO groups (tournament, round, parallel) VALUES (
138 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
140 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
141 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
143 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
145 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
148 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
150 UPDATE rounds SET randomsongs=2 WHERE
151 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
153 UPDATE rounds SET chosensongs=1 WHERE
154 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
156 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
157 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
159 (SELECT player FROM players WHERE nick='T|na'),
162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
165 (SELECT player FROM players WHERE nick='T|na'),
167 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
170 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
173 (SELECT player FROM players WHERE nick='T|na'),
175 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
179 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
181 (SELECT player FROM players WHERE nick='T|na'),
183 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
186 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
189 (SELECT player FROM players WHERE nick='x3mnrj'),
192 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
195 (SELECT player FROM players WHERE nick='x3mnrj'),
197 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
203 (SELECT player FROM players WHERE nick='x3mnrj'),
205 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
209 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
211 (SELECT player FROM players WHERE nick='x3mnrj'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
216 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
219 (SELECT player FROM players WHERE nick='Nypd'),
222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
225 (SELECT player FROM players WHERE nick='Nypd'),
227 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
233 (SELECT player FROM players WHERE nick='Nypd'),
235 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
239 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
241 (SELECT player FROM players WHERE nick='Nypd'),
243 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
249 (SELECT player FROM players WHERE nick='Purity'),
252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
255 (SELECT player FROM players WHERE nick='Purity'),
257 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
263 (SELECT player FROM players WHERE nick='Purity'),
265 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
269 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
271 (SELECT player FROM players WHERE nick='Purity'),
273 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
279 (SELECT player FROM players WHERE nick='Smiph'),
282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
283 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
285 (SELECT player FROM players WHERE nick='Smiph'),
287 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
293 (SELECT player FROM players WHERE nick='Smiph'),
295 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
301 (SELECT player FROM players WHERE nick='Smiph'),
303 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
306 INSERT INTO groups (tournament, round, parallel) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
309 UPDATE rounds SET randomsongs=0 WHERE
310 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
312 UPDATE rounds SET chosensongs=1 WHERE
313 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
315 UPDATE rounds SET chosensongs=1 WHERE
316 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
318 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
321 (SELECT player FROM players WHERE nick='Cyanid'),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
327 (SELECT player FROM players WHERE nick='Cyanid'),
329 (SELECT song FROM songs WHERE lower(title)=lower('')),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
335 (SELECT player FROM players WHERE nick='Cyanid'),
337 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
341 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
343 (SELECT player FROM players WHERE nick='Cyanid'),
345 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
348 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
349 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
351 (SELECT player FROM players WHERE nick='DiJam'),
354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
357 (SELECT player FROM players WHERE nick='DiJam'),
359 (SELECT song FROM songs WHERE lower(title)=lower('')),
362 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
365 (SELECT player FROM players WHERE nick='DiJam'),
367 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
373 (SELECT player FROM players WHERE nick='DiJam'),
375 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
378 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
381 (SELECT player FROM players WHERE nick='Pfxp'),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
387 (SELECT player FROM players WHERE nick='Pfxp'),
389 (SELECT song FROM songs WHERE lower(title)=lower('')),
392 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
395 (SELECT player FROM players WHERE nick='Pfxp'),
397 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
400 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
401 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
403 (SELECT player FROM players WHERE nick='Pfxp'),
405 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
408 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
409 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
411 (SELECT player FROM players WHERE nick='ViD'),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
417 (SELECT player FROM players WHERE nick='ViD'),
419 (SELECT song FROM songs WHERE lower(title)=lower('')),
422 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
425 (SELECT player FROM players WHERE nick='ViD'),
427 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
433 (SELECT player FROM players WHERE nick='ViD'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
438 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
439 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
441 (SELECT player FROM players WHERE nick='Jannemor'),
444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
447 (SELECT player FROM players WHERE nick='Jannemor'),
449 (SELECT song FROM songs WHERE lower(title)=lower('')),
452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
455 (SELECT player FROM players WHERE nick='Jannemor'),
457 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
461 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
463 (SELECT player FROM players WHERE nick='Jannemor'),
465 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
468 INSERT INTO groups (tournament, round, parallel) VALUES (
469 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
471 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
472 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
474 (SELECT song FROM songs WHERE lower(title)=lower('20th November'))
476 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
479 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
481 UPDATE rounds SET randomsongs=2 WHERE
482 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
484 UPDATE rounds SET chosensongs=1 WHERE
485 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
487 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
488 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
490 (SELECT player FROM players WHERE nick='Jallaman'),
493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
494 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
496 (SELECT player FROM players WHERE nick='Jallaman'),
498 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
504 (SELECT player FROM players WHERE nick='Jallaman'),
506 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
512 (SELECT player FROM players WHERE nick='Jallaman'),
514 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
517 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
518 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
520 (SELECT player FROM players WHERE nick='erikTman'),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
526 (SELECT player FROM players WHERE nick='erikTman'),
528 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
534 (SELECT player FROM players WHERE nick='erikTman'),
536 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
539 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
540 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
542 (SELECT player FROM players WHERE nick='erikTman'),
544 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
547 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
548 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
550 (SELECT player FROM players WHERE nick='FantNo'),
553 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
554 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
556 (SELECT player FROM players WHERE nick='FantNo'),
558 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
561 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
562 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
564 (SELECT player FROM players WHERE nick='FantNo'),
566 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
569 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
570 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
572 (SELECT player FROM players WHERE nick='FantNo'),
574 (SELECT song FROM songs WHERE lower(title)=lower('Test My Best')),
577 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
578 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
580 (SELECT player FROM players WHERE nick='Sniff'),
583 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
586 (SELECT player FROM players WHERE nick='Sniff'),
588 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
591 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
592 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
594 (SELECT player FROM players WHERE nick='Sniff'),
596 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
599 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
600 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
602 (SELECT player FROM players WHERE nick='Sniff'),
604 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
607 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
608 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
610 (SELECT player FROM players WHERE nick='Haz'),
613 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
614 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
616 (SELECT player FROM players WHERE nick='Haz'),
618 (SELECT song FROM songs WHERE lower(title)=lower('20th November')),
621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
622 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
624 (SELECT player FROM players WHERE nick='Haz'),
626 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
630 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
632 (SELECT player FROM players WHERE nick='Haz'),
634 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
637 INSERT INTO groups (tournament, round, parallel) VALUES (
638 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
640 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
641 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
643 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
645 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
646 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
648 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
650 UPDATE rounds SET randomsongs=2 WHERE
651 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
653 UPDATE rounds SET chosensongs=1 WHERE
654 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
656 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
657 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
659 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
662 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
663 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
665 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
667 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
670 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
671 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
673 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
675 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
681 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
683 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
686 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
689 (SELECT player FROM players WHERE nick='Svimse'),
692 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
695 (SELECT player FROM players WHERE nick='Svimse'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
700 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
701 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
703 (SELECT player FROM players WHERE nick='Svimse'),
705 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
708 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
709 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
711 (SELECT player FROM players WHERE nick='Svimse'),
713 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
716 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
717 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
719 (SELECT player FROM players WHERE nick='Snofox'),
722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
725 (SELECT player FROM players WHERE nick='Snofox'),
727 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
730 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
731 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
733 (SELECT player FROM players WHERE nick='Snofox'),
735 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
738 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
739 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
741 (SELECT player FROM players WHERE nick='Snofox'),
743 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
746 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
747 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
749 (SELECT player FROM players WHERE nick='Naughty'),
752 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
753 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
755 (SELECT player FROM players WHERE nick='Naughty'),
757 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
760 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
761 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
763 (SELECT player FROM players WHERE nick='Naughty'),
765 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
768 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
769 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
771 (SELECT player FROM players WHERE nick='Naughty'),
773 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
776 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
779 (SELECT player FROM players WHERE nick='Joachim'),
782 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
783 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
785 (SELECT player FROM players WHERE nick='Joachim'),
787 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
793 (SELECT player FROM players WHERE nick='Joachim'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
799 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
801 (SELECT player FROM players WHERE nick='Joachim'),
803 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
806 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
808 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
811 INSERT INTO groups (tournament, round, parallel) VALUES (
812 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
814 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
815 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
817 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
819 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
822 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
824 UPDATE rounds SET randomsongs=2 WHERE
825 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
827 UPDATE rounds SET chosensongs=1 WHERE
828 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
830 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
831 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
833 (SELECT player FROM players WHERE nick='Purity'),
836 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
837 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
839 (SELECT player FROM players WHERE nick='Purity'),
841 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
845 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
847 (SELECT player FROM players WHERE nick='Purity'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
852 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
855 (SELECT player FROM players WHERE nick='Purity'),
857 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
860 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
863 (SELECT player FROM players WHERE nick='T|na'),
866 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
867 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
869 (SELECT player FROM players WHERE nick='T|na'),
871 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
875 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
877 (SELECT player FROM players WHERE nick='T|na'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
882 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
883 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad 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('Paranoia KCET (Clean Mix)')),
890 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
893 (SELECT player FROM players WHERE nick='x3mnrj'),
896 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
897 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
899 (SELECT player FROM players WHERE nick='x3mnrj'),
901 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
907 (SELECT player FROM players WHERE nick='x3mnrj'),
909 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
913 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
915 (SELECT player FROM players WHERE nick='x3mnrj'),
917 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
920 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
923 (SELECT player FROM players WHERE nick='ViD'),
926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
927 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
929 (SELECT player FROM players WHERE nick='ViD'),
931 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
937 (SELECT player FROM players WHERE nick='ViD'),
939 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
942 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
945 (SELECT player FROM players WHERE nick='ViD'),
947 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
953 (SELECT player FROM players WHERE nick='Pfxp'),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
959 (SELECT player FROM players WHERE nick='Pfxp'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
967 (SELECT player FROM players WHERE nick='Pfxp'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
975 (SELECT player FROM players WHERE nick='Pfxp'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
980 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
983 (SELECT player FROM players WHERE nick='DiJam'),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
989 (SELECT player FROM players WHERE nick='DiJam'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
997 (SELECT player FROM players WHERE nick='DiJam'),
999 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
1002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1005 (SELECT player FROM players WHERE nick='DiJam'),
1007 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1010 INSERT INTO groups (tournament, round, parallel) VALUES (
1011 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1013 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1014 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1016 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1018 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1021 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
1023 UPDATE rounds SET randomsongs=2 WHERE
1024 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1026 UPDATE rounds SET chosensongs=1 WHERE
1027 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1029 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1032 (SELECT player FROM players WHERE nick='FantNo'),
1035 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1036 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1038 (SELECT player FROM players WHERE nick='FantNo'),
1040 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1043 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1044 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1046 (SELECT player FROM players WHERE nick='FantNo'),
1048 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1051 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1054 (SELECT player FROM players WHERE nick='FantNo'),
1056 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1059 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1060 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1062 (SELECT player FROM players WHERE nick='Sniff'),
1065 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1068 (SELECT player FROM players WHERE nick='Sniff'),
1070 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1073 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1076 (SELECT player FROM players WHERE nick='Sniff'),
1078 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1081 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1082 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1084 (SELECT player FROM players WHERE nick='Sniff'),
1086 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1089 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1092 (SELECT player FROM players WHERE nick='erikTman'),
1095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1096 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1098 (SELECT player FROM players WHERE nick='erikTman'),
1100 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1104 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1106 (SELECT player FROM players WHERE nick='erikTman'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1111 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1112 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1114 (SELECT player FROM players WHERE nick='erikTman'),
1116 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1119 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1120 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1122 (SELECT player FROM players WHERE nick='Naughty'),
1125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1128 (SELECT player FROM players WHERE nick='Naughty'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1133 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1134 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1136 (SELECT player FROM players WHERE nick='Naughty'),
1138 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1141 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1142 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1144 (SELECT player FROM players WHERE nick='Naughty'),
1146 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1150 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1152 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1155 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1156 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1158 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1160 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1163 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1164 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1166 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1168 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1171 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1172 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1174 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1176 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1179 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1180 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1182 (SELECT player FROM players WHERE nick='Snofox'),
1185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1186 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1188 (SELECT player FROM players WHERE nick='Snofox'),
1190 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1193 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1194 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1196 (SELECT player FROM players WHERE nick='Snofox'),
1198 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
1201 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1202 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1204 (SELECT player FROM players WHERE nick='Snofox'),
1206 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1209 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1211 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1214 INSERT INTO groups (tournament, round, parallel) VALUES (
1215 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1217 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1218 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1220 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
1222 UPDATE rounds SET randomsongs=1 WHERE
1223 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1225 UPDATE rounds SET chosensongs=1 WHERE
1226 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1229 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1231 (SELECT player FROM players WHERE nick='Pfxp'),
1234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1235 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1237 (SELECT player FROM players WHERE nick='Pfxp'),
1239 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1243 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1245 (SELECT player FROM players WHERE nick='Pfxp'),
1247 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1250 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1251 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1253 (SELECT player FROM players WHERE nick='ViD'),
1256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1257 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1259 (SELECT player FROM players WHERE nick='ViD'),
1261 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1265 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1267 (SELECT player FROM players WHERE nick='ViD'),
1269 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1272 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1273 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1275 (SELECT player FROM players WHERE nick='Purity'),
1278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1279 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1281 (SELECT player FROM players WHERE nick='Purity'),
1283 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1287 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1289 (SELECT player FROM players WHERE nick='Purity'),
1291 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1294 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1295 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1297 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1301 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1303 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1305 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1309 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1311 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1313 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1316 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1317 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1319 (SELECT player FROM players WHERE nick='Naughty'),
1322 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1323 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1325 (SELECT player FROM players WHERE nick='Naughty'),
1327 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1330 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1331 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1333 (SELECT player FROM players WHERE nick='Naughty'),
1335 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1338 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1339 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1341 (SELECT player FROM players WHERE nick='FantNo'),
1344 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1345 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1347 (SELECT player FROM players WHERE nick='FantNo'),
1349 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1352 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1353 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1355 (SELECT player FROM players WHERE nick='FantNo'),
1357 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1360 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1362 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1365 INSERT INTO groups (tournament, round, parallel) VALUES (
1366 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1368 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1369 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1371 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
1373 UPDATE rounds SET randomsongs=1 WHERE
1374 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1376 UPDATE rounds SET chosensongs=1 WHERE
1377 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1379 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1380 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1382 (SELECT player FROM players WHERE nick='Purity'),
1385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1388 (SELECT player FROM players WHERE nick='Purity'),
1390 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1394 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1396 (SELECT player FROM players WHERE nick='Purity'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1401 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1402 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1404 (SELECT player FROM players WHERE nick='Pfxp'),
1407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1408 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1410 (SELECT player FROM players WHERE nick='Pfxp'),
1412 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1418 (SELECT player FROM players WHERE nick='Pfxp'),
1420 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1423 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1424 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1426 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1430 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1432 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1434 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1440 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1442 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1446 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1448 (SELECT player FROM players WHERE nick='ViD'),
1451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1452 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1454 (SELECT player FROM players WHERE nick='ViD'),
1456 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1460 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1462 (SELECT player FROM players WHERE nick='ViD'),
1464 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1468 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1470 (SELECT player FROM players WHERE nick='FantNo'),
1473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1474 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1476 (SELECT player FROM players WHERE nick='FantNo'),
1478 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1482 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1484 (SELECT player FROM players WHERE nick='FantNo'),
1486 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1489 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1491 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1494 INSERT INTO groups (tournament, round, parallel) VALUES (
1495 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1497 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1498 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1500 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)'))
1502 UPDATE rounds SET randomsongs=1 WHERE
1503 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1505 UPDATE rounds SET chosensongs=1 WHERE
1506 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1508 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1509 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1511 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1514 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1515 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1517 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1519 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1522 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1523 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1525 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1527 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1530 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1531 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1533 (SELECT player FROM players WHERE nick='ViD'),
1536 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1537 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1539 (SELECT player FROM players WHERE nick='ViD'),
1541 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1544 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1545 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1547 (SELECT player FROM players WHERE nick='ViD'),
1549 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1552 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1553 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1555 (SELECT player FROM players WHERE nick='Purity'),
1558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1559 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1561 (SELECT player FROM players WHERE nick='Purity'),
1563 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1566 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1567 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1569 (SELECT player FROM players WHERE nick='Purity'),
1571 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1575 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1577 (SELECT player FROM players WHERE nick='FantNo'),
1580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1581 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1583 (SELECT player FROM players WHERE nick='FantNo'),
1585 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1589 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1591 (SELECT player FROM players WHERE nick='FantNo'),
1593 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1596 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1598 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1601 INSERT INTO groups (tournament, round, parallel) VALUES (
1602 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1604 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1605 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1607 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
1609 UPDATE rounds SET randomsongs=1 WHERE
1610 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1612 UPDATE rounds SET chosensongs=1 WHERE
1613 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1615 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1616 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1618 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1621 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1622 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1624 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1626 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1629 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1630 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1632 (SELECT player FROM players WHERE nick='Freaky Mama=)'),
1634 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1637 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1638 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1640 (SELECT player FROM players WHERE nick='Purity'),
1643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1644 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1646 (SELECT player FROM players WHERE nick='Purity'),
1648 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1651 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1652 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1654 (SELECT player FROM players WHERE nick='Purity'),
1656 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1659 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1660 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1662 (SELECT player FROM players WHERE nick='FantNo'),
1665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1666 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1668 (SELECT player FROM players WHERE nick='FantNo'),
1670 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1673 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1674 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1676 (SELECT player FROM players WHERE nick='FantNo'),
1678 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1681 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1683 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1686 INSERT INTO groups (tournament, round, parallel) VALUES (
1687 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1689 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1690 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1692 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
1694 UPDATE rounds SET randomsongs=1 WHERE
1695 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1697 UPDATE rounds SET chosensongs=1 WHERE
1698 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1700 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1701 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1703 (SELECT player FROM players WHERE nick='Purity'),
1706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1707 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1709 (SELECT player FROM players WHERE nick='Purity'),
1711 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1715 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1717 (SELECT player FROM players WHERE nick='Purity'),
1719 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1722 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1723 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1725 (SELECT player FROM players WHERE nick='FantNo'),
1728 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1729 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1731 (SELECT player FROM players WHERE nick='FantNo'),
1733 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
1736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1737 (SELECT tournament FROM tournaments WHERE tournamentname='Fredrikstad Turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1739 (SELECT player FROM players WHERE nick='FantNo'),
1741 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),