2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Frittstående' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
6 (SELECT country FROM countries WHERE countryname='Norway'),
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, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16 (SELECT player FROM players WHERE nick='Snofox'),
18 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 );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
22 (SELECT player FROM players WHERE nick='ViD'),
24 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 );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
28 (SELECT player FROM players WHERE nick='Jannemor'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
34 (SELECT player FROM players WHERE nick='Spinnvill'),
36 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 );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
40 (SELECT player FROM players WHERE nick='Jallaman'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
46 (SELECT player FROM players WHERE nick='Indy'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
52 (SELECT player FROM players WHERE nick='Snute'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
58 (SELECT player FROM players WHERE nick='Slusk'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
64 (SELECT player FROM players WHERE nick='Matsi'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
70 (SELECT player FROM players WHERE nick='Smiph'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Iris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Iris' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
76 (SELECT player FROM players WHERE nick='Iris'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
82 (SELECT player FROM players WHERE nick='Ylini'),
84 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
86 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
89 INSERT INTO groups (tournament, round, parallel) VALUES (
90 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
92 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
93 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
95 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
97 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
100 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
102 UPDATE rounds SET randomsongs=2 WHERE
103 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
105 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
106 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
108 (SELECT player FROM players WHERE nick='Indy'),
111 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
112 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
114 (SELECT player FROM players WHERE nick='Indy'),
116 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
119 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
120 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
122 (SELECT player FROM players WHERE nick='Indy'),
124 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
127 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
130 (SELECT player FROM players WHERE nick='Iris'),
133 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
136 (SELECT player FROM players WHERE nick='Iris'),
138 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
141 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
142 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
144 (SELECT player FROM players WHERE nick='Iris'),
146 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
149 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
151 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
154 INSERT INTO groups (tournament, round, parallel) VALUES (
155 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
157 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
160 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
162 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
163 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
165 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
167 UPDATE rounds SET randomsongs=2 WHERE
168 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
170 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
173 (SELECT player FROM players WHERE nick='Smiph'),
176 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
177 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
179 (SELECT player FROM players WHERE nick='Smiph'),
181 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
184 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
185 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
187 (SELECT player FROM players WHERE nick='Smiph'),
189 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
192 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
193 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
195 (SELECT player FROM players WHERE nick='Spinnvill'),
198 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
201 (SELECT player FROM players WHERE nick='Spinnvill'),
203 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
207 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
209 (SELECT player FROM players WHERE nick='Spinnvill'),
211 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
214 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
216 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
219 INSERT INTO groups (tournament, round, parallel) VALUES (
220 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
222 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
225 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
227 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
228 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
230 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
232 UPDATE rounds SET randomsongs=2 WHERE
233 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
235 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
238 (SELECT player FROM players WHERE nick='Jannemor'),
241 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
242 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
244 (SELECT player FROM players WHERE nick='Jannemor'),
246 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
249 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
250 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
252 (SELECT player FROM players WHERE nick='Jannemor'),
254 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
257 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
258 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
260 (SELECT player FROM players WHERE nick='Stream'),
263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
264 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
266 (SELECT player FROM players WHERE nick='Stream'),
268 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
271 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
274 (SELECT player FROM players WHERE nick='Stream'),
276 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
279 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
281 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
284 INSERT INTO groups (tournament, round, parallel) VALUES (
285 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
287 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
288 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
290 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
292 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
293 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
295 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
297 UPDATE rounds SET randomsongs=2 WHERE
298 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
300 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
303 (SELECT player FROM players WHERE nick='Slusk'),
306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
309 (SELECT player FROM players WHERE nick='Slusk'),
311 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
314 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
317 (SELECT player FROM players WHERE nick='Slusk'),
319 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
322 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
323 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
325 (SELECT player FROM players WHERE nick='Jallaman'),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
331 (SELECT player FROM players WHERE nick='Jallaman'),
333 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
336 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
339 (SELECT player FROM players WHERE nick='Jallaman'),
341 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
344 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
346 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
349 INSERT INTO groups (tournament, round, parallel) VALUES (
350 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
352 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
353 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
355 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
357 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
358 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
360 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
362 UPDATE rounds SET randomsongs=2 WHERE
363 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
365 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
366 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
368 (SELECT player FROM players WHERE nick='Smiph'),
371 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
372 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
374 (SELECT player FROM players WHERE nick='Smiph'),
376 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
379 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
380 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
382 (SELECT player FROM players WHERE nick='Smiph'),
384 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
387 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
388 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
390 (SELECT player FROM players WHERE nick='Havok'),
393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
394 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
396 (SELECT player FROM players WHERE nick='Havok'),
398 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
401 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
402 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
404 (SELECT player FROM players WHERE nick='Havok'),
406 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
409 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
411 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
414 INSERT INTO groups (tournament, round, parallel) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
417 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
418 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
420 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
422 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
425 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
427 UPDATE rounds SET randomsongs=2 WHERE
428 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
430 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
433 (SELECT player FROM players WHERE nick='Jallaman'),
436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
439 (SELECT player FROM players WHERE nick='Jallaman'),
441 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
447 (SELECT player FROM players WHERE nick='Jallaman'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
452 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
455 (SELECT player FROM players WHERE nick='ViD'),
458 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
459 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
461 (SELECT player FROM players WHERE nick='ViD'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
466 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
467 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
469 (SELECT player FROM players WHERE nick='ViD'),
471 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
474 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
476 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
479 INSERT INTO groups (tournament, round, parallel) VALUES (
480 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
482 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
485 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
487 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
488 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
490 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
492 UPDATE rounds SET randomsongs=2 WHERE
493 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
495 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
496 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
498 (SELECT player FROM players WHERE nick='Ylini'),
501 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
502 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
504 (SELECT player FROM players WHERE nick='Ylini'),
506 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
509 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
510 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
512 (SELECT player FROM players WHERE nick='Ylini'),
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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
520 (SELECT player FROM players WHERE nick='Indy'),
523 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
526 (SELECT player FROM players WHERE nick='Indy'),
528 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
531 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
532 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
534 (SELECT player FROM players WHERE nick='Indy'),
536 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
539 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
541 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
544 INSERT INTO groups (tournament, round, parallel) VALUES (
545 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
547 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
548 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
550 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
552 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
553 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
555 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
557 UPDATE rounds SET randomsongs=2 WHERE
558 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
560 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
563 (SELECT player FROM players WHERE nick='ViD'),
566 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
569 (SELECT player FROM players WHERE nick='ViD'),
571 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
574 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
575 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
577 (SELECT player FROM players WHERE nick='ViD'),
579 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
582 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
583 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
585 (SELECT player FROM players WHERE nick='Snute'),
588 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
589 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
591 (SELECT player FROM players WHERE nick='Snute'),
593 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
599 (SELECT player FROM players WHERE nick='Snute'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
604 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
606 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
609 INSERT INTO groups (tournament, round, parallel) VALUES (
610 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
612 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
613 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
615 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
617 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
618 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
620 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
622 UPDATE rounds SET randomsongs=2 WHERE
623 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
625 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
626 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
628 (SELECT player FROM players WHERE nick='Matsi'),
631 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
632 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
634 (SELECT player FROM players WHERE nick='Matsi'),
636 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
642 (SELECT player FROM players WHERE nick='Matsi'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
647 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
648 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
650 (SELECT player FROM players WHERE nick='RiChY'),
653 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
654 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
656 (SELECT player FROM players WHERE nick='RiChY'),
658 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
661 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
662 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
664 (SELECT player FROM players WHERE nick='RiChY'),
666 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
669 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
671 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
674 INSERT INTO groups (tournament, round, parallel) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
677 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
678 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
680 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
682 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
683 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
685 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
687 UPDATE rounds SET randomsongs=2 WHERE
688 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
690 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
691 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
693 (SELECT player FROM players WHERE nick='Snute'),
696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
697 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
699 (SELECT player FROM players WHERE nick='Snute'),
701 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
704 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
705 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
707 (SELECT player FROM players WHERE nick='Snute'),
709 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
712 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
713 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
715 (SELECT player FROM players WHERE nick='Snofox'),
718 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
719 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
721 (SELECT player FROM players WHERE nick='Snofox'),
723 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
729 (SELECT player FROM players WHERE nick='Snofox'),
731 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
734 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
736 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
739 INSERT INTO groups (tournament, round, parallel) VALUES (
740 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
742 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
745 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
747 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
748 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
750 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
752 UPDATE rounds SET randomsongs=2 WHERE
753 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
755 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
756 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
758 (SELECT player FROM players WHERE nick='Ylini'),
761 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
762 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
764 (SELECT player FROM players WHERE nick='Ylini'),
766 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
769 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
770 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
772 (SELECT player FROM players WHERE nick='Ylini'),
774 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
777 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
778 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
780 (SELECT player FROM players WHERE nick='Spinnvill'),
783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
786 (SELECT player FROM players WHERE nick='Spinnvill'),
788 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
792 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
794 (SELECT player FROM players WHERE nick='Spinnvill'),
796 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
799 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
801 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
804 INSERT INTO groups (tournament, round, parallel) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
807 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
808 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
810 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
812 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
813 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
815 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
817 UPDATE rounds SET randomsongs=2 WHERE
818 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
820 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
821 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
823 (SELECT player FROM players WHERE nick='Iris'),
826 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
829 (SELECT player FROM players WHERE nick='Iris'),
831 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
837 (SELECT player FROM players WHERE nick='Iris'),
839 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
842 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
843 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
845 (SELECT player FROM players WHERE nick='Jannemor'),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
851 (SELECT player FROM players WHERE nick='Jannemor'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
857 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
859 (SELECT player FROM players WHERE nick='Jannemor'),
861 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
864 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
866 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
869 INSERT INTO groups (tournament, round, parallel) VALUES (
870 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
872 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
873 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
875 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
877 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
878 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
880 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
882 UPDATE rounds SET randomsongs=2 WHERE
883 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
885 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
886 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
888 (SELECT player FROM players WHERE nick='Snofox'),
891 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
892 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
894 (SELECT player FROM players WHERE nick='Snofox'),
896 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
899 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
900 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
902 (SELECT player FROM players WHERE nick='Snofox'),
904 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
907 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
908 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
910 (SELECT player FROM players WHERE nick='Slusk'),
913 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
914 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
916 (SELECT player FROM players WHERE nick='Slusk'),
918 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
921 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
922 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
924 (SELECT player FROM players WHERE nick='Slusk'),
926 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
929 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
931 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
934 INSERT INTO groups (tournament, round, parallel) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
937 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
938 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
940 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
942 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
945 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
947 UPDATE rounds SET randomsongs=2 WHERE
948 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
950 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
953 (SELECT player FROM players WHERE nick='Matsi'),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
959 (SELECT player FROM players WHERE nick='Matsi'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
967 (SELECT player FROM players WHERE nick='Matsi'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
972 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
975 (SELECT player FROM players WHERE nick='Havok'),
978 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
979 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
981 (SELECT player FROM players WHERE nick='Havok'),
983 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
989 (SELECT player FROM players WHERE nick='Havok'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
994 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
996 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
999 INSERT INTO groups (tournament, round, parallel) VALUES (
1000 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1002 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1005 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
1007 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1008 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1010 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
1012 UPDATE rounds SET randomsongs=2 WHERE
1013 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1015 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1016 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1018 (SELECT player FROM players WHERE nick='Stream'),
1021 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1022 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1024 (SELECT player FROM players WHERE nick='Stream'),
1026 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1029 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1032 (SELECT player FROM players WHERE nick='Stream'),
1034 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1037 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1038 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1040 (SELECT player FROM players WHERE nick='RiChY'),
1043 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1044 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1046 (SELECT player FROM players WHERE nick='RiChY'),
1048 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1051 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1054 (SELECT player FROM players WHERE nick='RiChY'),
1056 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),