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, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
16 (SELECT player FROM players WHERE nick='DufF'),
18 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 );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
28 (SELECT player FROM players WHERE nick='Magnar'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
34 (SELECT player FROM players WHERE nick='Daniil'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
40 (SELECT player FROM players WHERE nick='Oliyzia'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
46 (SELECT player FROM players WHERE nick='RiChY'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
52 (SELECT player FROM players WHERE nick='Tom'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Psychofreud' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Psychofreud' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
58 (SELECT player FROM players WHERE nick='Psychofreud'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
64 (SELECT player FROM players WHERE nick='T|na'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
70 (SELECT player FROM players WHERE nick='Draconia'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kabooze' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kabooze' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
76 (SELECT player FROM players WHERE nick='Kabooze'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yeye' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yeye' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
82 (SELECT player FROM players WHERE nick='Yeye'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'kjmcw' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'kjmcw' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
88 (SELECT player FROM players WHERE nick='kjmcw'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
94 (SELECT player FROM players WHERE nick='Mulefisk'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
100 (SELECT player FROM players WHERE nick='Iris'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
106 (SELECT player FROM players WHERE nick='Pfxp'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
112 (SELECT player FROM players WHERE nick='Purity'),
114 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 );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
118 (SELECT player FROM players WHERE nick='Indy'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nevrosert' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nevrosert' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
124 (SELECT player FROM players WHERE nick='Nevrosert'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Advena' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
130 (SELECT player FROM players WHERE nick='Advena'),
132 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 );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
136 (SELECT player FROM players WHERE nick='Matsi'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lejordet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lejordet' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
142 (SELECT player FROM players WHERE nick='Lejordet'),
144 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 );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
148 (SELECT player FROM players WHERE nick='Smiph'),
150 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 );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
154 (SELECT player FROM players WHERE nick='Havok'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Rannveig' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Rannveig' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
160 (SELECT player FROM players WHERE nick='Rannveig'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'p33r' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'p33r' NOT IN ( SELECT nick FROM players );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
166 (SELECT player FROM players WHERE nick='p33r'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Malin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Malin' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
172 (SELECT player FROM players WHERE nick='Malin'),
174 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
176 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
179 INSERT INTO groups (tournament, round, parallel) VALUES (
180 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
182 UPDATE rounds SET randomsongs=0 WHERE
183 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
185 UPDATE rounds SET chosensongs=1 WHERE
186 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' 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='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
191 (SELECT player FROM players WHERE nick='Malin'),
194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
197 (SELECT player FROM players WHERE nick='Malin'),
199 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
202 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
203 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
205 (SELECT player FROM players WHERE nick='p33r'),
208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
209 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
211 (SELECT player FROM players WHERE nick='p33r'),
213 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
216 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
219 (SELECT player FROM players WHERE nick='Rannveig'),
222 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
225 (SELECT player FROM players WHERE nick='Rannveig'),
227 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
230 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
233 (SELECT player FROM players WHERE nick='Havok'),
236 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
237 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
239 (SELECT player FROM players WHERE nick='Havok'),
241 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
244 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
245 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
247 (SELECT player FROM players WHERE nick='Smiph'),
250 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
253 (SELECT player FROM players WHERE nick='Smiph'),
255 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
258 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
261 (SELECT player FROM players WHERE nick='Lejordet'),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
267 (SELECT player FROM players WHERE nick='Lejordet'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
272 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
275 (SELECT player FROM players WHERE nick='Matsi'),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
281 (SELECT player FROM players WHERE nick='Matsi'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
286 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
289 (SELECT player FROM players WHERE nick='Advena'),
292 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
293 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
295 (SELECT player FROM players WHERE nick='Advena'),
297 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
300 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
303 (SELECT player FROM players WHERE nick='Nevrosert'),
306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
309 (SELECT player FROM players WHERE nick='Nevrosert'),
311 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
314 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
315 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
317 (SELECT player FROM players WHERE nick='Indy'),
320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
323 (SELECT player FROM players WHERE nick='Indy'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
328 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
331 (SELECT player FROM players WHERE nick='Purity'),
334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
335 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
337 (SELECT player FROM players WHERE nick='Purity'),
339 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
342 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
345 (SELECT player FROM players WHERE nick='Pfxp'),
348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
349 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
351 (SELECT player FROM players WHERE nick='Pfxp'),
353 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
356 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
357 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
359 (SELECT player FROM players WHERE nick='Iris'),
362 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
365 (SELECT player FROM players WHERE nick='Iris'),
367 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
370 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
373 (SELECT player FROM players WHERE nick='Mulefisk'),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
379 (SELECT player FROM players WHERE nick='Mulefisk'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
384 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
387 (SELECT player FROM players WHERE nick='kjmcw'),
390 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
391 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
393 (SELECT player FROM players WHERE nick='kjmcw'),
395 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
398 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
401 (SELECT player FROM players WHERE nick='Yeye'),
404 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
405 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
407 (SELECT player FROM players WHERE nick='Yeye'),
409 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
412 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
413 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
415 (SELECT player FROM players WHERE nick='Kabooze'),
418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
419 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
421 (SELECT player FROM players WHERE nick='Kabooze'),
423 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
426 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
427 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
429 (SELECT player FROM players WHERE nick='Draconia'),
432 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
433 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
435 (SELECT player FROM players WHERE nick='Draconia'),
437 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
440 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
443 (SELECT player FROM players WHERE nick='T|na'),
446 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
447 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
449 (SELECT player FROM players WHERE nick='T|na'),
451 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
454 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
455 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
457 (SELECT player FROM players WHERE nick='Psychofreud'),
460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
461 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
463 (SELECT player FROM players WHERE nick='Psychofreud'),
465 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
468 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
469 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
471 (SELECT player FROM players WHERE nick='Tom'),
474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
475 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
477 (SELECT player FROM players WHERE nick='Tom'),
479 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
485 (SELECT player FROM players WHERE nick='RiChY'),
488 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
489 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
491 (SELECT player FROM players WHERE nick='RiChY'),
493 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
496 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
497 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
499 (SELECT player FROM players WHERE nick='Magnar'),
502 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
503 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
505 (SELECT player FROM players WHERE nick='Magnar'),
507 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
510 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
511 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
513 (SELECT player FROM players WHERE nick='DufF'),
516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
517 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
519 (SELECT player FROM players WHERE nick='DufF'),
521 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
524 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
527 (SELECT player FROM players WHERE nick='Oliyzia'),
530 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
531 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
533 (SELECT player FROM players WHERE nick='Oliyzia'),
535 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
538 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
541 (SELECT player FROM players WHERE nick='Daniil'),
544 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
545 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
547 (SELECT player FROM players WHERE nick='Daniil'),
549 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
552 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
553 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
555 (SELECT player FROM players WHERE nick='Snute'),
558 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
559 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
561 (SELECT player FROM players WHERE nick='Snute'),
563 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
566 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
568 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
571 INSERT INTO groups (tournament, round, parallel) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
574 UPDATE rounds SET randomsongs=0 WHERE
575 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
577 UPDATE rounds SET chosensongs=1 WHERE
578 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )) AND
580 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
583 (SELECT player FROM players WHERE nick='Magnar'),
586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
587 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
589 (SELECT player FROM players WHERE nick='Magnar'),
591 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
594 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
597 (SELECT player FROM players WHERE nick='DufF'),
600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
601 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
603 (SELECT player FROM players WHERE nick='DufF'),
605 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
608 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
611 (SELECT player FROM players WHERE nick='Oliyzia'),
614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
617 (SELECT player FROM players WHERE nick='Oliyzia'),
619 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
622 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
625 (SELECT player FROM players WHERE nick='Daniil'),
628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
631 (SELECT player FROM players WHERE nick='Daniil'),
633 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
636 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
639 (SELECT player FROM players WHERE nick='Snute'),
642 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
643 (SELECT tournament FROM tournaments WHERE tournamentname='Aftenposten Cup' AND season=( SELECT season FROM seasons WHERE seasonname='Frittstående' )),
645 (SELECT player FROM players WHERE nick='Snute'),
647 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),