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, 'Daniil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
16 (SELECT player FROM players WHERE nick='Daniil'),
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 01' 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, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
28 (SELECT player FROM players WHERE nick='Havok'),
30 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 );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
34 (SELECT player FROM players WHERE nick='Th0rny'),
36 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 );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
40 (SELECT player FROM players WHERE nick='kjmcw'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
46 (SELECT player FROM players WHERE nick='Eilin'),
48 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 );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
52 (SELECT player FROM players WHERE nick='Slusk'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
58 (SELECT player FROM players WHERE nick='Snute'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oxehunden' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oxehunden' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
64 (SELECT player FROM players WHERE nick='Oxehunden'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
70 (SELECT player FROM players WHERE nick='Lejordet'),
72 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
74 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
77 INSERT INTO groups (tournament, round, parallel) VALUES (
78 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
80 UPDATE rounds SET randomsongs=0 WHERE
81 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
83 UPDATE rounds SET chosensongs=1 WHERE
84 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
86 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
87 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
89 (SELECT player FROM players WHERE nick='Oxehunden'),
92 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
93 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
95 (SELECT player FROM players WHERE nick='Oxehunden'),
97 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
100 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
101 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
103 (SELECT player FROM players WHERE nick='Slusk'),
106 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
109 (SELECT player FROM players WHERE nick='Slusk'),
111 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
114 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
117 (SELECT player FROM players WHERE nick='Th0rny'),
120 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
121 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
123 (SELECT player FROM players WHERE nick='Th0rny'),
125 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
128 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
129 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
131 (SELECT player FROM players WHERE nick='Snute'),
134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
135 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
137 (SELECT player FROM players WHERE nick='Snute'),
139 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
142 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
143 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
145 (SELECT player FROM players WHERE nick='Lejordet'),
148 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
149 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
151 (SELECT player FROM players WHERE nick='Lejordet'),
153 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
156 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
157 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
159 (SELECT player FROM players WHERE nick='kjmcw'),
162 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
163 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
165 (SELECT player FROM players WHERE nick='kjmcw'),
167 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
170 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
171 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
173 (SELECT player FROM players WHERE nick='Havok'),
176 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
177 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
179 (SELECT player FROM players WHERE nick='Havok'),
181 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
184 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
185 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
187 (SELECT player FROM players WHERE nick='Daniil'),
190 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
191 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
193 (SELECT player FROM players WHERE nick='Daniil'),
195 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
198 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
199 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
201 (SELECT player FROM players WHERE nick='Lars Christian'),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
207 (SELECT player FROM players WHERE nick='Lars Christian'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
212 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
215 (SELECT player FROM players WHERE nick='Eilin'),
218 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
219 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
221 (SELECT player FROM players WHERE nick='Eilin'),
223 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
226 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
228 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
231 INSERT INTO groups (tournament, round, parallel) VALUES (
232 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
234 UPDATE rounds SET randomsongs=0 WHERE
235 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
237 UPDATE rounds SET chosensongs=1 WHERE
238 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
241 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
243 (SELECT player FROM players WHERE nick='Snute'),
246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
249 (SELECT player FROM players WHERE nick='Snute'),
251 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
254 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
255 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
257 (SELECT player FROM players WHERE nick='Eilin'),
260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
263 (SELECT player FROM players WHERE nick='Eilin'),
265 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
268 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
269 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
271 (SELECT player FROM players WHERE nick='Slusk'),
274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
275 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
277 (SELECT player FROM players WHERE nick='Slusk'),
279 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
282 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
283 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
285 (SELECT player FROM players WHERE nick='Daniil'),
288 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
289 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
291 (SELECT player FROM players WHERE nick='Daniil'),
293 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
296 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
297 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
299 (SELECT player FROM players WHERE nick='Lars Christian'),
302 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
305 (SELECT player FROM players WHERE nick='Lars Christian'),
307 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
310 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
311 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
313 (SELECT player FROM players WHERE nick='Oxehunden'),
316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
319 (SELECT player FROM players WHERE nick='Oxehunden'),
321 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
324 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
327 (SELECT player FROM players WHERE nick='Th0rny'),
330 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
331 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
333 (SELECT player FROM players WHERE nick='Th0rny'),
335 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
338 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
341 (SELECT player FROM players WHERE nick='kjmcw'),
344 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
345 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
347 (SELECT player FROM players WHERE nick='kjmcw'),
349 (SELECT song FROM songs WHERE lower(title)=lower('Cotton-Eye Joe')),
352 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
353 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
355 (SELECT player FROM players WHERE nick='Havok'),
358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
361 (SELECT player FROM players WHERE nick='Havok'),
363 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
366 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
368 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
371 INSERT INTO groups (tournament, round, parallel) VALUES (
372 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
374 UPDATE rounds SET randomsongs=0 WHERE
375 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
377 UPDATE rounds SET chosensongs=1 WHERE
378 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
380 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
381 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
383 (SELECT player FROM players WHERE nick='Havok'),
386 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
387 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
389 (SELECT player FROM players WHERE nick='Havok'),
391 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
394 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
395 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
397 (SELECT player FROM players WHERE nick='kjmcw'),
400 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
401 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
403 (SELECT player FROM players WHERE nick='kjmcw'),
405 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
408 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
409 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
411 (SELECT player FROM players WHERE nick='Th0rny'),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
417 (SELECT player FROM players WHERE nick='Th0rny'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
422 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
425 (SELECT player FROM players WHERE nick='Slusk'),
428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
431 (SELECT player FROM players WHERE nick='Slusk'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
436 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
439 (SELECT player FROM players WHERE nick='Snute'),
442 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
443 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
445 (SELECT player FROM players WHERE nick='Snute'),
447 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
450 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
451 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
453 (SELECT player FROM players WHERE nick='Eilin'),
456 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
457 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
459 (SELECT player FROM players WHERE nick='Eilin'),
461 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
464 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
465 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
467 (SELECT player FROM players WHERE nick='Lars Christian'),
470 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
471 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
473 (SELECT player FROM players WHERE nick='Lars Christian'),
475 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
478 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
479 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
481 (SELECT player FROM players WHERE nick='Daniil'),
484 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
485 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
487 (SELECT player FROM players WHERE nick='Daniil'),
489 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
492 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
494 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
497 INSERT INTO groups (tournament, round, parallel) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
500 UPDATE rounds SET randomsongs=0 WHERE
501 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
503 UPDATE rounds SET chosensongs=1 WHERE
504 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
506 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
507 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
509 (SELECT player FROM players WHERE nick='Eilin'),
512 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
513 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
515 (SELECT player FROM players WHERE nick='Eilin'),
517 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
520 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
521 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
523 (SELECT player FROM players WHERE nick='Lars Christian'),
526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
527 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
529 (SELECT player FROM players WHERE nick='Lars Christian'),
531 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
534 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
535 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
537 (SELECT player FROM players WHERE nick='Slusk'),
540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
541 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
543 (SELECT player FROM players WHERE nick='Slusk'),
545 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
548 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
549 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
551 (SELECT player FROM players WHERE nick='Th0rny'),
554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
555 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
557 (SELECT player FROM players WHERE nick='Th0rny'),
559 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
562 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
563 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
565 (SELECT player FROM players WHERE nick='Daniil'),
568 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
569 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
571 (SELECT player FROM players WHERE nick='Daniil'),
573 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
576 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
577 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
579 (SELECT player FROM players WHERE nick='kjmcw'),
582 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
583 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
585 (SELECT player FROM players WHERE nick='kjmcw'),
587 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
590 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
591 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
593 (SELECT player FROM players WHERE nick='Havok'),
596 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
597 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
599 (SELECT player FROM players WHERE nick='Havok'),
601 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
604 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
606 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
609 INSERT INTO groups (tournament, round, parallel) VALUES (
610 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
612 UPDATE rounds SET randomsongs=0 WHERE
613 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
615 UPDATE rounds SET chosensongs=1 WHERE
616 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
618 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
619 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
621 (SELECT player FROM players WHERE nick='Eilin'),
624 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
627 (SELECT player FROM players WHERE nick='Eilin'),
629 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
632 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
633 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
635 (SELECT player FROM players WHERE nick='Th0rny'),
638 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
639 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
641 (SELECT player FROM players WHERE nick='Th0rny'),
643 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
646 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
647 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
649 (SELECT player FROM players WHERE nick='Havok'),
652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
653 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
655 (SELECT player FROM players WHERE nick='Havok'),
657 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
660 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
661 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
663 (SELECT player FROM players WHERE nick='kjmcw'),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
669 (SELECT player FROM players WHERE nick='kjmcw'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
677 (SELECT player FROM players WHERE nick='Daniil'),
680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
681 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
683 (SELECT player FROM players WHERE nick='Daniil'),
685 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
688 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
689 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
691 (SELECT player FROM players WHERE nick='Lars Christian'),
694 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
695 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
697 (SELECT player FROM players WHERE nick='Lars Christian'),
699 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
702 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
704 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
707 INSERT INTO groups (tournament, round, parallel) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
710 UPDATE rounds SET randomsongs=0 WHERE
711 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
713 UPDATE rounds SET chosensongs=1 WHERE
714 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
716 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
717 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
719 (SELECT player FROM players WHERE nick='kjmcw'),
722 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
723 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
725 (SELECT player FROM players WHERE nick='kjmcw'),
727 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
730 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
731 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
733 (SELECT player FROM players WHERE nick='Havok'),
736 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
739 (SELECT player FROM players WHERE nick='Havok'),
741 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
744 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
745 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
747 (SELECT player FROM players WHERE nick='Th0rny'),
750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
751 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
753 (SELECT player FROM players WHERE nick='Th0rny'),
755 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
758 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
759 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
761 (SELECT player FROM players WHERE nick='Lars Christian'),
764 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
765 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
767 (SELECT player FROM players WHERE nick='Lars Christian'),
769 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
772 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
773 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
775 (SELECT player FROM players WHERE nick='Daniil'),
778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
779 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
781 (SELECT player FROM players WHERE nick='Daniil'),
783 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
786 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
788 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
791 INSERT INTO groups (tournament, round, parallel) VALUES (
792 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
794 UPDATE rounds SET randomsongs=0 WHERE
795 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
797 UPDATE rounds SET chosensongs=1 WHERE
798 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
800 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
801 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
803 (SELECT player FROM players WHERE nick='Daniil'),
806 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
807 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
809 (SELECT player FROM players WHERE nick='Daniil'),
811 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
814 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
815 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
817 (SELECT player FROM players WHERE nick='Th0rny'),
820 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
821 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
823 (SELECT player FROM players WHERE nick='Th0rny'),
825 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
828 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
829 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
831 (SELECT player FROM players WHERE nick='Lars Christian'),
834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
837 (SELECT player FROM players WHERE nick='Lars Christian'),
839 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
842 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
843 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
845 (SELECT player FROM players WHERE nick='Havok'),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
851 (SELECT player FROM players WHERE nick='Havok'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
856 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
858 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
861 INSERT INTO groups (tournament, round, parallel) VALUES (
862 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
864 UPDATE rounds SET randomsongs=0 WHERE
865 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
867 UPDATE rounds SET chosensongs=1 WHERE
868 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
870 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
871 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
873 (SELECT player FROM players WHERE nick='Havok'),
876 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
877 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
879 (SELECT player FROM players WHERE nick='Havok'),
881 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
884 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
885 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
887 (SELECT player FROM players WHERE nick='Lars Christian'),
890 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
891 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
893 (SELECT player FROM players WHERE nick='Lars Christian'),
895 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
898 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
899 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
901 (SELECT player FROM players WHERE nick='Daniil'),
904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
907 (SELECT player FROM players WHERE nick='Daniil'),
909 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
912 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
914 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
917 INSERT INTO groups (tournament, round, parallel) VALUES (
918 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
920 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
923 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)'))
925 UPDATE rounds SET randomsongs=1 WHERE
926 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
928 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
931 (SELECT player FROM players WHERE nick='Lars Christian'),
934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
937 (SELECT player FROM players WHERE nick='Lars Christian'),
939 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
942 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
945 (SELECT player FROM players WHERE nick='Daniil'),
948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
949 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 01' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
951 (SELECT player FROM players WHERE nick='Daniil'),
953 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),