2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='Geneva Tournament' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
5 'Geneva Tournament IV (score)',
6 (SELECT country FROM countries WHERE countryname='Switzerland'),
7 'Las Vegas - Switzerland',
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, 'Dex' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dex' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
16 (SELECT player FROM players WHERE nick='Dex'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lord Glenn' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lord Glenn' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
22 (SELECT player FROM players WHERE nick='Lord Glenn'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'F Destroyer' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'F Destroyer' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
28 (SELECT player FROM players WHERE nick='F Destroyer'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Boli' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Boli' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
34 (SELECT player FROM players WHERE nick='Boli'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Shiniji' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Shiniji' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
40 (SELECT player FROM players WHERE nick='Shiniji'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T Master' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T Master' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
46 (SELECT player FROM players WHERE nick='T Master'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Loopy Chew' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Loopy Chew' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
52 (SELECT player FROM players WHERE nick='Loopy Chew'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Simon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Simon' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
58 (SELECT player FROM players WHERE nick='Simon'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jucelin' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jucelin' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
64 (SELECT player FROM players WHERE nick='Jucelin'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jose' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jose' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
70 (SELECT player FROM players WHERE nick='Jose'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kyo X' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kyo X' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
76 (SELECT player FROM players WHERE nick='Kyo X'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hirro' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Hirro' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
82 (SELECT player FROM players WHERE nick='Hirro'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ganon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ganon' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
88 (SELECT player FROM players WHERE nick='Ganon'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Red Baron' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Red Baron' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
94 (SELECT player FROM players WHERE nick='Red Baron'),
96 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
98 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
101 INSERT INTO groups (tournament, round, parallel) VALUES (
102 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
104 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
105 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
107 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
109 UPDATE rounds SET randomsongs=1 WHERE
110 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
112 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
113 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
115 (SELECT player FROM players WHERE nick='Shiniji'),
118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
119 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
121 (SELECT player FROM players WHERE nick='Shiniji'),
123 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
126 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
127 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
129 (SELECT player FROM players WHERE nick='Simon'),
132 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
133 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
135 (SELECT player FROM players WHERE nick='Simon'),
137 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
140 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
141 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
143 (SELECT player FROM players WHERE nick='F Destroyer'),
146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
147 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
149 (SELECT player FROM players WHERE nick='F Destroyer'),
151 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
154 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
155 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
157 (SELECT player FROM players WHERE nick='T Master'),
160 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
161 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
163 (SELECT player FROM players WHERE nick='T Master'),
165 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
168 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
169 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
171 (SELECT player FROM players WHERE nick='Red Baron'),
174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
177 (SELECT player FROM players WHERE nick='Red Baron'),
179 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
185 (SELECT player FROM players WHERE nick='Kyo X'),
188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
191 (SELECT player FROM players WHERE nick='Kyo X'),
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='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
199 (SELECT player FROM players WHERE nick='Hirro'),
202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
203 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
205 (SELECT player FROM players WHERE nick='Hirro'),
207 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
210 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
211 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
213 (SELECT player FROM players WHERE nick='Ganon'),
216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
217 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
219 (SELECT player FROM players WHERE nick='Ganon'),
221 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
225 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
227 (SELECT player FROM players WHERE nick='Lord Glenn'),
230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
233 (SELECT player FROM players WHERE nick='Lord Glenn'),
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='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
241 (SELECT player FROM players WHERE nick='Jucelin'),
244 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
245 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
247 (SELECT player FROM players WHERE nick='Jucelin'),
249 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
252 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
255 (SELECT player FROM players WHERE nick='Dex'),
258 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
259 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
261 (SELECT player FROM players WHERE nick='Dex'),
263 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
266 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
267 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
269 (SELECT player FROM players WHERE nick='Boli'),
272 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
275 (SELECT player FROM players WHERE nick='Boli'),
277 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
280 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
281 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
283 (SELECT player FROM players WHERE nick='Jose'),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
289 (SELECT player FROM players WHERE nick='Jose'),
291 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
294 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
297 (SELECT player FROM players WHERE nick='Loopy Chew'),
300 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
301 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
303 (SELECT player FROM players WHERE nick='Loopy Chew'),
305 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
308 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
310 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
313 INSERT INTO groups (tournament, round, parallel) VALUES (
314 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
316 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
319 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
321 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
322 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
324 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
326 UPDATE rounds SET randomsongs=2 WHERE
327 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
329 UPDATE rounds SET chosensongs=1 WHERE
330 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
332 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
335 (SELECT player FROM players WHERE nick='Ganon'),
338 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
341 (SELECT player FROM players WHERE nick='Ganon'),
343 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
349 (SELECT player FROM players WHERE nick='Ganon'),
351 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
357 (SELECT player FROM players WHERE nick='Ganon'),
359 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
362 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
365 (SELECT player FROM players WHERE nick='Loopy Chew'),
368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
371 (SELECT player FROM players WHERE nick='Loopy Chew'),
373 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
379 (SELECT player FROM players WHERE nick='Loopy Chew'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
387 (SELECT player FROM players WHERE nick='Loopy Chew'),
389 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
392 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
395 (SELECT player FROM players WHERE nick='Kyo X'),
398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
401 (SELECT player FROM players WHERE nick='Kyo X'),
403 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
406 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
409 (SELECT player FROM players WHERE nick='Kyo X'),
411 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
417 (SELECT player FROM players WHERE nick='Kyo X'),
419 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
422 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
425 (SELECT player FROM players WHERE nick='Jucelin'),
428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
431 (SELECT player FROM players WHERE nick='Jucelin'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
439 (SELECT player FROM players WHERE nick='Jucelin'),
441 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
447 (SELECT player FROM players WHERE nick='Jucelin'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
452 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
455 (SELECT player FROM players WHERE nick='Shiniji'),
458 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
459 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
461 (SELECT player FROM players WHERE nick='Shiniji'),
463 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
466 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
467 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
469 (SELECT player FROM players WHERE nick='Shiniji'),
471 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
475 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
477 (SELECT player FROM players WHERE nick='Shiniji'),
479 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
485 (SELECT player FROM players WHERE nick='Lord Glenn'),
488 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
489 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
491 (SELECT player FROM players WHERE nick='Lord Glenn'),
493 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
497 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
499 (SELECT player FROM players WHERE nick='Lord Glenn'),
501 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
504 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
505 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
507 (SELECT player FROM players WHERE nick='Lord Glenn'),
509 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
512 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
513 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
515 (SELECT player FROM players WHERE nick='Dex'),
518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
521 (SELECT player FROM players WHERE nick='Dex'),
523 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
526 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
527 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
529 (SELECT player FROM players WHERE nick='Dex'),
531 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
534 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
535 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
537 (SELECT player FROM players WHERE nick='Dex'),
539 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
542 INSERT INTO groups (tournament, round, parallel) VALUES (
543 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
545 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
546 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
548 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
550 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
551 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
553 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story'))
555 UPDATE rounds SET randomsongs=2 WHERE
556 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
558 UPDATE rounds SET chosensongs=1 WHERE
559 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
561 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
562 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
564 (SELECT player FROM players WHERE nick='Red Baron'),
567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
568 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
570 (SELECT player FROM players WHERE nick='Red Baron'),
572 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
575 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
576 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
578 (SELECT player FROM players WHERE nick='Red Baron'),
580 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
583 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
584 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
586 (SELECT player FROM players WHERE nick='Red Baron'),
588 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
591 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
592 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
594 (SELECT player FROM players WHERE nick='Hirro'),
597 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
598 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
600 (SELECT player FROM players WHERE nick='Hirro'),
602 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
605 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
606 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
608 (SELECT player FROM players WHERE nick='Hirro'),
610 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
613 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
614 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
616 (SELECT player FROM players WHERE nick='Hirro'),
618 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
621 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
622 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
624 (SELECT player FROM players WHERE nick='Jose'),
627 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
628 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
630 (SELECT player FROM players WHERE nick='Jose'),
632 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
635 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
636 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
638 (SELECT player FROM players WHERE nick='Jose'),
640 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
643 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
644 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
646 (SELECT player FROM players WHERE nick='Jose'),
648 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
651 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
652 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
654 (SELECT player FROM players WHERE nick='T Master'),
657 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
658 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
660 (SELECT player FROM players WHERE nick='T Master'),
662 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
665 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
666 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
668 (SELECT player FROM players WHERE nick='T Master'),
670 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
673 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
674 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
676 (SELECT player FROM players WHERE nick='T Master'),
678 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
681 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
682 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
684 (SELECT player FROM players WHERE nick='Simon'),
687 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
688 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
690 (SELECT player FROM players WHERE nick='Simon'),
692 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
695 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
696 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
698 (SELECT player FROM players WHERE nick='Simon'),
700 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
703 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
704 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
706 (SELECT player FROM players WHERE nick='Simon'),
708 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
711 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
712 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
714 (SELECT player FROM players WHERE nick='F Destroyer'),
717 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
718 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
720 (SELECT player FROM players WHERE nick='F Destroyer'),
722 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
725 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
726 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
728 (SELECT player FROM players WHERE nick='F Destroyer'),
730 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
733 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
734 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
736 (SELECT player FROM players WHERE nick='F Destroyer'),
738 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
741 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
742 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
744 (SELECT player FROM players WHERE nick='Boli'),
747 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
748 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
750 (SELECT player FROM players WHERE nick='Boli'),
752 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
755 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
756 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
758 (SELECT player FROM players WHERE nick='Boli'),
760 (SELECT song FROM songs WHERE lower(title)=lower('Never Ending Story')),
763 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
764 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
766 (SELECT player FROM players WHERE nick='Boli'),
768 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
771 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
773 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
776 INSERT INTO groups (tournament, round, parallel) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
779 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
780 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
782 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
784 UPDATE rounds SET randomsongs=1 WHERE
785 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
787 UPDATE rounds SET chosensongs=1 WHERE
788 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
790 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
793 (SELECT player FROM players WHERE nick='Jucelin'),
796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
797 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
799 (SELECT player FROM players WHERE nick='Jucelin'),
801 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
807 (SELECT player FROM players WHERE nick='Jucelin'),
809 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
812 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
813 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
815 (SELECT player FROM players WHERE nick='Simon'),
818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
821 (SELECT player FROM players WHERE nick='Simon'),
823 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
826 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
829 (SELECT player FROM players WHERE nick='Simon'),
831 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
834 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
837 (SELECT player FROM players WHERE nick='Shiniji'),
840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
843 (SELECT player FROM players WHERE nick='Shiniji'),
845 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
851 (SELECT player FROM players WHERE nick='Shiniji'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
856 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
857 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
859 (SELECT player FROM players WHERE nick='Jose'),
862 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
863 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
865 (SELECT player FROM players WHERE nick='Jose'),
867 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
870 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
871 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
873 (SELECT player FROM players WHERE nick='Jose'),
875 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
878 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
879 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
881 (SELECT player FROM players WHERE nick='Loopy Chew'),
884 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
885 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
887 (SELECT player FROM players WHERE nick='Loopy Chew'),
889 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
892 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
893 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
895 (SELECT player FROM players WHERE nick='Loopy Chew'),
897 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
900 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
901 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
903 (SELECT player FROM players WHERE nick='T Master'),
906 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
907 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
909 (SELECT player FROM players WHERE nick='T Master'),
911 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
914 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
915 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
917 (SELECT player FROM players WHERE nick='T Master'),
919 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
922 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
923 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
925 (SELECT player FROM players WHERE nick='Lord Glenn'),
928 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
931 (SELECT player FROM players WHERE nick='Lord Glenn'),
933 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
936 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
937 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
939 (SELECT player FROM players WHERE nick='Lord Glenn'),
941 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
944 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
947 (SELECT player FROM players WHERE nick='Boli'),
950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
953 (SELECT player FROM players WHERE nick='Boli'),
955 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
961 (SELECT player FROM players WHERE nick='Boli'),
963 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
966 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
969 (SELECT player FROM players WHERE nick='Dex'),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
975 (SELECT player FROM players WHERE nick='Dex'),
977 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
980 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
983 (SELECT player FROM players WHERE nick='Dex'),
985 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
988 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
991 (SELECT player FROM players WHERE nick='F Destroyer'),
994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
997 (SELECT player FROM players WHERE nick='F Destroyer'),
999 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1005 (SELECT player FROM players WHERE nick='F Destroyer'),
1007 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1010 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1012 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1015 INSERT INTO groups (tournament, round, parallel) VALUES (
1016 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1018 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1021 (SELECT song FROM songs WHERE lower(title)=lower('Higher'))
1023 UPDATE rounds SET randomsongs=1 WHERE
1024 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1026 UPDATE rounds SET chosensongs=1 WHERE
1027 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1029 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1030 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1032 (SELECT player FROM players WHERE nick='Simon'),
1035 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1036 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1038 (SELECT player FROM players WHERE nick='Simon'),
1040 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1043 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1044 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1046 (SELECT player FROM players WHERE nick='Simon'),
1048 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1051 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1052 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1054 (SELECT player FROM players WHERE nick='T Master'),
1057 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1058 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1060 (SELECT player FROM players WHERE nick='T Master'),
1062 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1065 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1066 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1068 (SELECT player FROM players WHERE nick='T Master'),
1070 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1073 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1074 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1076 (SELECT player FROM players WHERE nick='Shiniji'),
1079 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1080 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1082 (SELECT player FROM players WHERE nick='Shiniji'),
1084 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1087 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1088 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1090 (SELECT player FROM players WHERE nick='Shiniji'),
1092 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1095 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1096 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1098 (SELECT player FROM players WHERE nick='Boli'),
1101 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1102 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1104 (SELECT player FROM players WHERE nick='Boli'),
1106 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1109 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1110 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1112 (SELECT player FROM players WHERE nick='Boli'),
1114 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1117 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1118 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1120 (SELECT player FROM players WHERE nick='Loopy Chew'),
1123 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1124 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1126 (SELECT player FROM players WHERE nick='Loopy Chew'),
1128 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1131 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1132 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1134 (SELECT player FROM players WHERE nick='Loopy Chew'),
1136 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1139 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1140 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1142 (SELECT player FROM players WHERE nick='F Destroyer'),
1145 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1146 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1148 (SELECT player FROM players WHERE nick='F Destroyer'),
1150 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1153 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1154 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1156 (SELECT player FROM players WHERE nick='F Destroyer'),
1158 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1161 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1164 (SELECT player FROM players WHERE nick='Lord Glenn'),
1167 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1168 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1170 (SELECT player FROM players WHERE nick='Lord Glenn'),
1172 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1175 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1176 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1178 (SELECT player FROM players WHERE nick='Lord Glenn'),
1180 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1183 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1184 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1186 (SELECT player FROM players WHERE nick='Dex'),
1189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1190 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1192 (SELECT player FROM players WHERE nick='Dex'),
1194 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
1197 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1198 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1200 (SELECT player FROM players WHERE nick='Dex'),
1202 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1205 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1207 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1210 INSERT INTO groups (tournament, round, parallel) VALUES (
1211 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1213 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1214 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1216 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky'))
1218 UPDATE rounds SET randomsongs=1 WHERE
1219 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1221 UPDATE rounds SET chosensongs=1 WHERE
1222 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1224 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1227 (SELECT player FROM players WHERE nick='Shiniji'),
1230 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1231 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1233 (SELECT player FROM players WHERE nick='Shiniji'),
1235 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1241 (SELECT player FROM players WHERE nick='Shiniji'),
1243 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1249 (SELECT player FROM players WHERE nick='T Master'),
1252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1253 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1255 (SELECT player FROM players WHERE nick='T Master'),
1257 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1261 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1263 (SELECT player FROM players WHERE nick='T Master'),
1265 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1268 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1269 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1271 (SELECT player FROM players WHERE nick='Boli'),
1274 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1275 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1277 (SELECT player FROM players WHERE nick='Boli'),
1279 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1283 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1285 (SELECT player FROM players WHERE nick='Boli'),
1287 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1290 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1291 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1293 (SELECT player FROM players WHERE nick='F Destroyer'),
1296 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1297 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1299 (SELECT player FROM players WHERE nick='F Destroyer'),
1301 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1304 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1305 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1307 (SELECT player FROM players WHERE nick='F Destroyer'),
1309 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1312 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1313 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1315 (SELECT player FROM players WHERE nick='Lord Glenn'),
1318 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1319 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1321 (SELECT player FROM players WHERE nick='Lord Glenn'),
1323 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1326 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1327 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1329 (SELECT player FROM players WHERE nick='Lord Glenn'),
1331 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1334 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1335 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1337 (SELECT player FROM players WHERE nick='Dex'),
1340 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1341 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1343 (SELECT player FROM players WHERE nick='Dex'),
1345 (SELECT song FROM songs WHERE lower(title)=lower('Look to the sky')),
1348 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1349 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1351 (SELECT player FROM players WHERE nick='Dex'),
1353 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1356 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1358 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1361 INSERT INTO groups (tournament, round, parallel) VALUES (
1362 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1364 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1365 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1367 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
1369 UPDATE rounds SET randomsongs=1 WHERE
1370 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1372 UPDATE rounds SET chosensongs=1 WHERE
1373 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1375 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1376 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1378 (SELECT player FROM players WHERE nick='Boli'),
1381 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1382 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1384 (SELECT player FROM players WHERE nick='Boli'),
1386 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1389 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1390 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1392 (SELECT player FROM players WHERE nick='Boli'),
1394 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1397 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1398 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1400 (SELECT player FROM players WHERE nick='Lord Glenn'),
1403 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1404 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1406 (SELECT player FROM players WHERE nick='Lord Glenn'),
1408 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1411 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1412 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1414 (SELECT player FROM players WHERE nick='Lord Glenn'),
1416 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1419 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1420 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1422 (SELECT player FROM players WHERE nick='F Destroyer'),
1425 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1426 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1428 (SELECT player FROM players WHERE nick='F Destroyer'),
1430 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1433 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1434 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1436 (SELECT player FROM players WHERE nick='F Destroyer'),
1438 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1441 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1442 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1444 (SELECT player FROM players WHERE nick='Dex'),
1447 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1448 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1450 (SELECT player FROM players WHERE nick='Dex'),
1452 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1455 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1456 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1458 (SELECT player FROM players WHERE nick='Dex'),
1460 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1463 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1465 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1468 INSERT INTO groups (tournament, round, parallel) VALUES (
1469 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1471 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1472 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1474 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
1476 UPDATE rounds SET randomsongs=1 WHERE
1477 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1479 UPDATE rounds SET chosensongs=1 WHERE
1480 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1482 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1483 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1485 (SELECT player FROM players WHERE nick='F Destroyer'),
1488 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1489 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1491 (SELECT player FROM players WHERE nick='F Destroyer'),
1493 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1497 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1499 (SELECT player FROM players WHERE nick='F Destroyer'),
1501 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1504 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1505 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1507 (SELECT player FROM players WHERE nick='Lord Glenn'),
1510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1511 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1513 (SELECT player FROM players WHERE nick='Lord Glenn'),
1515 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1518 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1519 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1521 (SELECT player FROM players WHERE nick='Lord Glenn'),
1523 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1526 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1527 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1529 (SELECT player FROM players WHERE nick='Dex'),
1532 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1535 (SELECT player FROM players WHERE nick='Dex'),
1537 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1540 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1541 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1543 (SELECT player FROM players WHERE nick='Dex'),
1545 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1548 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1550 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1553 INSERT INTO groups (tournament, round, parallel) VALUES (
1554 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1556 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1557 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1559 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
1561 UPDATE rounds SET randomsongs=1 WHERE
1562 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1564 UPDATE rounds SET chosensongs=1 WHERE
1565 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )) AND
1567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1568 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1570 (SELECT player FROM players WHERE nick='Lord Glenn'),
1573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1574 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1576 (SELECT player FROM players WHERE nick='Lord Glenn'),
1578 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1582 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1584 (SELECT player FROM players WHERE nick='Lord Glenn'),
1586 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1589 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1590 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1592 (SELECT player FROM players WHERE nick='Dex'),
1595 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1596 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1598 (SELECT player FROM players WHERE nick='Dex'),
1600 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1604 (SELECT tournament FROM tournaments WHERE tournamentname='Geneva Tournament IV (score)' AND season=( SELECT season FROM seasons WHERE seasonname='Geneva Tournament' )),
1606 (SELECT player FROM players WHERE nick='Dex'),
1608 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),