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, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' 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='Havok'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' 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='RiChY'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stream' 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='Stream'),
30 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 );
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='Snofox'),
36 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 );
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='ViD'),
42 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 );
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='Jannemor'),
48 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 );
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='Spinnvill'),
54 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 );
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='Jallaman'),
60 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 );
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='Indy'),
66 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 );
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='Snute'),
72 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 );
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='Slusk'),
78 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 );
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='Matsi'),
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='Follo lag 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, 'Iris' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Iris' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
94 (SELECT player FROM players WHERE nick='Iris'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
100 (SELECT player FROM players WHERE nick='Ylini'),
102 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
104 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
107 INSERT INTO groups (tournament, round, parallel) VALUES (
108 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
110 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
111 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
113 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
115 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
118 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
120 UPDATE rounds SET randomsongs=2 WHERE
121 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
123 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
124 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
126 (SELECT player FROM players WHERE nick='Indy'),
129 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
130 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
132 (SELECT player FROM players WHERE nick='Indy'),
134 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
137 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
138 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
140 (SELECT player FROM players WHERE nick='Indy'),
142 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
145 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
148 (SELECT player FROM players WHERE nick='Iris'),
151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
154 (SELECT player FROM players WHERE nick='Iris'),
156 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
159 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
160 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
162 (SELECT player FROM players WHERE nick='Iris'),
164 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
167 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
169 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
172 INSERT INTO groups (tournament, round, parallel) VALUES (
173 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
175 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
178 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
180 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
181 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
183 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
185 UPDATE rounds SET randomsongs=2 WHERE
186 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
188 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
191 (SELECT player FROM players WHERE nick='Smiph'),
194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
197 (SELECT player FROM players WHERE nick='Smiph'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
205 (SELECT player FROM players WHERE nick='Smiph'),
207 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
211 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
213 (SELECT player FROM players WHERE nick='Spinnvill'),
216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
219 (SELECT player FROM players WHERE nick='Spinnvill'),
221 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
225 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
227 (SELECT player FROM players WHERE nick='Spinnvill'),
229 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
232 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
234 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
237 INSERT INTO groups (tournament, round, parallel) VALUES (
238 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
240 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
243 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
245 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
246 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
248 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
250 UPDATE rounds SET randomsongs=2 WHERE
251 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
253 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
254 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
256 (SELECT player FROM players WHERE nick='Jannemor'),
259 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
260 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
262 (SELECT player FROM players WHERE nick='Jannemor'),
264 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
267 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
268 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
270 (SELECT player FROM players WHERE nick='Jannemor'),
272 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
275 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
276 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
278 (SELECT player FROM players WHERE nick='Stream'),
281 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
282 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
284 (SELECT player FROM players WHERE nick='Stream'),
286 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
289 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
290 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
292 (SELECT player FROM players WHERE nick='Stream'),
294 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
297 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
299 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
302 INSERT INTO groups (tournament, round, parallel) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
305 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
306 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
308 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
310 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
313 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
315 UPDATE rounds SET randomsongs=2 WHERE
316 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag 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='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
321 (SELECT player FROM players WHERE nick='Slusk'),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
327 (SELECT player FROM players WHERE nick='Slusk'),
329 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
335 (SELECT player FROM players WHERE nick='Slusk'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
340 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
341 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
343 (SELECT player FROM players WHERE nick='Jallaman'),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
349 (SELECT player FROM players WHERE nick='Jallaman'),
351 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
357 (SELECT player FROM players WHERE nick='Jallaman'),
359 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
362 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
364 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
367 INSERT INTO groups (tournament, round, parallel) VALUES (
368 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
370 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
373 (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
375 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
376 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
378 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
380 UPDATE rounds SET randomsongs=2 WHERE
381 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
383 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
384 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
386 (SELECT player FROM players WHERE nick='Smiph'),
389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
390 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
392 (SELECT player FROM players WHERE nick='Smiph'),
394 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
398 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
400 (SELECT player FROM players WHERE nick='Smiph'),
402 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
405 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
406 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
408 (SELECT player FROM players WHERE nick='Havok'),
411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
412 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
414 (SELECT player FROM players WHERE nick='Havok'),
416 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
420 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
422 (SELECT player FROM players WHERE nick='Havok'),
424 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
427 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
429 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
432 INSERT INTO groups (tournament, round, parallel) VALUES (
433 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
435 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
436 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
438 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
440 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
443 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
445 UPDATE rounds SET randomsongs=2 WHERE
446 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
448 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
451 (SELECT player FROM players WHERE nick='Jallaman'),
454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
455 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
457 (SELECT player FROM players WHERE nick='Jallaman'),
459 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
462 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
463 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
465 (SELECT player FROM players WHERE nick='Jallaman'),
467 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
470 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
473 (SELECT player FROM players WHERE nick='ViD'),
476 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
479 (SELECT player FROM players WHERE nick='ViD'),
481 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
487 (SELECT player FROM players WHERE nick='ViD'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
492 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
494 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
497 INSERT INTO groups (tournament, round, parallel) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
500 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
503 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe'))
505 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
506 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
508 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
510 UPDATE rounds SET randomsongs=2 WHERE
511 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
513 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
514 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
516 (SELECT player FROM players WHERE nick='Ylini'),
519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
520 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
522 (SELECT player FROM players WHERE nick='Ylini'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
530 (SELECT player FROM players WHERE nick='Ylini'),
532 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
538 (SELECT player FROM players WHERE nick='Indy'),
541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
544 (SELECT player FROM players WHERE nick='Indy'),
546 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
552 (SELECT player FROM players WHERE nick='Indy'),
554 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
557 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
559 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
562 INSERT INTO groups (tournament, round, parallel) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
565 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
566 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
568 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
570 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
571 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
573 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
575 UPDATE rounds SET randomsongs=2 WHERE
576 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
578 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
579 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
581 (SELECT player FROM players WHERE nick='ViD'),
584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
585 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
587 (SELECT player FROM players WHERE nick='ViD'),
589 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
593 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
595 (SELECT player FROM players WHERE nick='ViD'),
597 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
600 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
601 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
603 (SELECT player FROM players WHERE nick='Snute'),
606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
607 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
609 (SELECT player FROM players WHERE nick='Snute'),
611 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
617 (SELECT player FROM players WHERE nick='Snute'),
619 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
622 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
624 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
627 INSERT INTO groups (tournament, round, parallel) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
630 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
633 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
635 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
638 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
640 UPDATE rounds SET randomsongs=2 WHERE
641 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
643 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
644 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
646 (SELECT player FROM players WHERE nick='Matsi'),
649 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
650 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
652 (SELECT player FROM players WHERE nick='Matsi'),
654 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
658 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
660 (SELECT player FROM players WHERE nick='Matsi'),
662 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
665 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
666 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
668 (SELECT player FROM players WHERE nick='RiChY'),
671 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
672 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
674 (SELECT player FROM players WHERE nick='RiChY'),
676 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
679 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
680 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
682 (SELECT player FROM players WHERE nick='RiChY'),
684 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
687 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
689 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
692 INSERT INTO groups (tournament, round, parallel) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
695 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
696 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
698 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
700 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
701 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
703 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
705 UPDATE rounds SET randomsongs=2 WHERE
706 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
708 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
709 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
711 (SELECT player FROM players WHERE nick='Snute'),
714 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
717 (SELECT player FROM players WHERE nick='Snute'),
719 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
725 (SELECT player FROM players WHERE nick='Snute'),
727 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
730 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
731 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
733 (SELECT player FROM players WHERE nick='Snofox'),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
739 (SELECT player FROM players WHERE nick='Snofox'),
741 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
744 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
745 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
747 (SELECT player FROM players WHERE nick='Snofox'),
749 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
752 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
754 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
757 INSERT INTO groups (tournament, round, parallel) VALUES (
758 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
760 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
761 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
763 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)'))
765 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
766 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
768 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
770 UPDATE rounds SET randomsongs=2 WHERE
771 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
773 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
774 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
776 (SELECT player FROM players WHERE nick='Ylini'),
779 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
780 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
782 (SELECT player FROM players WHERE nick='Ylini'),
784 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
787 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
788 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
790 (SELECT player FROM players WHERE nick='Ylini'),
792 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
795 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
796 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
798 (SELECT player FROM players WHERE nick='Spinnvill'),
801 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
802 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
804 (SELECT player FROM players WHERE nick='Spinnvill'),
806 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
809 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
810 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
812 (SELECT player FROM players WHERE nick='Spinnvill'),
814 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
817 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
819 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
822 INSERT INTO groups (tournament, round, parallel) VALUES (
823 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
825 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
826 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
828 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
830 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
831 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
833 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
835 UPDATE rounds SET randomsongs=2 WHERE
836 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
838 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
839 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
841 (SELECT player FROM players WHERE nick='Iris'),
844 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
845 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
847 (SELECT player FROM players WHERE nick='Iris'),
849 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
852 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
853 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
855 (SELECT player FROM players WHERE nick='Iris'),
857 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
860 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
863 (SELECT player FROM players WHERE nick='Jannemor'),
866 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
867 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
869 (SELECT player FROM players WHERE nick='Jannemor'),
871 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
875 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
877 (SELECT player FROM players WHERE nick='Jannemor'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
882 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
884 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
887 INSERT INTO groups (tournament, round, parallel) VALUES (
888 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
890 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
893 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
895 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
896 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
898 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
900 UPDATE rounds SET randomsongs=2 WHERE
901 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
903 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
904 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
906 (SELECT player FROM players WHERE nick='Snofox'),
909 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
910 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
912 (SELECT player FROM players WHERE nick='Snofox'),
914 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
918 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
920 (SELECT player FROM players WHERE nick='Snofox'),
922 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
925 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
926 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
928 (SELECT player FROM players WHERE nick='Slusk'),
931 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
932 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
934 (SELECT player FROM players WHERE nick='Slusk'),
936 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
940 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
942 (SELECT player FROM players WHERE nick='Slusk'),
944 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
947 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
949 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
952 INSERT INTO groups (tournament, round, parallel) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
955 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
956 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
958 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen'))
960 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
961 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
963 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
965 UPDATE rounds SET randomsongs=2 WHERE
966 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
968 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
969 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
971 (SELECT player FROM players WHERE nick='Matsi'),
974 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
975 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
977 (SELECT player FROM players WHERE nick='Matsi'),
979 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
985 (SELECT player FROM players WHERE nick='Matsi'),
987 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
990 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
991 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
993 (SELECT player FROM players WHERE nick='Havok'),
996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
999 (SELECT player FROM players WHERE nick='Havok'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('Caribbean Queen')),
1004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1005 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1007 (SELECT player FROM players WHERE nick='Havok'),
1009 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1012 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1014 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1017 INSERT INTO groups (tournament, round, parallel) VALUES (
1018 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1020 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1021 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1023 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
1025 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1026 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1028 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
1030 UPDATE rounds SET randomsongs=2 WHERE
1031 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
1033 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1034 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1036 (SELECT player FROM players WHERE nick='Stream'),
1039 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1040 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1042 (SELECT player FROM players WHERE nick='Stream'),
1044 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1047 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1048 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1050 (SELECT player FROM players WHERE nick='Stream'),
1052 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1055 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1056 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1058 (SELECT player FROM players WHERE nick='RiChY'),
1061 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1062 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1064 (SELECT player FROM players WHERE nick='RiChY'),
1066 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1069 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1070 (SELECT tournament FROM tournaments WHERE tournamentname='Follo lag turnering' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
1072 (SELECT player FROM players WHERE nick='RiChY'),
1074 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),