2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
5 'NM i Euromix 2 våren 2003',
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, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
16 (SELECT player FROM players WHERE nick='Tom'),
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='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
22 (SELECT player FROM players WHERE nick='Snute'),
24 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 );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
28 (SELECT player FROM players WHERE nick='Daniil'),
30 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 );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
34 (SELECT player FROM players WHERE nick='Psychofreud'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
40 (SELECT player FROM players WHERE nick='Th0rny'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
46 (SELECT player FROM players WHERE nick='Slusk'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
52 (SELECT player FROM players WHERE nick='Havok'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
58 (SELECT player FROM players WHERE nick='DufF'),
60 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 );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
64 (SELECT player FROM players WHERE nick='Magnar'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fiskelim' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fiskelim' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
70 (SELECT player FROM players WHERE nick='Fiskelim'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lykkesopp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lykkesopp' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
76 (SELECT player FROM players WHERE nick='Lykkesopp'),
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='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
82 (SELECT player FROM players WHERE nick='Yeye'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'TheKnight' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'TheKnight' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
88 (SELECT player FROM players WHERE nick='TheKnight'),
90 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 );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
94 (SELECT player FROM players WHERE nick='Draconia'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Vampyro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Vampyro' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
100 (SELECT player FROM players WHERE nick='Vampyro'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Telc' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
106 (SELECT player FROM players WHERE nick='Telc'),
108 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
110 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
113 INSERT INTO groups (tournament, round, parallel) VALUES (
114 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
116 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
117 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
119 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
121 UPDATE rounds SET randomsongs=1 WHERE
122 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
124 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
125 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
127 (SELECT player FROM players WHERE nick='Daniil'),
130 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
133 (SELECT player FROM players WHERE nick='Daniil'),
135 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
138 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
139 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
141 (SELECT player FROM players WHERE nick='Yeye'),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
147 (SELECT player FROM players WHERE nick='Yeye'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
152 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
155 (SELECT player FROM players WHERE nick='TheKnight'),
158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
161 (SELECT player FROM players WHERE nick='TheKnight'),
163 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
166 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
167 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
169 (SELECT player FROM players WHERE nick='Snute'),
172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
173 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
175 (SELECT player FROM players WHERE nick='Snute'),
177 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
180 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
181 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
183 (SELECT player FROM players WHERE nick='Vampyro'),
186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
187 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
189 (SELECT player FROM players WHERE nick='Vampyro'),
191 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
194 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
195 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
197 (SELECT player FROM players WHERE nick='Magnar'),
200 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
203 (SELECT player FROM players WHERE nick='Magnar'),
205 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
208 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
209 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
211 (SELECT player FROM players WHERE nick='Fiskelim'),
214 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
215 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
217 (SELECT player FROM players WHERE nick='Fiskelim'),
219 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
222 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
223 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
225 (SELECT player FROM players WHERE nick='Slusk'),
228 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
231 (SELECT player FROM players WHERE nick='Slusk'),
233 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
236 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
237 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
239 (SELECT player FROM players WHERE nick='Psychofreud'),
242 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
245 (SELECT player FROM players WHERE nick='Psychofreud'),
247 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
250 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
251 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
253 (SELECT player FROM players WHERE nick='Telc'),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
259 (SELECT player FROM players WHERE nick='Telc'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
264 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
267 (SELECT player FROM players WHERE nick='Th0rny'),
270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
273 (SELECT player FROM players WHERE nick='Th0rny'),
275 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
278 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
281 (SELECT player FROM players WHERE nick='DufF'),
284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
285 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
287 (SELECT player FROM players WHERE nick='DufF'),
289 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
292 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
293 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
295 (SELECT player FROM players WHERE nick='Draconia'),
298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
301 (SELECT player FROM players WHERE nick='Draconia'),
303 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
309 (SELECT player FROM players WHERE nick='Lykkesopp'),
312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
315 (SELECT player FROM players WHERE nick='Lykkesopp'),
317 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
320 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
323 (SELECT player FROM players WHERE nick='Tom'),
326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
329 (SELECT player FROM players WHERE nick='Tom'),
331 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
334 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
336 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
339 INSERT INTO groups (tournament, round, parallel) VALUES (
340 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
342 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
345 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
347 UPDATE rounds SET randomsongs=1 WHERE
348 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
350 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
353 (SELECT player FROM players WHERE nick='DufF'),
356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
357 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
359 (SELECT player FROM players WHERE nick='DufF'),
361 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
365 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
367 (SELECT player FROM players WHERE nick='Lykkesopp'),
370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
373 (SELECT player FROM players WHERE nick='Lykkesopp'),
375 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
378 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
381 (SELECT player FROM players WHERE nick='Fiskelim'),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
387 (SELECT player FROM players WHERE nick='Fiskelim'),
389 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
392 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
395 (SELECT player FROM players WHERE nick='Havok'),
398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
401 (SELECT player FROM players WHERE nick='Havok'),
403 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
406 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
409 (SELECT player FROM players WHERE nick='Yeye'),
412 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
413 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
415 (SELECT player FROM players WHERE nick='Yeye'),
417 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
420 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
421 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
423 (SELECT player FROM players WHERE nick='Slusk'),
426 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
427 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
429 (SELECT player FROM players WHERE nick='Slusk'),
431 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
434 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
435 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
437 (SELECT player FROM players WHERE nick='Psychofreud'),
440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
443 (SELECT player FROM players WHERE nick='Psychofreud'),
445 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
448 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
451 (SELECT player FROM players WHERE nick='Daniil'),
454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
455 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
457 (SELECT player FROM players WHERE nick='Daniil'),
459 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
462 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
463 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
465 (SELECT player FROM players WHERE nick='Magnar'),
468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
469 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
471 (SELECT player FROM players WHERE nick='Magnar'),
473 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
479 (SELECT player FROM players WHERE nick='Th0rny'),
482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
485 (SELECT player FROM players WHERE nick='Th0rny'),
487 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
490 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
491 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
493 (SELECT player FROM players WHERE nick='Tom'),
496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
497 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
499 (SELECT player FROM players WHERE nick='Tom'),
501 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
504 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
505 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
507 (SELECT player FROM players WHERE nick='Snute'),
510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
511 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
513 (SELECT player FROM players WHERE nick='Snute'),
515 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
518 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
520 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
523 INSERT INTO groups (tournament, round, parallel) VALUES (
524 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
526 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
527 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
529 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
531 UPDATE rounds SET randomsongs=1 WHERE
532 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
534 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
535 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
537 (SELECT player FROM players WHERE nick='Fiskelim'),
540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
543 (SELECT player FROM players WHERE nick='Fiskelim'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
548 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
549 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
551 (SELECT player FROM players WHERE nick='Havok'),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
557 (SELECT player FROM players WHERE nick='Havok'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
562 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
565 (SELECT player FROM players WHERE nick='DufF'),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
571 (SELECT player FROM players WHERE nick='DufF'),
573 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
576 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
579 (SELECT player FROM players WHERE nick='Slusk'),
582 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
583 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
585 (SELECT player FROM players WHERE nick='Slusk'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
591 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
593 (SELECT player FROM players WHERE nick='Magnar'),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
599 (SELECT player FROM players WHERE nick='Magnar'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
604 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
605 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
607 (SELECT player FROM players WHERE nick='Psychofreud'),
610 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
611 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
613 (SELECT player FROM players WHERE nick='Psychofreud'),
615 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
618 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
619 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
621 (SELECT player FROM players WHERE nick='Th0rny'),
624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
627 (SELECT player FROM players WHERE nick='Th0rny'),
629 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
635 (SELECT player FROM players WHERE nick='Daniil'),
638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
639 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
641 (SELECT player FROM players WHERE nick='Daniil'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
647 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
649 (SELECT player FROM players WHERE nick='Snute'),
652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
653 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
655 (SELECT player FROM players WHERE nick='Snute'),
657 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
660 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
661 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
663 (SELECT player FROM players WHERE nick='Tom'),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
669 (SELECT player FROM players WHERE nick='Tom'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
674 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
676 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
679 INSERT INTO groups (tournament, round, parallel) VALUES (
680 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
682 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
683 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
685 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
687 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
688 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
690 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
692 UPDATE rounds SET randomsongs=2 WHERE
693 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
695 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
696 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
698 (SELECT player FROM players WHERE nick='DufF'),
701 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
702 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
704 (SELECT player FROM players WHERE nick='DufF'),
706 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
709 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
710 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
712 (SELECT player FROM players WHERE nick='DufF'),
714 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
717 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
718 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
720 (SELECT player FROM players WHERE nick='Slusk'),
723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
724 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
726 (SELECT player FROM players WHERE nick='Slusk'),
728 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
732 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
734 (SELECT player FROM players WHERE nick='Slusk'),
736 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
739 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
740 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
742 (SELECT player FROM players WHERE nick='Havok'),
745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
746 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
748 (SELECT player FROM players WHERE nick='Havok'),
750 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
753 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
754 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
756 (SELECT player FROM players WHERE nick='Havok'),
758 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
761 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
762 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
764 (SELECT player FROM players WHERE nick='Psychofreud'),
767 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
768 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
770 (SELECT player FROM players WHERE nick='Psychofreud'),
772 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
776 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
778 (SELECT player FROM players WHERE nick='Psychofreud'),
780 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
783 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
784 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
786 (SELECT player FROM players WHERE nick='Daniil'),
789 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
790 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
792 (SELECT player FROM players WHERE nick='Daniil'),
794 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
797 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
798 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
800 (SELECT player FROM players WHERE nick='Daniil'),
802 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
805 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
806 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
808 (SELECT player FROM players WHERE nick='Th0rny'),
811 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
812 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
814 (SELECT player FROM players WHERE nick='Th0rny'),
816 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
822 (SELECT player FROM players WHERE nick='Th0rny'),
824 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
827 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
828 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
830 (SELECT player FROM players WHERE nick='Tom'),
833 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
834 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
836 (SELECT player FROM players WHERE nick='Tom'),
838 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
841 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
842 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
844 (SELECT player FROM players WHERE nick='Tom'),
846 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
849 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
850 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
852 (SELECT player FROM players WHERE nick='Snute'),
855 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
856 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
858 (SELECT player FROM players WHERE nick='Snute'),
860 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
863 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
864 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
866 (SELECT player FROM players WHERE nick='Snute'),
868 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
871 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
873 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
876 INSERT INTO groups (tournament, round, parallel) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
879 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
880 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
882 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
884 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
885 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
887 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down'))
889 UPDATE rounds SET randomsongs=2 WHERE
890 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
892 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
893 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
895 (SELECT player FROM players WHERE nick='Slusk'),
898 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
901 (SELECT player FROM players WHERE nick='Slusk'),
903 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
909 (SELECT player FROM players WHERE nick='Slusk'),
911 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
914 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
917 (SELECT player FROM players WHERE nick='Psychofreud'),
920 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
923 (SELECT player FROM players WHERE nick='Psychofreud'),
925 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
931 (SELECT player FROM players WHERE nick='Psychofreud'),
933 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
936 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
939 (SELECT player FROM players WHERE nick='Daniil'),
942 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
945 (SELECT player FROM players WHERE nick='Daniil'),
947 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
953 (SELECT player FROM players WHERE nick='Daniil'),
955 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
958 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
961 (SELECT player FROM players WHERE nick='Snute'),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
967 (SELECT player FROM players WHERE nick='Snute'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
975 (SELECT player FROM players WHERE nick='Snute'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
980 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
983 (SELECT player FROM players WHERE nick='Th0rny'),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
989 (SELECT player FROM players WHERE nick='Th0rny'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
997 (SELECT player FROM players WHERE nick='Th0rny'),
999 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1002 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1005 (SELECT player FROM players WHERE nick='Tom'),
1008 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1011 (SELECT player FROM players WHERE nick='Tom'),
1013 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1016 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1017 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1019 (SELECT player FROM players WHERE nick='Tom'),
1021 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1024 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1026 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1029 INSERT INTO groups (tournament, round, parallel) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1032 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1033 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1035 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
1037 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1038 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1040 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
1042 UPDATE rounds SET randomsongs=2 WHERE
1043 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
1045 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1046 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1048 (SELECT player FROM players WHERE nick='Daniil'),
1051 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1052 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1054 (SELECT player FROM players WHERE nick='Daniil'),
1056 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1059 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1060 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1062 (SELECT player FROM players WHERE nick='Daniil'),
1064 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1067 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1068 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1070 (SELECT player FROM players WHERE nick='Tom'),
1073 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1076 (SELECT player FROM players WHERE nick='Tom'),
1078 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1081 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1082 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1084 (SELECT player FROM players WHERE nick='Tom'),
1086 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1089 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1090 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1092 (SELECT player FROM players WHERE nick='Psychofreud'),
1095 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1096 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1098 (SELECT player FROM players WHERE nick='Psychofreud'),
1100 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1103 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1104 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1106 (SELECT player FROM players WHERE nick='Psychofreud'),
1108 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1111 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1112 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1114 (SELECT player FROM players WHERE nick='Snute'),
1117 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1120 (SELECT player FROM players WHERE nick='Snute'),
1122 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1125 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1126 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1128 (SELECT player FROM players WHERE nick='Snute'),
1130 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1133 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1135 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1138 INSERT INTO groups (tournament, round, parallel) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1141 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1142 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1144 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
1146 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1147 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1149 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
1151 UPDATE rounds SET randomsongs=2 WHERE
1152 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
1154 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1155 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1157 (SELECT player FROM players WHERE nick='Daniil'),
1160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1161 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1163 (SELECT player FROM players WHERE nick='Daniil'),
1165 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1168 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1169 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1171 (SELECT player FROM players WHERE nick='Daniil'),
1173 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1176 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1177 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1179 (SELECT player FROM players WHERE nick='Tom'),
1182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1183 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1185 (SELECT player FROM players WHERE nick='Tom'),
1187 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1191 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1193 (SELECT player FROM players WHERE nick='Tom'),
1195 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1199 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1201 (SELECT player FROM players WHERE nick='Snute'),
1204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1205 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1207 (SELECT player FROM players WHERE nick='Snute'),
1209 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
1212 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1213 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1215 (SELECT player FROM players WHERE nick='Snute'),
1217 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1220 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1222 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1225 INSERT INTO groups (tournament, round, parallel) VALUES (
1226 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1228 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1229 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1231 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love'))
1233 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1234 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1236 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1238 UPDATE rounds SET randomsongs=2 WHERE
1239 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )) AND
1241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1244 (SELECT player FROM players WHERE nick='Snute'),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1250 (SELECT player FROM players WHERE nick='Snute'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1258 (SELECT player FROM players WHERE nick='Snute'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1263 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1264 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1266 (SELECT player FROM players WHERE nick='Tom'),
1269 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1270 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1272 (SELECT player FROM players WHERE nick='Tom'),
1274 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1277 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1278 (SELECT tournament FROM tournaments WHERE tournamentname='NM i Euromix 2 våren 2003' AND season=( SELECT season FROM seasons WHERE seasonname='Norgesmesterskap' )),
1280 (SELECT player FROM players WHERE nick='Tom'),
1282 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),