2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='International' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
5 'European Tournament in London',
6 (SELECT country FROM countries WHERE countryname='Europe'),
7 'Namco Station - London (United Kingdom)',
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, 'Lion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lion' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
16 (SELECT player FROM players WHERE nick='Lion'),
18 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
22 (SELECT player FROM players WHERE nick='Snute'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
28 (SELECT player FROM players WHERE nick='Stelisevil'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tom' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
34 (SELECT player FROM players WHERE nick='Tom'),
36 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Usagi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Usagi' NOT IN ( SELECT nick FROM players );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
40 (SELECT player FROM players WHERE nick='Usagi'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
46 (SELECT player FROM players WHERE nick='Oliyzia'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'DufF' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
52 (SELECT player FROM players WHERE nick='DufF'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mintsauce 82' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mintsauce 82' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
58 (SELECT player FROM players WHERE nick='Mintsauce 82'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'S2K' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'S2K' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
64 (SELECT player FROM players WHERE nick='S2K'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryosuke' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ryosuke' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
70 (SELECT player FROM players WHERE nick='Ryosuke'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Xai' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Xai' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
76 (SELECT player FROM players WHERE nick='Xai'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Krisminime' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Krisminime' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
82 (SELECT player FROM players WHERE nick='Krisminime'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
88 (SELECT player FROM players WHERE nick='RiChY'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
94 (SELECT player FROM players WHERE nick='Snofox'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Healingvizion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Healingvizion' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
100 (SELECT player FROM players WHERE nick='Healingvizion'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afrojunglist' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afrojunglist' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
106 (SELECT player FROM players WHERE nick='Afrojunglist'),
108 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jester' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jester' NOT IN ( SELECT nick FROM players );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
112 (SELECT player FROM players WHERE nick='Jester'),
114 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matt' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matt' NOT IN ( SELECT nick FROM players );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
118 (SELECT player FROM players WHERE nick='Matt'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Havok' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
124 (SELECT player FROM players WHERE nick='Havok'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
130 (SELECT player FROM players WHERE nick='Smiph'),
132 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 );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
136 (SELECT player FROM players WHERE nick='Daniil'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afronova' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afronova' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
142 (SELECT player FROM players WHERE nick='Afronova'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Albo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Albo' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
148 (SELECT player FROM players WHERE nick='Albo'),
150 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tieguy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tieguy' NOT IN ( SELECT nick FROM players );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
154 (SELECT player FROM players WHERE nick='Tieguy'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
160 (SELECT player FROM players WHERE nick='Draconia'),
162 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 );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
166 (SELECT player FROM players WHERE nick='kjmcw'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Myst' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Myst' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
172 (SELECT player FROM players WHERE nick='Myst'),
174 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Badbeat' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Badbeat' NOT IN ( SELECT nick FROM players );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
178 (SELECT player FROM players WHERE nick='Badbeat'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
184 (SELECT player FROM players WHERE nick='Ylini'),
186 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 );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
190 (SELECT player FROM players WHERE nick='Lejordet'),
192 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mecklar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mecklar' NOT IN ( SELECT nick FROM players );
193 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
194 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
196 (SELECT player FROM players WHERE nick='Mecklar'),
198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'sd-koala' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'sd-koala' NOT IN ( SELECT nick FROM players );
199 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
202 (SELECT player FROM players WHERE nick='sd-koala'),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'LLDJ' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'LLDJ' NOT IN ( SELECT nick FROM players );
205 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
208 (SELECT player FROM players WHERE nick='LLDJ'),
210 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Simon x' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Simon x' NOT IN ( SELECT nick FROM players );
211 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
214 (SELECT player FROM players WHERE nick='Simon x'),
216 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Fez' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Fez' NOT IN ( SELECT nick FROM players );
217 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
220 (SELECT player FROM players WHERE nick='Fez'),
222 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
224 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
227 INSERT INTO groups (tournament, round, parallel) VALUES (
228 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
231 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
233 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
235 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
238 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
240 UPDATE rounds SET randomsongs=2 WHERE
241 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
243 UPDATE rounds SET chosensongs=1 WHERE
244 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
247 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
249 (SELECT player FROM players WHERE nick='Mecklar'),
252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
253 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
255 (SELECT player FROM players WHERE nick='Mecklar'),
257 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
261 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
263 (SELECT player FROM players WHERE nick='Mecklar'),
265 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
269 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
271 (SELECT player FROM players WHERE nick='Mecklar'),
273 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
277 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
279 (SELECT player FROM players WHERE nick='Albo'),
282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
283 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
285 (SELECT player FROM players WHERE nick='Albo'),
287 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
291 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
293 (SELECT player FROM players WHERE nick='Albo'),
295 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
299 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
301 (SELECT player FROM players WHERE nick='Albo'),
303 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
307 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
309 (SELECT player FROM players WHERE nick='Afrojunglist'),
312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
313 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
315 (SELECT player FROM players WHERE nick='Afrojunglist'),
317 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
321 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
323 (SELECT player FROM players WHERE nick='Afrojunglist'),
325 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
329 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
331 (SELECT player FROM players WHERE nick='Afrojunglist'),
333 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
337 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
339 (SELECT player FROM players WHERE nick='RiChY'),
342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
343 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
345 (SELECT player FROM players WHERE nick='RiChY'),
347 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
351 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
353 (SELECT player FROM players WHERE nick='RiChY'),
355 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
359 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
361 (SELECT player FROM players WHERE nick='RiChY'),
363 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
367 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
369 (SELECT player FROM players WHERE nick='Snute'),
372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
373 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
375 (SELECT player FROM players WHERE nick='Snute'),
377 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
381 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
383 (SELECT player FROM players WHERE nick='Snute'),
385 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
389 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
391 (SELECT player FROM players WHERE nick='Snute'),
393 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
396 INSERT INTO groups (tournament, round, parallel) VALUES (
397 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
399 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
400 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
402 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
404 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
405 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
407 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor'))
409 UPDATE rounds SET randomsongs=2 WHERE
410 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
412 UPDATE rounds SET chosensongs=1 WHERE
413 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
416 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
418 (SELECT player FROM players WHERE nick='Fez'),
421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
422 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
424 (SELECT player FROM players WHERE nick='Fez'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
430 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
432 (SELECT player FROM players WHERE nick='Fez'),
434 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
440 (SELECT player FROM players WHERE nick='Fez'),
442 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
446 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
448 (SELECT player FROM players WHERE nick='Daniil'),
451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
452 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
454 (SELECT player FROM players WHERE nick='Daniil'),
456 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
462 (SELECT player FROM players WHERE nick='Daniil'),
464 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
470 (SELECT player FROM players WHERE nick='Daniil'),
472 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
476 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
478 (SELECT player FROM players WHERE nick='Draconia'),
481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
482 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
484 (SELECT player FROM players WHERE nick='Draconia'),
486 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
490 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
492 (SELECT player FROM players WHERE nick='Draconia'),
494 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
500 (SELECT player FROM players WHERE nick='Draconia'),
502 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
505 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
506 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
508 (SELECT player FROM players WHERE nick='Ryosuke'),
511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
512 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
514 (SELECT player FROM players WHERE nick='Ryosuke'),
516 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
520 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
522 (SELECT player FROM players WHERE nick='Ryosuke'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
528 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
530 (SELECT player FROM players WHERE nick='Ryosuke'),
532 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
536 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
538 (SELECT player FROM players WHERE nick='DufF'),
541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
544 (SELECT player FROM players WHERE nick='DufF'),
546 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
552 (SELECT player FROM players WHERE nick='DufF'),
554 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
558 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
560 (SELECT player FROM players WHERE nick='DufF'),
562 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
566 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
568 (SELECT player FROM players WHERE nick='Xai'),
571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
574 (SELECT player FROM players WHERE nick='Xai'),
576 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
580 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
582 (SELECT player FROM players WHERE nick='Xai'),
584 (SELECT song FROM songs WHERE lower(title)=lower('Burnin\' the Floor')),
587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
588 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
590 (SELECT player FROM players WHERE nick='Xai'),
592 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
595 INSERT INTO groups (tournament, round, parallel) VALUES (
596 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
598 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
599 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
601 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
603 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
604 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
606 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
608 UPDATE rounds SET randomsongs=2 WHERE
609 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
611 UPDATE rounds SET chosensongs=1 WHERE
612 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
614 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
615 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
617 (SELECT player FROM players WHERE nick='Simon x'),
620 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
621 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
623 (SELECT player FROM players WHERE nick='Simon x'),
625 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
629 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
631 (SELECT player FROM players WHERE nick='Simon x'),
633 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
639 (SELECT player FROM players WHERE nick='Simon x'),
641 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
647 (SELECT player FROM players WHERE nick='Ylini'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
653 (SELECT player FROM players WHERE nick='Ylini'),
655 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
661 (SELECT player FROM players WHERE nick='Ylini'),
663 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
667 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
669 (SELECT player FROM players WHERE nick='Ylini'),
671 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
675 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
677 (SELECT player FROM players WHERE nick='Matt'),
680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
681 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
683 (SELECT player FROM players WHERE nick='Matt'),
685 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
689 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
691 (SELECT player FROM players WHERE nick='Matt'),
693 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
697 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
699 (SELECT player FROM players WHERE nick='Matt'),
701 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
704 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
705 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
707 (SELECT player FROM players WHERE nick='Healingvizion'),
710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
711 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
713 (SELECT player FROM players WHERE nick='Healingvizion'),
715 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
718 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
719 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
721 (SELECT player FROM players WHERE nick='Healingvizion'),
723 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
727 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
729 (SELECT player FROM players WHERE nick='Healingvizion'),
731 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
735 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
737 (SELECT player FROM players WHERE nick='Krisminime'),
740 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
741 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
743 (SELECT player FROM players WHERE nick='Krisminime'),
745 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
749 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
751 (SELECT player FROM players WHERE nick='Krisminime'),
753 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
757 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
759 (SELECT player FROM players WHERE nick='Krisminime'),
761 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
765 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
767 (SELECT player FROM players WHERE nick='Tieguy'),
770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
771 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
773 (SELECT player FROM players WHERE nick='Tieguy'),
775 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
779 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
781 (SELECT player FROM players WHERE nick='Tieguy'),
783 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
786 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
787 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
789 (SELECT player FROM players WHERE nick='Tieguy'),
791 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
794 INSERT INTO groups (tournament, round, parallel) VALUES (
795 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
797 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
798 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
800 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)'))
802 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
803 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
805 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
807 UPDATE rounds SET randomsongs=2 WHERE
808 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
810 UPDATE rounds SET chosensongs=1 WHERE
811 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
814 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
816 (SELECT player FROM players WHERE nick='LLDJ'),
819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
820 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
822 (SELECT player FROM players WHERE nick='LLDJ'),
824 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
827 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
828 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
830 (SELECT player FROM players WHERE nick='LLDJ'),
832 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
836 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
838 (SELECT player FROM players WHERE nick='LLDJ'),
840 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
844 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
846 (SELECT player FROM players WHERE nick='Havok'),
849 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
850 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
852 (SELECT player FROM players WHERE nick='Havok'),
854 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
858 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
860 (SELECT player FROM players WHERE nick='Havok'),
862 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
866 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
868 (SELECT player FROM players WHERE nick='Havok'),
870 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
873 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
874 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
876 (SELECT player FROM players WHERE nick='Snofox'),
879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
880 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
882 (SELECT player FROM players WHERE nick='Snofox'),
884 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
887 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
888 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
890 (SELECT player FROM players WHERE nick='Snofox'),
892 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
895 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
896 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
898 (SELECT player FROM players WHERE nick='Snofox'),
900 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
903 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
904 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
906 (SELECT player FROM players WHERE nick='Myst'),
909 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
910 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
912 (SELECT player FROM players WHERE nick='Myst'),
914 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
918 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
920 (SELECT player FROM players WHERE nick='Myst'),
922 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
926 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
928 (SELECT player FROM players WHERE nick='Myst'),
930 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
934 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
936 (SELECT player FROM players WHERE nick='Oliyzia'),
939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
940 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
942 (SELECT player FROM players WHERE nick='Oliyzia'),
944 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
948 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
950 (SELECT player FROM players WHERE nick='Oliyzia'),
952 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
955 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
956 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
958 (SELECT player FROM players WHERE nick='Oliyzia'),
960 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
963 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
964 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
966 (SELECT player FROM players WHERE nick='Usagi'),
969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
970 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
972 (SELECT player FROM players WHERE nick='Usagi'),
974 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
977 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
978 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
980 (SELECT player FROM players WHERE nick='Usagi'),
982 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
986 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
988 (SELECT player FROM players WHERE nick='Usagi'),
990 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
993 INSERT INTO groups (tournament, round, parallel) VALUES (
994 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
996 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
999 (SELECT song FROM songs WHERE lower(title)=lower('Max 300'))
1001 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1002 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1004 (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
1006 UPDATE rounds SET randomsongs=2 WHERE
1007 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1009 UPDATE rounds SET chosensongs=1 WHERE
1010 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1015 (SELECT player FROM players WHERE nick='Lejordet'),
1018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1021 (SELECT player FROM players WHERE nick='Lejordet'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1027 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1029 (SELECT player FROM players WHERE nick='Lejordet'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1037 (SELECT player FROM players WHERE nick='Lejordet'),
1039 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
1042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1045 (SELECT player FROM players WHERE nick='Smiph'),
1048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1051 (SELECT player FROM players WHERE nick='Smiph'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1059 (SELECT player FROM players WHERE nick='Smiph'),
1061 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1064 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1065 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1067 (SELECT player FROM players WHERE nick='Smiph'),
1069 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1072 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1073 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1075 (SELECT player FROM players WHERE nick='S2K'),
1078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1079 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1081 (SELECT player FROM players WHERE nick='S2K'),
1083 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1086 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1087 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1089 (SELECT player FROM players WHERE nick='S2K'),
1091 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1094 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1095 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1097 (SELECT player FROM players WHERE nick='S2K'),
1099 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1102 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1105 (SELECT player FROM players WHERE nick='kjmcw'),
1108 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1109 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1111 (SELECT player FROM players WHERE nick='kjmcw'),
1113 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1116 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1117 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1119 (SELECT player FROM players WHERE nick='kjmcw'),
1121 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1124 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1125 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1127 (SELECT player FROM players WHERE nick='kjmcw'),
1129 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1132 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1133 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1135 (SELECT player FROM players WHERE nick='Tom'),
1138 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1139 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1141 (SELECT player FROM players WHERE nick='Tom'),
1143 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1146 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1147 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1149 (SELECT player FROM players WHERE nick='Tom'),
1151 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1154 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1155 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1157 (SELECT player FROM players WHERE nick='Tom'),
1159 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1162 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1163 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1165 (SELECT player FROM players WHERE nick='Stelisevil'),
1168 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1169 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1171 (SELECT player FROM players WHERE nick='Stelisevil'),
1173 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1176 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1177 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1179 (SELECT player FROM players WHERE nick='Stelisevil'),
1181 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1184 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1185 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1187 (SELECT player FROM players WHERE nick='Stelisevil'),
1189 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
1192 INSERT INTO groups (tournament, round, parallel) VALUES (
1193 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1195 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1196 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1198 (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
1200 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1201 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1203 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
1205 UPDATE rounds SET randomsongs=2 WHERE
1206 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1208 UPDATE rounds SET chosensongs=1 WHERE
1209 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1211 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1212 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1214 (SELECT player FROM players WHERE nick='Afronova'),
1217 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1218 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1220 (SELECT player FROM players WHERE nick='Afronova'),
1222 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1225 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1226 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1228 (SELECT player FROM players WHERE nick='Afronova'),
1230 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1233 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1234 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1236 (SELECT player FROM players WHERE nick='Afronova'),
1238 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1241 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1242 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1244 (SELECT player FROM players WHERE nick='sd-koala'),
1247 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1248 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1250 (SELECT player FROM players WHERE nick='sd-koala'),
1252 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1255 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1256 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1258 (SELECT player FROM players WHERE nick='sd-koala'),
1260 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1263 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1264 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1266 (SELECT player FROM players WHERE nick='sd-koala'),
1268 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
1271 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1272 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1274 (SELECT player FROM players WHERE nick='Jester'),
1277 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1278 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1280 (SELECT player FROM players WHERE nick='Jester'),
1282 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1285 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1286 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1288 (SELECT player FROM players WHERE nick='Jester'),
1290 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1293 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1294 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1296 (SELECT player FROM players WHERE nick='Jester'),
1298 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1301 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1302 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1304 (SELECT player FROM players WHERE nick='Badbeat'),
1307 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1308 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1310 (SELECT player FROM players WHERE nick='Badbeat'),
1312 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1315 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1316 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1318 (SELECT player FROM players WHERE nick='Badbeat'),
1320 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1323 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1324 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1326 (SELECT player FROM players WHERE nick='Badbeat'),
1328 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1331 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1332 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1334 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1337 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1338 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1340 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1342 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1345 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1346 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1348 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1350 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1353 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1354 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1356 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1358 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1361 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1362 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1364 (SELECT player FROM players WHERE nick='Lion'),
1367 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1368 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1370 (SELECT player FROM players WHERE nick='Lion'),
1372 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
1375 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1376 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1378 (SELECT player FROM players WHERE nick='Lion'),
1380 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
1383 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1384 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1386 (SELECT player FROM players WHERE nick='Lion'),
1388 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1391 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1393 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1396 INSERT INTO groups (tournament, round, parallel) VALUES (
1397 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1399 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1400 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1402 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy'))
1404 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1405 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1407 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous'))
1409 UPDATE rounds SET randomsongs=2 WHERE
1410 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1412 UPDATE rounds SET chosensongs=1 WHERE
1413 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1415 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1418 (SELECT player FROM players WHERE nick='Matt'),
1421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1422 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1424 (SELECT player FROM players WHERE nick='Matt'),
1426 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1430 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1432 (SELECT player FROM players WHERE nick='Matt'),
1434 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1440 (SELECT player FROM players WHERE nick='Matt'),
1442 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1446 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1448 (SELECT player FROM players WHERE nick='Stelisevil'),
1451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1452 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1454 (SELECT player FROM players WHERE nick='Stelisevil'),
1456 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1460 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1462 (SELECT player FROM players WHERE nick='Stelisevil'),
1464 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1468 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1470 (SELECT player FROM players WHERE nick='Stelisevil'),
1472 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1478 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1482 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1484 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1486 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1490 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1492 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1494 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1498 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1500 (SELECT player FROM players WHERE nick='Mintsauce 82'),
1502 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1505 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1506 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1508 (SELECT player FROM players WHERE nick='RiChY'),
1511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1512 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1514 (SELECT player FROM players WHERE nick='RiChY'),
1516 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1520 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1522 (SELECT player FROM players WHERE nick='RiChY'),
1524 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1528 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1530 (SELECT player FROM players WHERE nick='RiChY'),
1532 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1536 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1538 (SELECT player FROM players WHERE nick='Snute'),
1541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1542 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1544 (SELECT player FROM players WHERE nick='Snute'),
1546 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1550 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1552 (SELECT player FROM players WHERE nick='Snute'),
1554 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1558 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1560 (SELECT player FROM players WHERE nick='Snute'),
1562 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1566 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1568 (SELECT player FROM players WHERE nick='Ryosuke'),
1571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1572 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1574 (SELECT player FROM players WHERE nick='Ryosuke'),
1576 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1580 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1582 (SELECT player FROM players WHERE nick='Ryosuke'),
1584 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1588 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1590 (SELECT player FROM players WHERE nick='Ryosuke'),
1592 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1595 INSERT INTO groups (tournament, round, parallel) VALUES (
1596 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1598 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1599 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1601 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)'))
1603 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1604 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1606 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru'))
1608 UPDATE rounds SET randomsongs=2 WHERE
1609 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1611 UPDATE rounds SET chosensongs=1 WHERE
1612 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1614 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1615 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1617 (SELECT player FROM players WHERE nick='Snofox'),
1620 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1621 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1623 (SELECT player FROM players WHERE nick='Snofox'),
1625 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1628 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1629 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1631 (SELECT player FROM players WHERE nick='Snofox'),
1633 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1637 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1639 (SELECT player FROM players WHERE nick='Snofox'),
1641 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1645 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1647 (SELECT player FROM players WHERE nick='Jester'),
1650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1651 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1653 (SELECT player FROM players WHERE nick='Jester'),
1655 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1659 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1661 (SELECT player FROM players WHERE nick='Jester'),
1663 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1667 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1669 (SELECT player FROM players WHERE nick='Jester'),
1671 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1675 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1677 (SELECT player FROM players WHERE nick='Oliyzia'),
1680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1681 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1683 (SELECT player FROM players WHERE nick='Oliyzia'),
1685 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1689 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1691 (SELECT player FROM players WHERE nick='Oliyzia'),
1693 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1697 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1699 (SELECT player FROM players WHERE nick='Oliyzia'),
1701 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1704 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1705 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1707 (SELECT player FROM players WHERE nick='DufF'),
1710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1711 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1713 (SELECT player FROM players WHERE nick='DufF'),
1715 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1718 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1719 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1721 (SELECT player FROM players WHERE nick='DufF'),
1723 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1727 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1729 (SELECT player FROM players WHERE nick='DufF'),
1731 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1735 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1737 (SELECT player FROM players WHERE nick='Krisminime'),
1740 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1741 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1743 (SELECT player FROM players WHERE nick='Krisminime'),
1745 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1749 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1751 (SELECT player FROM players WHERE nick='Krisminime'),
1753 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1757 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1759 (SELECT player FROM players WHERE nick='Krisminime'),
1761 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1765 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1767 (SELECT player FROM players WHERE nick='Tom'),
1770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1771 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1773 (SELECT player FROM players WHERE nick='Tom'),
1775 (SELECT song FROM songs WHERE lower(title)=lower('Luv to Me (AMD Mix)')),
1778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1779 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1781 (SELECT player FROM players WHERE nick='Tom'),
1783 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1786 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1787 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1789 (SELECT player FROM players WHERE nick='Tom'),
1791 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
1794 INSERT INTO groups (tournament, round, parallel) VALUES (
1795 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1797 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1798 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1800 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
1802 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1803 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1805 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool'))
1807 UPDATE rounds SET randomsongs=2 WHERE
1808 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1810 UPDATE rounds SET chosensongs=1 WHERE
1811 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
1813 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1814 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1816 (SELECT player FROM players WHERE nick='Afrojunglist'),
1819 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1820 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1822 (SELECT player FROM players WHERE nick='Afrojunglist'),
1824 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1827 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1828 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1830 (SELECT player FROM players WHERE nick='Afrojunglist'),
1832 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1835 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1836 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1838 (SELECT player FROM players WHERE nick='Afrojunglist'),
1840 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
1843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1844 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1846 (SELECT player FROM players WHERE nick='Xai'),
1849 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1850 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1852 (SELECT player FROM players WHERE nick='Xai'),
1854 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1858 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1860 (SELECT player FROM players WHERE nick='Xai'),
1862 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1866 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1868 (SELECT player FROM players WHERE nick='Xai'),
1870 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1873 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1874 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1876 (SELECT player FROM players WHERE nick='Healingvizion'),
1879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1880 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1882 (SELECT player FROM players WHERE nick='Healingvizion'),
1884 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1887 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1888 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1890 (SELECT player FROM players WHERE nick='Healingvizion'),
1892 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1895 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1896 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1898 (SELECT player FROM players WHERE nick='Healingvizion'),
1900 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
1903 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1904 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1906 (SELECT player FROM players WHERE nick='S2K'),
1909 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1910 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1912 (SELECT player FROM players WHERE nick='S2K'),
1914 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1918 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1920 (SELECT player FROM players WHERE nick='S2K'),
1922 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1926 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1928 (SELECT player FROM players WHERE nick='S2K'),
1930 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1934 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1936 (SELECT player FROM players WHERE nick='Lion'),
1939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1940 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1942 (SELECT player FROM players WHERE nick='Lion'),
1944 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1948 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1950 (SELECT player FROM players WHERE nick='Lion'),
1952 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1955 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1956 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1958 (SELECT player FROM players WHERE nick='Lion'),
1960 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1963 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1964 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1966 (SELECT player FROM players WHERE nick='Usagi'),
1969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1970 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1972 (SELECT player FROM players WHERE nick='Usagi'),
1974 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1977 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1978 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1980 (SELECT player FROM players WHERE nick='Usagi'),
1982 (SELECT song FROM songs WHERE lower(title)=lower('Love You Like A Fool')),
1985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1986 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1988 (SELECT player FROM players WHERE nick='Usagi'),
1990 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
1993 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1995 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1998 INSERT INTO groups (tournament, round, parallel) VALUES (
1999 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2001 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2002 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2004 (SELECT song FROM songs WHERE lower(title)=lower('DXY!'))
2006 UPDATE rounds SET randomsongs=1 WHERE
2007 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2009 UPDATE rounds SET chosensongs=1 WHERE
2010 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2012 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2013 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2015 (SELECT player FROM players WHERE nick='Oliyzia'),
2018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2019 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2021 (SELECT player FROM players WHERE nick='Oliyzia'),
2023 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2027 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2029 (SELECT player FROM players WHERE nick='Oliyzia'),
2031 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2034 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2035 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2037 (SELECT player FROM players WHERE nick='S2K'),
2040 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2041 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2043 (SELECT player FROM players WHERE nick='S2K'),
2045 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2049 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2051 (SELECT player FROM players WHERE nick='S2K'),
2053 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2056 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2057 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2059 (SELECT player FROM players WHERE nick='Mintsauce 82'),
2062 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2063 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2065 (SELECT player FROM players WHERE nick='Mintsauce 82'),
2067 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2071 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2073 (SELECT player FROM players WHERE nick='Mintsauce 82'),
2075 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2078 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2079 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2081 (SELECT player FROM players WHERE nick='DufF'),
2084 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2085 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2087 (SELECT player FROM players WHERE nick='DufF'),
2089 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2092 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2093 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2095 (SELECT player FROM players WHERE nick='DufF'),
2097 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2100 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2101 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2103 (SELECT player FROM players WHERE nick='Usagi'),
2106 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2107 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2109 (SELECT player FROM players WHERE nick='Usagi'),
2111 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2115 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2117 (SELECT player FROM players WHERE nick='Usagi'),
2119 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2122 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2123 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2125 (SELECT player FROM players WHERE nick='Snute'),
2128 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2129 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2131 (SELECT player FROM players WHERE nick='Snute'),
2133 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2137 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2139 (SELECT player FROM players WHERE nick='Snute'),
2141 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2144 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2145 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2147 (SELECT player FROM players WHERE nick='Tom'),
2150 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2151 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2153 (SELECT player FROM players WHERE nick='Tom'),
2155 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2159 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2161 (SELECT player FROM players WHERE nick='Tom'),
2163 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2166 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2167 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2169 (SELECT player FROM players WHERE nick='Stelisevil'),
2172 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2173 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2175 (SELECT player FROM players WHERE nick='Stelisevil'),
2177 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2180 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2181 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2183 (SELECT player FROM players WHERE nick='Stelisevil'),
2185 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2188 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2189 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2191 (SELECT player FROM players WHERE nick='Lion'),
2194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2195 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2197 (SELECT player FROM players WHERE nick='Lion'),
2199 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2203 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2205 (SELECT player FROM players WHERE nick='Lion'),
2207 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2210 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2212 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2215 INSERT INTO groups (tournament, round, parallel) VALUES (
2216 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2218 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2219 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2221 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
2223 UPDATE rounds SET randomsongs=1 WHERE
2224 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2226 UPDATE rounds SET chosensongs=1 WHERE
2227 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2229 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2230 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2232 (SELECT player FROM players WHERE nick='DufF'),
2235 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2236 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2238 (SELECT player FROM players WHERE nick='DufF'),
2240 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2243 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2244 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2246 (SELECT player FROM players WHERE nick='DufF'),
2248 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
2251 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2252 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2254 (SELECT player FROM players WHERE nick='Usagi'),
2257 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2258 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2260 (SELECT player FROM players WHERE nick='Usagi'),
2262 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2265 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2266 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2268 (SELECT player FROM players WHERE nick='Usagi'),
2270 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2273 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2274 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2276 (SELECT player FROM players WHERE nick='Oliyzia'),
2279 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2280 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2282 (SELECT player FROM players WHERE nick='Oliyzia'),
2284 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2287 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2288 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2290 (SELECT player FROM players WHERE nick='Oliyzia'),
2292 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2295 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2296 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2298 (SELECT player FROM players WHERE nick='Tom'),
2301 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2302 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2304 (SELECT player FROM players WHERE nick='Tom'),
2306 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2309 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2310 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2312 (SELECT player FROM players WHERE nick='Tom'),
2314 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2317 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2318 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2320 (SELECT player FROM players WHERE nick='Snute'),
2323 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2324 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2326 (SELECT player FROM players WHERE nick='Snute'),
2328 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2331 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2332 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2334 (SELECT player FROM players WHERE nick='Snute'),
2336 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2339 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2340 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2342 (SELECT player FROM players WHERE nick='Lion'),
2345 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2346 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2348 (SELECT player FROM players WHERE nick='Lion'),
2350 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2353 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2354 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2356 (SELECT player FROM players WHERE nick='Lion'),
2358 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2361 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2362 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2364 (SELECT player FROM players WHERE nick='Stelisevil'),
2367 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2368 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2370 (SELECT player FROM players WHERE nick='Stelisevil'),
2372 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2375 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2376 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2378 (SELECT player FROM players WHERE nick='Stelisevil'),
2380 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2383 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2385 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2388 INSERT INTO groups (tournament, round, parallel) VALUES (
2389 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2391 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2392 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2394 (SELECT song FROM songs WHERE lower(title)=lower('B4U'))
2396 UPDATE rounds SET randomsongs=1 WHERE
2397 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2399 UPDATE rounds SET chosensongs=1 WHERE
2400 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2402 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2405 (SELECT player FROM players WHERE nick='Tom'),
2408 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2409 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2411 (SELECT player FROM players WHERE nick='Tom'),
2413 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2416 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2417 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2419 (SELECT player FROM players WHERE nick='Tom'),
2421 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2424 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2425 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2427 (SELECT player FROM players WHERE nick='Usagi'),
2430 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2431 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2433 (SELECT player FROM players WHERE nick='Usagi'),
2435 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2438 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2439 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2441 (SELECT player FROM players WHERE nick='Usagi'),
2443 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2446 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2447 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2449 (SELECT player FROM players WHERE nick='Snute'),
2452 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2453 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2455 (SELECT player FROM players WHERE nick='Snute'),
2457 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2460 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2461 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2463 (SELECT player FROM players WHERE nick='Snute'),
2465 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2468 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2469 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2471 (SELECT player FROM players WHERE nick='Lion'),
2474 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2475 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2477 (SELECT player FROM players WHERE nick='Lion'),
2479 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2483 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2485 (SELECT player FROM players WHERE nick='Lion'),
2487 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
2490 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2491 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2493 (SELECT player FROM players WHERE nick='Stelisevil'),
2496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2497 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2499 (SELECT player FROM players WHERE nick='Stelisevil'),
2501 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
2504 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2505 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2507 (SELECT player FROM players WHERE nick='Stelisevil'),
2509 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2512 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2514 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2517 INSERT INTO groups (tournament, round, parallel) VALUES (
2518 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2520 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2521 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2523 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval'))
2525 UPDATE rounds SET randomsongs=1 WHERE
2526 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2528 UPDATE rounds SET chosensongs=1 WHERE
2529 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2531 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2532 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2534 (SELECT player FROM players WHERE nick='Tom'),
2537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2538 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2540 (SELECT player FROM players WHERE nick='Tom'),
2542 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2545 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2546 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2548 (SELECT player FROM players WHERE nick='Tom'),
2550 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2553 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2554 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2556 (SELECT player FROM players WHERE nick='Snute'),
2559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2560 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2562 (SELECT player FROM players WHERE nick='Snute'),
2564 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2567 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2568 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2570 (SELECT player FROM players WHERE nick='Snute'),
2572 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2575 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2576 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2578 (SELECT player FROM players WHERE nick='Stelisevil'),
2581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2582 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2584 (SELECT player FROM players WHERE nick='Stelisevil'),
2586 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2589 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2590 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2592 (SELECT player FROM players WHERE nick='Stelisevil'),
2594 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2597 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2598 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2600 (SELECT player FROM players WHERE nick='Lion'),
2603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2604 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2606 (SELECT player FROM players WHERE nick='Lion'),
2608 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
2611 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2612 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2614 (SELECT player FROM players WHERE nick='Lion'),
2616 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2619 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2621 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2624 INSERT INTO groups (tournament, round, parallel) VALUES (
2625 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2627 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2628 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2630 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
2632 UPDATE rounds SET randomsongs=1 WHERE
2633 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2635 UPDATE rounds SET chosensongs=1 WHERE
2636 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2638 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2639 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2641 (SELECT player FROM players WHERE nick='Lion'),
2644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2645 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2647 (SELECT player FROM players WHERE nick='Lion'),
2649 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2653 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2655 (SELECT player FROM players WHERE nick='Lion'),
2657 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2660 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2661 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2663 (SELECT player FROM players WHERE nick='Snute'),
2666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2667 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2669 (SELECT player FROM players WHERE nick='Snute'),
2671 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2674 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2675 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2677 (SELECT player FROM players WHERE nick='Snute'),
2679 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2682 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2683 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2685 (SELECT player FROM players WHERE nick='Stelisevil'),
2688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2689 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2691 (SELECT player FROM players WHERE nick='Stelisevil'),
2693 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
2696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2697 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2699 (SELECT player FROM players WHERE nick='Stelisevil'),
2701 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2704 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
2706 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2709 INSERT INTO groups (tournament, round, parallel) VALUES (
2710 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2712 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2713 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2715 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
2717 UPDATE rounds SET randomsongs=1 WHERE
2718 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2720 UPDATE rounds SET chosensongs=1 WHERE
2721 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
2723 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2724 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2726 (SELECT player FROM players WHERE nick='Lion'),
2729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2730 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2732 (SELECT player FROM players WHERE nick='Lion'),
2734 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2737 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2738 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2740 (SELECT player FROM players WHERE nick='Lion'),
2742 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2745 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2746 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2748 (SELECT player FROM players WHERE nick='Snute'),
2751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2752 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2754 (SELECT player FROM players WHERE nick='Snute'),
2756 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
2759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2760 (SELECT tournament FROM tournaments WHERE tournamentname='European Tournament in London' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
2762 (SELECT player FROM players WHERE nick='Snute'),
2764 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),