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 05' 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, 'Th0rny' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
22 (SELECT player FROM players WHERE nick='Th0rny'),
24 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 );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
28 (SELECT player FROM players WHERE nick='Snute'),
30 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 );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
34 (SELECT player FROM players WHERE nick='kjmcw'),
36 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 );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
40 (SELECT player FROM players WHERE nick='Slusk'),
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 05' 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, 'wa-ho' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'wa-ho' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
52 (SELECT player FROM players WHERE nick='wa-ho'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
58 (SELECT player FROM players WHERE nick='Lejordet'),
60 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
62 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
65 INSERT INTO groups (tournament, round, parallel) VALUES (
66 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
68 UPDATE rounds SET randomsongs=0 WHERE
69 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
71 UPDATE rounds SET chosensongs=1 WHERE
72 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
74 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
75 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
77 (SELECT player FROM players WHERE nick='Daniil'),
80 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
81 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
83 (SELECT player FROM players WHERE nick='Daniil'),
85 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
88 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
89 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
91 (SELECT player FROM players WHERE nick='Th0rny'),
94 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
95 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
97 (SELECT player FROM players WHERE nick='Th0rny'),
99 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
102 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
103 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
105 (SELECT player FROM players WHERE nick='Snute'),
108 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
109 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
111 (SELECT player FROM players WHERE nick='Snute'),
113 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
116 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
117 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
119 (SELECT player FROM players WHERE nick='Slusk'),
122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
125 (SELECT player FROM players WHERE nick='Slusk'),
127 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
131 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
133 (SELECT player FROM players WHERE nick='kjmcw'),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
139 (SELECT player FROM players WHERE nick='kjmcw'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
144 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
147 (SELECT player FROM players WHERE nick='Eilin'),
150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
151 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
153 (SELECT player FROM players WHERE nick='Eilin'),
155 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
158 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
161 (SELECT player FROM players WHERE nick='wa-ho'),
164 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
165 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
167 (SELECT player FROM players WHERE nick='wa-ho'),
169 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
172 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
173 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
175 (SELECT player FROM players WHERE nick='Lejordet'),
178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
179 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
181 (SELECT player FROM players WHERE nick='Lejordet'),
183 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
186 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
188 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
191 INSERT INTO groups (tournament, round, parallel) VALUES (
192 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
194 UPDATE rounds SET randomsongs=0 WHERE
195 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
197 UPDATE rounds SET chosensongs=1 WHERE
198 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
200 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
201 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
203 (SELECT player FROM players WHERE nick='Daniil'),
206 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
207 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
209 (SELECT player FROM players WHERE nick='Daniil'),
211 (SELECT song FROM songs WHERE lower(title)=lower('Let the Beat Hit \'em!')),
214 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
215 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
217 (SELECT player FROM players WHERE nick='Snute'),
220 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
221 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
223 (SELECT player FROM players WHERE nick='Snute'),
225 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
228 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
229 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
231 (SELECT player FROM players WHERE nick='Slusk'),
234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
237 (SELECT player FROM players WHERE nick='Slusk'),
239 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
245 (SELECT player FROM players WHERE nick='Th0rny'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
251 (SELECT player FROM players WHERE nick='Th0rny'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
256 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
259 (SELECT player FROM players WHERE nick='kjmcw'),
262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
263 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
265 (SELECT player FROM players WHERE nick='kjmcw'),
267 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
270 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
271 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
273 (SELECT player FROM players WHERE nick='wa-ho'),
276 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
279 (SELECT player FROM players WHERE nick='wa-ho'),
281 (SELECT song FROM songs WHERE lower(title)=lower('Never Gonna Make (Factory Team Mix)')),
284 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
285 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
287 (SELECT player FROM players WHERE nick='Eilin'),
290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
293 (SELECT player FROM players WHERE nick='Eilin'),
295 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
298 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
300 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
303 INSERT INTO groups (tournament, round, parallel) VALUES (
304 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
306 UPDATE rounds SET randomsongs=0 WHERE
307 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
309 UPDATE rounds SET chosensongs=1 WHERE
310 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
315 (SELECT player FROM players WHERE nick='Slusk'),
318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
319 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
321 (SELECT player FROM players WHERE nick='Slusk'),
323 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
326 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
327 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
329 (SELECT player FROM players WHERE nick='Snute'),
332 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
335 (SELECT player FROM players WHERE nick='Snute'),
337 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
340 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
341 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
343 (SELECT player FROM players WHERE nick='kjmcw'),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
349 (SELECT player FROM players WHERE nick='kjmcw'),
351 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
354 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
357 (SELECT player FROM players WHERE nick='Eilin'),
360 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
361 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
363 (SELECT player FROM players WHERE nick='Eilin'),
365 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
368 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
371 (SELECT player FROM players WHERE nick='Daniil'),
374 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
375 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
377 (SELECT player FROM players WHERE nick='Daniil'),
379 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
382 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
383 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
385 (SELECT player FROM players WHERE nick='Th0rny'),
388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
391 (SELECT player FROM players WHERE nick='Th0rny'),
393 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
396 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
398 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
401 INSERT INTO groups (tournament, round, parallel) VALUES (
402 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
404 UPDATE rounds SET randomsongs=0 WHERE
405 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
407 UPDATE rounds SET chosensongs=1 WHERE
408 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
410 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
411 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
413 (SELECT player FROM players WHERE nick='Snute'),
416 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
417 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
419 (SELECT player FROM players WHERE nick='Snute'),
421 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
424 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
425 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
427 (SELECT player FROM players WHERE nick='Th0rny'),
430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
431 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
433 (SELECT player FROM players WHERE nick='Th0rny'),
435 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
438 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
439 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
441 (SELECT player FROM players WHERE nick='Daniil'),
444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
447 (SELECT player FROM players WHERE nick='Daniil'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
452 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
455 (SELECT player FROM players WHERE nick='Slusk'),
458 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
459 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
461 (SELECT player FROM players WHERE nick='Slusk'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
466 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
467 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
469 (SELECT player FROM players WHERE nick='kjmcw'),
472 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
473 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
475 (SELECT player FROM players WHERE nick='kjmcw'),
477 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
480 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
482 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
485 INSERT INTO groups (tournament, round, parallel) VALUES (
486 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
488 UPDATE rounds SET randomsongs=0 WHERE
489 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
491 UPDATE rounds SET chosensongs=1 WHERE
492 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
494 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
495 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
497 (SELECT player FROM players WHERE nick='kjmcw'),
500 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
501 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
503 (SELECT player FROM players WHERE nick='kjmcw'),
505 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
508 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
509 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
511 (SELECT player FROM players WHERE nick='Daniil'),
514 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
515 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
517 (SELECT player FROM players WHERE nick='Daniil'),
519 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
522 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
523 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
525 (SELECT player FROM players WHERE nick='Snute'),
528 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
529 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
531 (SELECT player FROM players WHERE nick='Snute'),
533 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
536 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
537 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
539 (SELECT player FROM players WHERE nick='Th0rny'),
542 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
543 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
545 (SELECT player FROM players WHERE nick='Th0rny'),
547 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
550 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
552 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
555 INSERT INTO groups (tournament, round, parallel) VALUES (
556 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
558 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
559 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
561 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
563 UPDATE rounds SET randomsongs=1 WHERE
564 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
566 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
569 (SELECT player FROM players WHERE nick='Snute'),
572 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
573 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
575 (SELECT player FROM players WHERE nick='Snute'),
577 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
580 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
583 (SELECT player FROM players WHERE nick='Th0rny'),
586 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
587 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
589 (SELECT player FROM players WHERE nick='Th0rny'),
591 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
594 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
597 (SELECT player FROM players WHERE nick='Daniil'),
600 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
601 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
603 (SELECT player FROM players WHERE nick='Daniil'),
605 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
608 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
610 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
613 INSERT INTO groups (tournament, round, parallel) VALUES (
614 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
616 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
619 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
621 UPDATE rounds SET randomsongs=1 WHERE
622 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )) AND
624 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
625 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
627 (SELECT player FROM players WHERE nick='Daniil'),
630 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
633 (SELECT player FROM players WHERE nick='Daniil'),
635 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
639 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
641 (SELECT player FROM players WHERE nick='Th0rny'),
644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='Euromix2 serie 05' AND season=( SELECT season FROM seasons WHERE seasonname='Euromix 2-serie 2002' )),
647 (SELECT player FROM players WHERE nick='Th0rny'),
649 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),