2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
6 (SELECT country FROM countries WHERE countryname='Norway'),
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
16 (SELECT player FROM players WHERE nick='Havok'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lars Christian' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lars Christian' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
22 (SELECT player FROM players WHERE nick='Lars Christian'),
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='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
28 (SELECT player FROM players WHERE nick='Daniil'),
30 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 );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
34 (SELECT player FROM players WHERE nick='Draconia'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ole' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ole' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
40 (SELECT player FROM players WHERE nick='Ole'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
46 (SELECT player FROM players WHERE nick='kjmcw'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
52 (SELECT player FROM players WHERE nick='Snute'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
58 (SELECT player FROM players WHERE nick='Th0rny'),
60 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 );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
64 (SELECT player FROM players WHERE nick='Lejordet'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Eilin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Eilin' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
70 (SELECT player FROM players WHERE nick='Eilin'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
76 (SELECT player FROM players WHERE nick='Slusk'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
82 (SELECT player FROM players WHERE nick='Fiskelim'),
84 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
86 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
89 INSERT INTO groups (tournament, round, parallel) VALUES (
90 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
92 UPDATE rounds SET randomsongs=0 WHERE
93 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
95 UPDATE rounds SET chosensongs=1 WHERE
96 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
98 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
99 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
101 (SELECT player FROM players WHERE nick='Th0rny'),
104 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
105 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
107 (SELECT player FROM players WHERE nick='Th0rny'),
109 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
113 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
115 (SELECT player FROM players WHERE nick='Fiskelim'),
118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
119 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
121 (SELECT player FROM players WHERE nick='Fiskelim'),
123 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
127 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
129 (SELECT player FROM players WHERE nick='Snute'),
132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
133 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
135 (SELECT player FROM players WHERE nick='Snute'),
137 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
140 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
141 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
143 (SELECT player FROM players WHERE nick='Draconia'),
146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
147 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
149 (SELECT player FROM players WHERE nick='Draconia'),
151 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
154 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
155 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
157 (SELECT player FROM players WHERE nick='Slusk'),
160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
161 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
163 (SELECT player FROM players WHERE nick='Slusk'),
165 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
169 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
171 (SELECT player FROM players WHERE nick='Lars Christian'),
174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
177 (SELECT player FROM players WHERE nick='Lars Christian'),
179 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
185 (SELECT player FROM players WHERE nick='Havok'),
188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
191 (SELECT player FROM players WHERE nick='Havok'),
193 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
197 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
199 (SELECT player FROM players WHERE nick='kjmcw'),
202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
205 (SELECT player FROM players WHERE nick='kjmcw'),
207 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
211 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
213 (SELECT player FROM players WHERE nick='Lejordet'),
216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
219 (SELECT player FROM players WHERE nick='Lejordet'),
221 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
225 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
227 (SELECT player FROM players WHERE nick='Daniil'),
230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
233 (SELECT player FROM players WHERE nick='Daniil'),
235 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
238 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
239 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
241 (SELECT player FROM players WHERE nick='Ole'),
244 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
247 (SELECT player FROM players WHERE nick='Ole'),
249 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
255 (SELECT player FROM players WHERE nick='Eilin'),
258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
261 (SELECT player FROM players WHERE nick='Eilin'),
263 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
266 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
268 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
271 INSERT INTO groups (tournament, round, parallel) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
274 UPDATE rounds SET randomsongs=0 WHERE
275 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
277 UPDATE rounds SET chosensongs=1 WHERE
278 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
283 (SELECT player FROM players WHERE nick='Lejordet'),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
289 (SELECT player FROM players WHERE nick='Lejordet'),
291 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
294 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
297 (SELECT player FROM players WHERE nick='Eilin'),
300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
303 (SELECT player FROM players WHERE nick='Eilin'),
305 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
308 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
309 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
311 (SELECT player FROM players WHERE nick='Daniil'),
314 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
315 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
317 (SELECT player FROM players WHERE nick='Daniil'),
319 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
322 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
323 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
325 (SELECT player FROM players WHERE nick='Slusk'),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
331 (SELECT player FROM players WHERE nick='Slusk'),
333 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
339 (SELECT player FROM players WHERE nick='kjmcw'),
342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
345 (SELECT player FROM players WHERE nick='kjmcw'),
347 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
350 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
353 (SELECT player FROM players WHERE nick='Th0rny'),
356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
357 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
359 (SELECT player FROM players WHERE nick='Th0rny'),
361 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
365 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
367 (SELECT player FROM players WHERE nick='Draconia'),
370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
373 (SELECT player FROM players WHERE nick='Draconia'),
375 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
378 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
381 (SELECT player FROM players WHERE nick='Snute'),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
387 (SELECT player FROM players WHERE nick='Snute'),
389 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
392 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
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='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
401 (SELECT player FROM players WHERE nick='Havok'),
403 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
406 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
409 (SELECT player FROM players WHERE nick='Ole'),
412 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
413 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
415 (SELECT player FROM players WHERE nick='Ole'),
417 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
420 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
421 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
423 (SELECT player FROM players WHERE nick='Lars Christian'),
426 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
427 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
429 (SELECT player FROM players WHERE nick='Lars Christian'),
431 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
434 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
436 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
439 INSERT INTO groups (tournament, round, parallel) VALUES (
440 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
442 UPDATE rounds SET randomsongs=0 WHERE
443 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
445 UPDATE rounds SET chosensongs=1 WHERE
446 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
448 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
451 (SELECT player FROM players WHERE nick='Lejordet'),
454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
455 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
457 (SELECT player FROM players WHERE nick='Lejordet'),
459 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
462 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
463 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
465 (SELECT player FROM players WHERE nick='kjmcw'),
468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
469 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
471 (SELECT player FROM players WHERE nick='kjmcw'),
473 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
479 (SELECT player FROM players WHERE nick='Havok'),
482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
485 (SELECT player FROM players WHERE nick='Havok'),
487 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
490 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
491 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
493 (SELECT player FROM players WHERE nick='Draconia'),
496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
497 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
499 (SELECT player FROM players WHERE nick='Draconia'),
501 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
504 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
505 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
507 (SELECT player FROM players WHERE nick='Eilin'),
510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
511 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
513 (SELECT player FROM players WHERE nick='Eilin'),
515 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
518 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
521 (SELECT player FROM players WHERE nick='Lars Christian'),
524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
527 (SELECT player FROM players WHERE nick='Lars Christian'),
529 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
532 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
535 (SELECT player FROM players WHERE nick='Ole'),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
541 (SELECT player FROM players WHERE nick='Ole'),
543 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
546 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
549 (SELECT player FROM players WHERE nick='Snute'),
552 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
553 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
555 (SELECT player FROM players WHERE nick='Snute'),
557 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
560 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
563 (SELECT player FROM players WHERE nick='Th0rny'),
566 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
569 (SELECT player FROM players WHERE nick='Th0rny'),
571 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
575 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
577 (SELECT player FROM players WHERE nick='Daniil'),
580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
583 (SELECT player FROM players WHERE nick='Daniil'),
585 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
588 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
590 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
593 INSERT INTO groups (tournament, round, parallel) VALUES (
594 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
596 UPDATE rounds SET randomsongs=0 WHERE
597 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
599 UPDATE rounds SET chosensongs=1 WHERE
600 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
605 (SELECT player FROM players WHERE nick='Lejordet'),
608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
611 (SELECT player FROM players WHERE nick='Lejordet'),
613 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
616 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
619 (SELECT player FROM players WHERE nick='kjmcw'),
622 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
625 (SELECT player FROM players WHERE nick='kjmcw'),
627 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
630 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
633 (SELECT player FROM players WHERE nick='Draconia'),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
639 (SELECT player FROM players WHERE nick='Draconia'),
641 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
647 (SELECT player FROM players WHERE nick='Snute'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
653 (SELECT player FROM players WHERE nick='Snute'),
655 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
658 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
661 (SELECT player FROM players WHERE nick='Daniil'),
664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
665 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
667 (SELECT player FROM players WHERE nick='Daniil'),
669 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
672 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
673 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
675 (SELECT player FROM players WHERE nick='Havok'),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
681 (SELECT player FROM players WHERE nick='Havok'),
683 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
686 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
689 (SELECT player FROM players WHERE nick='Th0rny'),
692 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
695 (SELECT player FROM players WHERE nick='Th0rny'),
697 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
700 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
701 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
703 (SELECT player FROM players WHERE nick='Ole'),
706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
707 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
709 (SELECT player FROM players WHERE nick='Ole'),
711 (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
717 (SELECT player FROM players WHERE nick='Lars Christian'),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
723 (SELECT player FROM players WHERE nick='Lars Christian'),
725 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
728 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
730 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
733 INSERT INTO groups (tournament, round, parallel) VALUES (
734 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
736 UPDATE rounds SET randomsongs=0 WHERE
737 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
739 UPDATE rounds SET chosensongs=1 WHERE
740 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
742 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
745 (SELECT player FROM players WHERE nick='kjmcw'),
748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
749 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
751 (SELECT player FROM players WHERE nick='kjmcw'),
753 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
756 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
757 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
759 (SELECT player FROM players WHERE nick='Lars Christian'),
762 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
763 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
765 (SELECT player FROM players WHERE nick='Lars Christian'),
767 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
770 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
771 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
773 (SELECT player FROM players WHERE nick='Ole'),
776 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
779 (SELECT player FROM players WHERE nick='Ole'),
781 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
784 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
785 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
787 (SELECT player FROM players WHERE nick='Draconia'),
790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
793 (SELECT player FROM players WHERE nick='Draconia'),
795 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
798 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
799 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
801 (SELECT player FROM players WHERE nick='Havok'),
804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
807 (SELECT player FROM players WHERE nick='Havok'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
812 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
813 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
815 (SELECT player FROM players WHERE nick='Snute'),
818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
821 (SELECT player FROM players WHERE nick='Snute'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
826 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
829 (SELECT player FROM players WHERE nick='Daniil'),
832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
833 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
835 (SELECT player FROM players WHERE nick='Daniil'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
840 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
843 (SELECT player FROM players WHERE nick='Th0rny'),
846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
847 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
849 (SELECT player FROM players WHERE nick='Th0rny'),
851 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
854 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
856 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
859 INSERT INTO groups (tournament, round, parallel) VALUES (
860 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
862 UPDATE rounds SET randomsongs=0 WHERE
863 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
865 UPDATE rounds SET chosensongs=1 WHERE
866 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
868 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
871 (SELECT player FROM players WHERE nick='Draconia'),
874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
875 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
877 (SELECT player FROM players WHERE nick='Draconia'),
879 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
882 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
883 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
885 (SELECT player FROM players WHERE nick='kjmcw'),
888 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
889 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
891 (SELECT player FROM players WHERE nick='kjmcw'),
893 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
896 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
897 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
899 (SELECT player FROM players WHERE nick='Snute'),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
905 (SELECT player FROM players WHERE nick='Snute'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
910 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
913 (SELECT player FROM players WHERE nick='Ole'),
916 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
917 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
919 (SELECT player FROM players WHERE nick='Ole'),
921 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
924 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
925 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
927 (SELECT player FROM players WHERE nick='Havok'),
930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
931 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
933 (SELECT player FROM players WHERE nick='Havok'),
935 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
938 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
939 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
941 (SELECT player FROM players WHERE nick='Lars Christian'),
944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
947 (SELECT player FROM players WHERE nick='Lars Christian'),
949 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
952 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
955 (SELECT player FROM players WHERE nick='Daniil'),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
961 (SELECT player FROM players WHERE nick='Daniil'),
963 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
966 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
968 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
971 INSERT INTO groups (tournament, round, parallel) VALUES (
972 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
974 UPDATE rounds SET randomsongs=0 WHERE
975 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
977 UPDATE rounds SET chosensongs=1 WHERE
978 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
980 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
983 (SELECT player FROM players WHERE nick='Havok'),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
989 (SELECT player FROM players WHERE nick='Havok'),
991 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
994 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
997 (SELECT player FROM players WHERE nick='Lars Christian'),
1000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1003 (SELECT player FROM players WHERE nick='Lars Christian'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1008 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1011 (SELECT player FROM players WHERE nick='kjmcw'),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1017 (SELECT player FROM players WHERE nick='kjmcw'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1022 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1023 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1025 (SELECT player FROM players WHERE nick='Daniil'),
1028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1031 (SELECT player FROM players WHERE nick='Daniil'),
1033 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1039 (SELECT player FROM players WHERE nick='Ole'),
1042 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1045 (SELECT player FROM players WHERE nick='Ole'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1050 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1051 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1053 (SELECT player FROM players WHERE nick='Draconia'),
1056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1059 (SELECT player FROM players WHERE nick='Draconia'),
1061 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
1064 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1066 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1069 INSERT INTO groups (tournament, round, parallel) VALUES (
1070 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1072 UPDATE rounds SET randomsongs=0 WHERE
1073 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1075 UPDATE rounds SET chosensongs=1 WHERE
1076 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1078 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1079 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1081 (SELECT player FROM players WHERE nick='Draconia'),
1084 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1087 (SELECT player FROM players WHERE nick='Draconia'),
1089 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1092 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1093 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1095 (SELECT player FROM players WHERE nick='Daniil'),
1098 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1099 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1101 (SELECT player FROM players WHERE nick='Daniil'),
1103 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1106 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1107 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1109 (SELECT player FROM players WHERE nick='Lars Christian'),
1112 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1115 (SELECT player FROM players WHERE nick='Lars Christian'),
1117 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1123 (SELECT player FROM players WHERE nick='Ole'),
1126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1129 (SELECT player FROM players WHERE nick='Ole'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1134 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1135 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1137 (SELECT player FROM players WHERE nick='Havok'),
1140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1143 (SELECT player FROM players WHERE nick='Havok'),
1145 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1148 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1150 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1153 INSERT INTO groups (tournament, round, parallel) VALUES (
1154 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1156 UPDATE rounds SET randomsongs=0 WHERE
1157 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1159 UPDATE rounds SET chosensongs=1 WHERE
1160 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1162 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1163 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1165 (SELECT player FROM players WHERE nick='Draconia'),
1168 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1169 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1171 (SELECT player FROM players WHERE nick='Draconia'),
1173 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1176 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1177 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1179 (SELECT player FROM players WHERE nick='Daniil'),
1182 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1183 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1185 (SELECT player FROM players WHERE nick='Daniil'),
1187 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1190 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1191 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1193 (SELECT player FROM players WHERE nick='Lars Christian'),
1196 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1197 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1199 (SELECT player FROM players WHERE nick='Lars Christian'),
1201 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1204 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1205 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1207 (SELECT player FROM players WHERE nick='Havok'),
1210 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1211 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1213 (SELECT player FROM players WHERE nick='Havok'),
1215 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1218 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1220 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1223 INSERT INTO groups (tournament, round, parallel) VALUES (
1224 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1226 UPDATE rounds SET randomsongs=0 WHERE
1227 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1229 UPDATE rounds SET chosensongs=1 WHERE
1230 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1232 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1235 (SELECT player FROM players WHERE nick='Lars Christian'),
1238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1241 (SELECT player FROM players WHERE nick='Lars Christian'),
1243 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1249 (SELECT player FROM players WHERE nick='Havok'),
1252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1253 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1255 (SELECT player FROM players WHERE nick='Havok'),
1257 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1260 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1261 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1263 (SELECT player FROM players WHERE nick='Daniil'),
1266 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1267 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1269 (SELECT player FROM players WHERE nick='Daniil'),
1271 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1274 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1276 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1279 INSERT INTO groups (tournament, round, parallel) VALUES (
1280 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1282 UPDATE rounds SET randomsongs=0 WHERE
1283 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1285 UPDATE rounds SET chosensongs=1 WHERE
1286 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
1288 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1289 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1291 (SELECT player FROM players WHERE nick='Lars Christian'),
1294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1295 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1297 (SELECT player FROM players WHERE nick='Lars Christian'),
1299 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1302 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1303 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1305 (SELECT player FROM players WHERE nick='Havok'),
1308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1309 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 04' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
1311 (SELECT player FROM players WHERE nick='Havok'),
1313 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),