2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='European Cup' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
6 (SELECT country FROM countries WHERE countryname='Europe'),
7 'The Gathering (Norway)',
9 (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dex' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dex' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
16 (SELECT player FROM players WHERE nick='Dex'),
18 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 );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
22 (SELECT player FROM players WHERE nick='DufF'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Snute' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
28 (SELECT player FROM players WHERE nick='Snute'),
30 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 );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
34 (SELECT player FROM players WHERE nick='Stelisevil'),
36 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 );
37 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
38 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
40 (SELECT player FROM players WHERE nick='Ryosuke'),
42 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 );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
46 (SELECT player FROM players WHERE nick='Lion'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T_Bone_X_Zeo' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T_Bone_X_Zeo' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
52 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
54 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 );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
58 (SELECT player FROM players WHERE nick='Tom'),
60 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'OJK' NOT IN ( SELECT nick FROM players );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
64 (SELECT player FROM players WHERE nick='OJK'),
66 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 );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
70 (SELECT player FROM players WHERE nick='Oliyzia'),
72 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smooth' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Smooth' NOT IN ( SELECT nick FROM players );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
76 (SELECT player FROM players WHERE nick='Smooth'),
78 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tiger Yoshiki' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tiger Yoshiki' NOT IN ( SELECT nick FROM players );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
82 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
84 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'William' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'William' NOT IN ( SELECT nick FROM players );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
88 (SELECT player FROM players WHERE nick='William'),
90 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Elias' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Elias' NOT IN ( SELECT nick FROM players );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
94 (SELECT player FROM players WHERE nick='Elias'),
96 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'T|na' NOT IN ( SELECT nick FROM players );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
100 (SELECT player FROM players WHERE nick='T|na'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
106 (SELECT player FROM players WHERE nick='Haggar'),
108 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 );
109 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
110 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
112 (SELECT player FROM players WHERE nick='RiChY'),
114 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 );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
118 (SELECT player FROM players WHERE nick='Daniil'),
120 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 );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
124 (SELECT player FROM players WHERE nick='Snofox'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
130 (SELECT player FROM players WHERE nick='Mulefisk'),
132 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kogepan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kogepan' NOT IN ( SELECT nick FROM players );
133 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
134 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
136 (SELECT player FROM players WHERE nick='Kogepan'),
138 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pfxp' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Pfxp' NOT IN ( SELECT nick FROM players );
139 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
140 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
142 (SELECT player FROM players WHERE nick='Pfxp'),
144 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Milk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Milk' NOT IN ( SELECT nick FROM players );
145 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
146 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
148 (SELECT player FROM players WHERE nick='Milk'),
150 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 );
151 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
152 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
154 (SELECT player FROM players WHERE nick='Draconia'),
156 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sesse' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sesse' NOT IN ( SELECT nick FROM players );
157 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
158 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
160 (SELECT player FROM players WHERE nick='Sesse'),
162 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Cyberg' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Cyberg' NOT IN ( SELECT nick FROM players );
163 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
164 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
166 (SELECT player FROM players WHERE nick='Cyberg'),
168 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Redixius' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Redixius' NOT IN ( SELECT nick FROM players );
169 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
170 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
172 (SELECT player FROM players WHERE nick='Redixius'),
174 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 );
175 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
176 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
178 (SELECT player FROM players WHERE nick='Healingvizion'),
180 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'stuf' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'stuf' NOT IN ( SELECT nick FROM players );
181 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
182 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
184 (SELECT player FROM players WHERE nick='stuf'),
186 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Magnar' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Magnar' NOT IN ( SELECT nick FROM players );
187 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
188 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
190 (SELECT player FROM players WHERE nick='Magnar'),
192 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Purity' NOT IN ( SELECT nick FROM players );
193 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
194 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
196 (SELECT player FROM players WHERE nick='Purity'),
198 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
199 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
200 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
202 (SELECT player FROM players WHERE nick='Duckling'),
204 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
205 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
206 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
208 (SELECT player FROM players WHERE nick='Jallaman'),
210 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 );
211 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
212 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
214 (SELECT player FROM players WHERE nick='Ylini'),
216 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 );
217 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
218 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
220 (SELECT player FROM players WHERE nick='Smiph'),
222 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'LF' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'LF' NOT IN ( SELECT nick FROM players );
223 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
224 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
226 (SELECT player FROM players WHERE nick='LF'),
228 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Indy' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Indy' NOT IN ( SELECT nick FROM players );
229 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
230 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
232 (SELECT player FROM players WHERE nick='Indy'),
234 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lurisoft' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lurisoft' NOT IN ( SELECT nick FROM players );
235 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
236 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
238 (SELECT player FROM players WHERE nick='Lurisoft'),
240 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 );
241 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
242 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
244 (SELECT player FROM players WHERE nick='sd-koala'),
246 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Yuna-chan' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Yuna-chan' NOT IN ( SELECT nick FROM players );
247 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
248 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
250 (SELECT player FROM players WHERE nick='Yuna-chan'),
252 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
253 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
254 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
256 (SELECT player FROM players WHERE nick='Ifrit'),
258 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
259 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
260 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
262 (SELECT player FROM players WHERE nick='Tha Dragon'),
264 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 );
265 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
266 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
268 (SELECT player FROM players WHERE nick='Havok'),
270 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haanz' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Haanz' NOT IN ( SELECT nick FROM players );
271 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
272 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
274 (SELECT player FROM players WHERE nick='Haanz'),
276 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Steel' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Steel' NOT IN ( SELECT nick FROM players );
277 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
278 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
280 (SELECT player FROM players WHERE nick='Steel'),
282 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'wa-ho' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'wa-ho' NOT IN ( SELECT nick FROM players );
283 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
284 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
286 (SELECT player FROM players WHERE nick='wa-ho'),
288 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Mync' NOT IN ( SELECT nick FROM players );
289 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
290 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
292 (SELECT player FROM players WHERE nick='Mync'),
294 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lu' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lu' NOT IN ( SELECT nick FROM players );
295 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
296 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
298 (SELECT player FROM players WHERE nick='Lu'),
300 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
301 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
302 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
304 (SELECT player FROM players WHERE nick='Dabi'),
306 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Puck' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Puck' NOT IN ( SELECT nick FROM players );
307 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
308 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
310 (SELECT player FROM players WHERE nick='Puck'),
312 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Chimera' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Chimera' NOT IN ( SELECT nick FROM players );
313 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
314 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
316 (SELECT player FROM players WHERE nick='Chimera'),
318 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dashiva' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Dashiva' NOT IN ( SELECT nick FROM players );
319 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
320 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
322 (SELECT player FROM players WHERE nick='Dashiva'),
324 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tazze' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Tazze' NOT IN ( SELECT nick FROM players );
325 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
326 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
328 (SELECT player FROM players WHERE nick='Tazze'),
330 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Psychofreud' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Psychofreud' NOT IN ( SELECT nick FROM players );
331 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
332 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
334 (SELECT player FROM players WHERE nick='Psychofreud'),
336 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Maxion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Maxion' NOT IN ( SELECT nick FROM players );
337 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
338 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
340 (SELECT player FROM players WHERE nick='Maxion'),
342 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Kissmet' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Kissmet' NOT IN ( SELECT nick FROM players );
343 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
344 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
346 (SELECT player FROM players WHERE nick='Kissmet'),
348 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
350 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
353 INSERT INTO groups (tournament, round, parallel) VALUES (
354 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
356 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
357 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
359 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
361 UPDATE rounds SET randomsongs=1 WHERE
362 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
364 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
365 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
367 (SELECT player FROM players WHERE nick='Stelisevil'),
370 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
371 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
373 (SELECT player FROM players WHERE nick='Stelisevil'),
375 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
378 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
379 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
381 (SELECT player FROM players WHERE nick='Ryosuke'),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
387 (SELECT player FROM players WHERE nick='Ryosuke'),
389 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
392 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
395 (SELECT player FROM players WHERE nick='Tom'),
398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
401 (SELECT player FROM players WHERE nick='Tom'),
403 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
406 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
409 (SELECT player FROM players WHERE nick='Dex'),
412 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
413 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
415 (SELECT player FROM players WHERE nick='Dex'),
417 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
420 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
421 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
423 (SELECT player FROM players WHERE nick='Oliyzia'),
426 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
427 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
429 (SELECT player FROM players WHERE nick='Oliyzia'),
431 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
434 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
435 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
437 (SELECT player FROM players WHERE nick='Lion'),
440 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
441 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
443 (SELECT player FROM players WHERE nick='Lion'),
445 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
448 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
449 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
451 (SELECT player FROM players WHERE nick='Snute'),
454 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
455 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
457 (SELECT player FROM players WHERE nick='Snute'),
459 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
462 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
463 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
465 (SELECT player FROM players WHERE nick='William'),
468 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
469 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
471 (SELECT player FROM players WHERE nick='William'),
473 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
476 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
477 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
479 (SELECT player FROM players WHERE nick='Snofox'),
482 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
483 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
485 (SELECT player FROM players WHERE nick='Snofox'),
487 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
490 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
491 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
493 (SELECT player FROM players WHERE nick='Mulefisk'),
496 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
497 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
499 (SELECT player FROM players WHERE nick='Mulefisk'),
501 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
504 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
505 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
507 (SELECT player FROM players WHERE nick='DufF'),
510 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
511 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
513 (SELECT player FROM players WHERE nick='DufF'),
515 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
518 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
519 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
521 (SELECT player FROM players WHERE nick='Smooth'),
524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
525 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
527 (SELECT player FROM players WHERE nick='Smooth'),
529 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
532 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
533 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
535 (SELECT player FROM players WHERE nick='Elias'),
538 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
539 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
541 (SELECT player FROM players WHERE nick='Elias'),
543 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
546 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
547 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
549 (SELECT player FROM players WHERE nick='Kogepan'),
552 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
553 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
555 (SELECT player FROM players WHERE nick='Kogepan'),
557 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
560 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
561 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
563 (SELECT player FROM players WHERE nick='Haggar'),
566 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
567 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
569 (SELECT player FROM players WHERE nick='Haggar'),
571 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
574 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
575 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
577 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
580 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
581 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
583 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
585 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
588 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
589 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
591 (SELECT player FROM players WHERE nick='T|na'),
594 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
595 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
597 (SELECT player FROM players WHERE nick='T|na'),
599 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
602 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
603 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
605 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
608 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
609 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
611 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
613 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
616 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
617 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
619 (SELECT player FROM players WHERE nick='OJK'),
622 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
623 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
625 (SELECT player FROM players WHERE nick='OJK'),
627 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
630 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
631 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
633 (SELECT player FROM players WHERE nick='Healingvizion'),
636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
637 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
639 (SELECT player FROM players WHERE nick='Healingvizion'),
641 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
645 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
647 (SELECT player FROM players WHERE nick='Sesse'),
650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
651 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
653 (SELECT player FROM players WHERE nick='Sesse'),
655 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
658 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
659 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
661 (SELECT player FROM players WHERE nick='Cyberg'),
664 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
665 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
667 (SELECT player FROM players WHERE nick='Cyberg'),
669 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
672 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
673 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
675 (SELECT player FROM players WHERE nick='stuf'),
678 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
679 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
681 (SELECT player FROM players WHERE nick='stuf'),
683 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
686 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
687 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
689 (SELECT player FROM players WHERE nick='Daniil'),
692 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
693 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
695 (SELECT player FROM players WHERE nick='Daniil'),
697 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
700 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
701 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
703 (SELECT player FROM players WHERE nick='Milk'),
706 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
707 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
709 (SELECT player FROM players WHERE nick='Milk'),
711 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
714 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
715 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
717 (SELECT player FROM players WHERE nick='RiChY'),
720 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
721 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
723 (SELECT player FROM players WHERE nick='RiChY'),
725 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
728 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
729 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
731 (SELECT player FROM players WHERE nick='Redixius'),
734 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
735 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
737 (SELECT player FROM players WHERE nick='Redixius'),
739 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
742 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
745 (SELECT player FROM players WHERE nick='Magnar'),
748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
749 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
751 (SELECT player FROM players WHERE nick='Magnar'),
753 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
756 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
757 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
759 (SELECT player FROM players WHERE nick='Ylini'),
762 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
763 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
765 (SELECT player FROM players WHERE nick='Ylini'),
767 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
770 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
771 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
773 (SELECT player FROM players WHERE nick='Duckling'),
776 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
777 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
779 (SELECT player FROM players WHERE nick='Duckling'),
781 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
784 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
785 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
787 (SELECT player FROM players WHERE nick='Draconia'),
790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
791 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
793 (SELECT player FROM players WHERE nick='Draconia'),
795 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
798 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
799 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
801 (SELECT player FROM players WHERE nick='Pfxp'),
804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
807 (SELECT player FROM players WHERE nick='Pfxp'),
809 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
812 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
813 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
815 (SELECT player FROM players WHERE nick='Purity'),
818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
821 (SELECT player FROM players WHERE nick='Purity'),
823 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
826 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
829 (SELECT player FROM players WHERE nick='Yuna-chan'),
832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
833 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
835 (SELECT player FROM players WHERE nick='Yuna-chan'),
837 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
840 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
843 (SELECT player FROM players WHERE nick='Smiph'),
846 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
847 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
849 (SELECT player FROM players WHERE nick='Smiph'),
851 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
854 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
855 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
857 (SELECT player FROM players WHERE nick='Dashiva'),
860 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
861 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
863 (SELECT player FROM players WHERE nick='Dashiva'),
865 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
868 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
869 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
871 (SELECT player FROM players WHERE nick='sd-koala'),
874 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
875 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
877 (SELECT player FROM players WHERE nick='sd-koala'),
879 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
882 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
883 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
885 (SELECT player FROM players WHERE nick='Haanz'),
888 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
889 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
891 (SELECT player FROM players WHERE nick='Haanz'),
893 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
896 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
897 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
899 (SELECT player FROM players WHERE nick='Tha Dragon'),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
905 (SELECT player FROM players WHERE nick='Tha Dragon'),
907 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
910 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
913 (SELECT player FROM players WHERE nick='Jallaman'),
916 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
917 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
919 (SELECT player FROM players WHERE nick='Jallaman'),
921 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
924 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
925 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
927 (SELECT player FROM players WHERE nick='Havok'),
930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
931 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
933 (SELECT player FROM players WHERE nick='Havok'),
935 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
938 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
939 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
941 (SELECT player FROM players WHERE nick='Indy'),
944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
945 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
947 (SELECT player FROM players WHERE nick='Indy'),
949 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
952 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
953 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
955 (SELECT player FROM players WHERE nick='LF'),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
961 (SELECT player FROM players WHERE nick='LF'),
963 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
966 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
969 (SELECT player FROM players WHERE nick='Lu'),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
975 (SELECT player FROM players WHERE nick='Lu'),
977 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
980 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
983 (SELECT player FROM players WHERE nick='Lurisoft'),
986 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
987 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
989 (SELECT player FROM players WHERE nick='Lurisoft'),
991 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
994 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
997 (SELECT player FROM players WHERE nick='Psychofreud'),
1000 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1001 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1003 (SELECT player FROM players WHERE nick='Psychofreud'),
1005 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1008 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1009 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1011 (SELECT player FROM players WHERE nick='Puck'),
1014 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1015 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1017 (SELECT player FROM players WHERE nick='Puck'),
1019 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1022 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1023 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1025 (SELECT player FROM players WHERE nick='wa-ho'),
1028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1031 (SELECT player FROM players WHERE nick='wa-ho'),
1033 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1039 (SELECT player FROM players WHERE nick='Steel'),
1042 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1045 (SELECT player FROM players WHERE nick='Steel'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1050 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1051 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1053 (SELECT player FROM players WHERE nick='Chimera'),
1056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1059 (SELECT player FROM players WHERE nick='Chimera'),
1061 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1065 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1067 (SELECT player FROM players WHERE nick='Dabi'),
1070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1071 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1073 (SELECT player FROM players WHERE nick='Dabi'),
1075 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1078 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1079 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1081 (SELECT player FROM players WHERE nick='Tazze'),
1084 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1085 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1087 (SELECT player FROM players WHERE nick='Tazze'),
1089 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1092 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1093 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1095 (SELECT player FROM players WHERE nick='Maxion'),
1098 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1099 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1101 (SELECT player FROM players WHERE nick='Maxion'),
1103 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1106 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1107 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1109 (SELECT player FROM players WHERE nick='Kissmet'),
1112 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1113 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1115 (SELECT player FROM players WHERE nick='Kissmet'),
1117 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1120 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1121 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1123 (SELECT player FROM players WHERE nick='Ifrit'),
1126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1129 (SELECT player FROM players WHERE nick='Ifrit'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1134 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1135 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1137 (SELECT player FROM players WHERE nick='Mync'),
1140 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1141 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1143 (SELECT player FROM players WHERE nick='Mync'),
1145 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
1148 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
1150 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1153 INSERT INTO groups (tournament, round, parallel) VALUES (
1154 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1156 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1157 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1159 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love'))
1161 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1162 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1164 (SELECT song FROM songs WHERE lower(title)=lower('Stomp'))
1166 UPDATE rounds SET randomsongs=2 WHERE
1167 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1169 UPDATE rounds SET chosensongs=1 WHERE
1170 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1172 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1173 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1175 (SELECT player FROM players WHERE nick='Havok'),
1178 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1179 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1181 (SELECT player FROM players WHERE nick='Havok'),
1183 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1186 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1187 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1189 (SELECT player FROM players WHERE nick='Havok'),
1191 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1194 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1195 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1197 (SELECT player FROM players WHERE nick='Havok'),
1199 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1202 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1203 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1205 (SELECT player FROM players WHERE nick='Jallaman'),
1208 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1209 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1211 (SELECT player FROM players WHERE nick='Jallaman'),
1213 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1216 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1217 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1219 (SELECT player FROM players WHERE nick='Jallaman'),
1221 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1225 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1227 (SELECT player FROM players WHERE nick='Jallaman'),
1229 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1232 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1233 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1235 (SELECT player FROM players WHERE nick='Sesse'),
1238 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1239 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1241 (SELECT player FROM players WHERE nick='Sesse'),
1243 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1247 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1249 (SELECT player FROM players WHERE nick='Sesse'),
1251 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1255 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1257 (SELECT player FROM players WHERE nick='Sesse'),
1259 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
1262 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1263 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1265 (SELECT player FROM players WHERE nick='Healingvizion'),
1268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1269 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1271 (SELECT player FROM players WHERE nick='Healingvizion'),
1273 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1276 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1277 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1279 (SELECT player FROM players WHERE nick='Healingvizion'),
1281 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1284 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1285 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1287 (SELECT player FROM players WHERE nick='Healingvizion'),
1289 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1292 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1293 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1295 (SELECT player FROM players WHERE nick='Stelisevil'),
1298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1299 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1301 (SELECT player FROM players WHERE nick='Stelisevil'),
1303 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
1306 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1307 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1309 (SELECT player FROM players WHERE nick='Stelisevil'),
1311 (SELECT song FROM songs WHERE lower(title)=lower('Stomp')),
1314 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1315 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1317 (SELECT player FROM players WHERE nick='Stelisevil'),
1319 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1322 INSERT INTO groups (tournament, round, parallel) VALUES (
1323 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1325 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1326 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1328 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001'))
1330 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1331 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1333 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
1335 UPDATE rounds SET randomsongs=2 WHERE
1336 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1338 UPDATE rounds SET chosensongs=1 WHERE
1339 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1341 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1342 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1344 (SELECT player FROM players WHERE nick='Indy'),
1347 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1348 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1350 (SELECT player FROM players WHERE nick='Indy'),
1352 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1355 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1356 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1358 (SELECT player FROM players WHERE nick='Indy'),
1360 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1363 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1364 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1366 (SELECT player FROM players WHERE nick='Indy'),
1368 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1371 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1372 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1374 (SELECT player FROM players WHERE nick='Tha Dragon'),
1377 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1378 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1380 (SELECT player FROM players WHERE nick='Tha Dragon'),
1382 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1385 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1386 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1388 (SELECT player FROM players WHERE nick='Tha Dragon'),
1390 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1393 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1394 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1396 (SELECT player FROM players WHERE nick='Tha Dragon'),
1398 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
1401 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1402 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1404 (SELECT player FROM players WHERE nick='Cyberg'),
1407 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1408 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1410 (SELECT player FROM players WHERE nick='Cyberg'),
1412 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1415 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1416 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1418 (SELECT player FROM players WHERE nick='Cyberg'),
1420 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1423 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1424 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1426 (SELECT player FROM players WHERE nick='Cyberg'),
1428 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
1431 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1432 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1434 (SELECT player FROM players WHERE nick='OJK'),
1437 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1438 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1440 (SELECT player FROM players WHERE nick='OJK'),
1442 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1445 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1446 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1448 (SELECT player FROM players WHERE nick='OJK'),
1450 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1453 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1454 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1456 (SELECT player FROM players WHERE nick='OJK'),
1458 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
1461 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1462 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1464 (SELECT player FROM players WHERE nick='Ryosuke'),
1467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1468 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1470 (SELECT player FROM players WHERE nick='Ryosuke'),
1472 (SELECT song FROM songs WHERE lower(title)=lower('Groove 2001')),
1475 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1476 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1478 (SELECT player FROM players WHERE nick='Ryosuke'),
1480 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
1483 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1484 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1486 (SELECT player FROM players WHERE nick='Ryosuke'),
1488 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1491 INSERT INTO groups (tournament, round, parallel) VALUES (
1492 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1494 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1495 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1497 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)'))
1499 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1500 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1502 (SELECT song FROM songs WHERE lower(title)=lower('Living in America'))
1504 UPDATE rounds SET randomsongs=2 WHERE
1505 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1507 UPDATE rounds SET chosensongs=1 WHERE
1508 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1510 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1511 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1513 (SELECT player FROM players WHERE nick='LF'),
1516 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1517 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1519 (SELECT player FROM players WHERE nick='LF'),
1521 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1524 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1525 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1527 (SELECT player FROM players WHERE nick='LF'),
1529 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1532 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1533 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1535 (SELECT player FROM players WHERE nick='LF'),
1537 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1540 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1541 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1543 (SELECT player FROM players WHERE nick='Haanz'),
1546 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1547 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1549 (SELECT player FROM players WHERE nick='Haanz'),
1551 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1554 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1555 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1557 (SELECT player FROM players WHERE nick='Haanz'),
1559 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1562 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1563 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1565 (SELECT player FROM players WHERE nick='Haanz'),
1567 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
1570 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1571 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1573 (SELECT player FROM players WHERE nick='stuf'),
1576 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1577 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1579 (SELECT player FROM players WHERE nick='stuf'),
1581 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1584 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1585 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1587 (SELECT player FROM players WHERE nick='stuf'),
1589 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1592 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1593 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1595 (SELECT player FROM players WHERE nick='stuf'),
1597 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
1600 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1601 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1603 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
1606 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1607 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1609 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
1611 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1614 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1615 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1617 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
1619 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1622 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1623 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1625 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
1627 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1630 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1631 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1633 (SELECT player FROM players WHERE nick='Tom'),
1636 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1637 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1639 (SELECT player FROM players WHERE nick='Tom'),
1641 (SELECT song FROM songs WHERE lower(title)=lower('B4U (B4 Za Beat Mix)')),
1644 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1645 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1647 (SELECT player FROM players WHERE nick='Tom'),
1649 (SELECT song FROM songs WHERE lower(title)=lower('Living in America')),
1652 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1653 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1655 (SELECT player FROM players WHERE nick='Tom'),
1657 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1660 INSERT INTO groups (tournament, round, parallel) VALUES (
1661 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1663 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1664 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1666 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis'))
1668 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1669 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1671 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001'))
1673 UPDATE rounds SET randomsongs=2 WHERE
1674 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1676 UPDATE rounds SET chosensongs=1 WHERE
1677 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1679 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1680 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1682 (SELECT player FROM players WHERE nick='Lu'),
1685 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1686 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1688 (SELECT player FROM players WHERE nick='Lu'),
1690 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1693 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1694 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1696 (SELECT player FROM players WHERE nick='Lu'),
1698 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1701 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1702 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1704 (SELECT player FROM players WHERE nick='Lu'),
1706 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1709 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1710 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1712 (SELECT player FROM players WHERE nick='sd-koala'),
1715 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1716 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1718 (SELECT player FROM players WHERE nick='sd-koala'),
1720 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1723 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1724 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1726 (SELECT player FROM players WHERE nick='sd-koala'),
1728 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1731 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1732 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1734 (SELECT player FROM players WHERE nick='sd-koala'),
1736 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
1739 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1740 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1742 (SELECT player FROM players WHERE nick='Daniil'),
1745 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1746 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1748 (SELECT player FROM players WHERE nick='Daniil'),
1750 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1753 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1754 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1756 (SELECT player FROM players WHERE nick='Daniil'),
1758 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1761 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1762 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1764 (SELECT player FROM players WHERE nick='Daniil'),
1766 (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
1769 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1770 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1772 (SELECT player FROM players WHERE nick='T|na'),
1775 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1776 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1778 (SELECT player FROM players WHERE nick='T|na'),
1780 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1783 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1784 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1786 (SELECT player FROM players WHERE nick='T|na'),
1788 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1791 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1792 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1794 (SELECT player FROM players WHERE nick='T|na'),
1796 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1799 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1800 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1802 (SELECT player FROM players WHERE nick='Dex'),
1805 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1806 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1808 (SELECT player FROM players WHERE nick='Dex'),
1810 (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
1813 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1814 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1816 (SELECT player FROM players WHERE nick='Dex'),
1818 (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
1821 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1822 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1824 (SELECT player FROM players WHERE nick='Dex'),
1826 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1829 INSERT INTO groups (tournament, round, parallel) VALUES (
1830 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1832 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1833 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1835 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)'))
1837 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
1838 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1840 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic'))
1842 UPDATE rounds SET randomsongs=2 WHERE
1843 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1845 UPDATE rounds SET chosensongs=1 WHERE
1846 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
1848 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1849 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1851 (SELECT player FROM players WHERE nick='Mync'),
1854 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1855 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1857 (SELECT player FROM players WHERE nick='Mync'),
1859 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1862 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1863 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1865 (SELECT player FROM players WHERE nick='Mync'),
1867 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1870 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1871 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1873 (SELECT player FROM players WHERE nick='Mync'),
1875 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
1878 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1879 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1881 (SELECT player FROM players WHERE nick='Lurisoft'),
1884 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1885 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1887 (SELECT player FROM players WHERE nick='Lurisoft'),
1889 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1892 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1893 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1895 (SELECT player FROM players WHERE nick='Lurisoft'),
1897 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1900 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1901 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1903 (SELECT player FROM players WHERE nick='Lurisoft'),
1905 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
1908 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1909 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1911 (SELECT player FROM players WHERE nick='Dashiva'),
1914 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1915 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1917 (SELECT player FROM players WHERE nick='Dashiva'),
1919 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1922 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1923 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1925 (SELECT player FROM players WHERE nick='Dashiva'),
1927 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1930 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1931 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1933 (SELECT player FROM players WHERE nick='Dashiva'),
1935 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
1938 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1939 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1941 (SELECT player FROM players WHERE nick='Milk'),
1944 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1945 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1947 (SELECT player FROM players WHERE nick='Milk'),
1949 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1952 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1953 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1955 (SELECT player FROM players WHERE nick='Milk'),
1957 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1960 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1961 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1963 (SELECT player FROM players WHERE nick='Milk'),
1965 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
1968 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1969 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1971 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
1974 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1975 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1977 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
1979 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
1982 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1983 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1985 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
1987 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
1990 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1991 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
1993 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
1995 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1998 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1999 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2001 (SELECT player FROM players WHERE nick='Oliyzia'),
2004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2005 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2007 (SELECT player FROM players WHERE nick='Oliyzia'),
2009 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
2012 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2013 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2015 (SELECT player FROM players WHERE nick='Oliyzia'),
2017 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2020 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2021 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2023 (SELECT player FROM players WHERE nick='Oliyzia'),
2025 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
2028 INSERT INTO groups (tournament, round, parallel) VALUES (
2029 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2031 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2032 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2034 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax'))
2036 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2037 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2039 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
2041 UPDATE rounds SET randomsongs=2 WHERE
2042 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2044 UPDATE rounds SET chosensongs=1 WHERE
2045 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2047 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2048 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2050 (SELECT player FROM players WHERE nick='Ifrit'),
2053 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2054 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2056 (SELECT player FROM players WHERE nick='Ifrit'),
2058 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2061 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2062 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2064 (SELECT player FROM players WHERE nick='Ifrit'),
2066 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2069 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2070 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2072 (SELECT player FROM players WHERE nick='Ifrit'),
2074 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2077 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2078 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2080 (SELECT player FROM players WHERE nick='Psychofreud'),
2083 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2084 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2086 (SELECT player FROM players WHERE nick='Psychofreud'),
2088 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2092 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2094 (SELECT player FROM players WHERE nick='Psychofreud'),
2096 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2100 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2102 (SELECT player FROM players WHERE nick='Psychofreud'),
2104 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
2107 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2108 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2110 (SELECT player FROM players WHERE nick='Smiph'),
2113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2114 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2116 (SELECT player FROM players WHERE nick='Smiph'),
2118 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2122 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2124 (SELECT player FROM players WHERE nick='Smiph'),
2126 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2129 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2130 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2132 (SELECT player FROM players WHERE nick='Smiph'),
2134 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2137 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2138 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2140 (SELECT player FROM players WHERE nick='RiChY'),
2143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2144 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2146 (SELECT player FROM players WHERE nick='RiChY'),
2148 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2152 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2154 (SELECT player FROM players WHERE nick='RiChY'),
2156 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2159 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2160 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2162 (SELECT player FROM players WHERE nick='RiChY'),
2164 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2168 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2170 (SELECT player FROM players WHERE nick='Haggar'),
2173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2174 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2176 (SELECT player FROM players WHERE nick='Haggar'),
2178 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2182 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2184 (SELECT player FROM players WHERE nick='Haggar'),
2186 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2190 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2192 (SELECT player FROM players WHERE nick='Haggar'),
2194 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
2197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2198 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2200 (SELECT player FROM players WHERE nick='Lion'),
2203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2204 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2206 (SELECT player FROM players WHERE nick='Lion'),
2208 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
2211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2212 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2214 (SELECT player FROM players WHERE nick='Lion'),
2216 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2220 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2222 (SELECT player FROM players WHERE nick='Lion'),
2224 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
2227 INSERT INTO groups (tournament, round, parallel) VALUES (
2228 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2231 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2233 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move'))
2235 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2236 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2238 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
2240 UPDATE rounds SET randomsongs=2 WHERE
2241 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2243 UPDATE rounds SET chosensongs=1 WHERE
2244 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2247 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2249 (SELECT player FROM players WHERE nick='Kissmet'),
2252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2253 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2255 (SELECT player FROM players WHERE nick='Kissmet'),
2257 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2261 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2263 (SELECT player FROM players WHERE nick='Kissmet'),
2265 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2269 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2271 (SELECT player FROM players WHERE nick='Kissmet'),
2273 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
2276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2277 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2279 (SELECT player FROM players WHERE nick='Puck'),
2282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2283 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2285 (SELECT player FROM players WHERE nick='Puck'),
2287 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2291 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2293 (SELECT player FROM players WHERE nick='Puck'),
2295 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2299 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2301 (SELECT player FROM players WHERE nick='Puck'),
2303 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2307 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2309 (SELECT player FROM players WHERE nick='Yuna-chan'),
2312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2313 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2315 (SELECT player FROM players WHERE nick='Yuna-chan'),
2317 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2321 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2323 (SELECT player FROM players WHERE nick='Yuna-chan'),
2325 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2329 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2331 (SELECT player FROM players WHERE nick='Yuna-chan'),
2333 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
2336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2337 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2339 (SELECT player FROM players WHERE nick='Redixius'),
2342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2343 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2345 (SELECT player FROM players WHERE nick='Redixius'),
2347 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2351 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2353 (SELECT player FROM players WHERE nick='Redixius'),
2355 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2359 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2361 (SELECT player FROM players WHERE nick='Redixius'),
2363 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2367 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2369 (SELECT player FROM players WHERE nick='Kogepan'),
2372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2373 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2375 (SELECT player FROM players WHERE nick='Kogepan'),
2377 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2381 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2383 (SELECT player FROM players WHERE nick='Kogepan'),
2385 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2389 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2391 (SELECT player FROM players WHERE nick='Kogepan'),
2393 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2397 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2399 (SELECT player FROM players WHERE nick='Snute'),
2402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2403 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2405 (SELECT player FROM players WHERE nick='Snute'),
2407 (SELECT song FROM songs WHERE lower(title)=lower('Let Them Move')),
2410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2411 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2413 (SELECT player FROM players WHERE nick='Snute'),
2415 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
2418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2419 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2421 (SELECT player FROM players WHERE nick='Snute'),
2423 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
2426 INSERT INTO groups (tournament, round, parallel) VALUES (
2427 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2429 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2430 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2432 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
2434 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2435 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2437 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right'))
2439 UPDATE rounds SET randomsongs=2 WHERE
2440 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2442 UPDATE rounds SET chosensongs=1 WHERE
2443 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2446 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2448 (SELECT player FROM players WHERE nick='Maxion'),
2451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2452 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2454 (SELECT player FROM players WHERE nick='Maxion'),
2456 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2460 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2462 (SELECT player FROM players WHERE nick='Maxion'),
2464 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
2467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2468 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2470 (SELECT player FROM players WHERE nick='Maxion'),
2472 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2476 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2478 (SELECT player FROM players WHERE nick='wa-ho'),
2481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2482 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2484 (SELECT player FROM players WHERE nick='wa-ho'),
2486 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2490 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2492 (SELECT player FROM players WHERE nick='wa-ho'),
2494 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
2497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2498 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2500 (SELECT player FROM players WHERE nick='wa-ho'),
2502 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2505 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2506 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2508 (SELECT player FROM players WHERE nick='Purity'),
2511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2512 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2514 (SELECT player FROM players WHERE nick='Purity'),
2516 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2520 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2522 (SELECT player FROM players WHERE nick='Purity'),
2524 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
2527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2528 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2530 (SELECT player FROM players WHERE nick='Purity'),
2532 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2536 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2538 (SELECT player FROM players WHERE nick='Magnar'),
2541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2542 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2544 (SELECT player FROM players WHERE nick='Magnar'),
2546 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2550 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2552 (SELECT player FROM players WHERE nick='Magnar'),
2554 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
2557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2558 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2560 (SELECT player FROM players WHERE nick='Magnar'),
2562 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2566 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2568 (SELECT player FROM players WHERE nick='Elias'),
2571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2572 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2574 (SELECT player FROM players WHERE nick='Elias'),
2576 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2580 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2582 (SELECT player FROM players WHERE nick='Elias'),
2584 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
2587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2588 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2590 (SELECT player FROM players WHERE nick='Elias'),
2592 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
2595 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2596 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2598 (SELECT player FROM players WHERE nick='William'),
2601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2602 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2604 (SELECT player FROM players WHERE nick='William'),
2606 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
2609 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2610 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2612 (SELECT player FROM players WHERE nick='William'),
2614 (SELECT song FROM songs WHERE lower(title)=lower('The Vibe is Right')),
2617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2618 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2620 (SELECT player FROM players WHERE nick='William'),
2622 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2625 INSERT INTO groups (tournament, round, parallel) VALUES (
2626 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2628 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2629 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2631 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It'))
2633 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2634 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2636 (SELECT song FROM songs WHERE lower(title)=lower('Afronova'))
2638 UPDATE rounds SET randomsongs=2 WHERE
2639 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2641 UPDATE rounds SET chosensongs=1 WHERE
2642 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2645 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2647 (SELECT player FROM players WHERE nick='Tazze'),
2650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2651 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2653 (SELECT player FROM players WHERE nick='Tazze'),
2655 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
2658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2659 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2661 (SELECT player FROM players WHERE nick='Tazze'),
2663 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2667 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2669 (SELECT player FROM players WHERE nick='Tazze'),
2671 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
2674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2675 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2677 (SELECT player FROM players WHERE nick='Steel'),
2680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2681 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2683 (SELECT player FROM players WHERE nick='Steel'),
2685 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
2688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2689 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2691 (SELECT player FROM players WHERE nick='Steel'),
2693 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2697 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2699 (SELECT player FROM players WHERE nick='Steel'),
2701 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2704 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2705 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2707 (SELECT player FROM players WHERE nick='Pfxp'),
2710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2711 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2713 (SELECT player FROM players WHERE nick='Pfxp'),
2715 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
2718 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2719 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2721 (SELECT player FROM players WHERE nick='Pfxp'),
2723 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2727 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2729 (SELECT player FROM players WHERE nick='Pfxp'),
2731 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
2734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2735 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2737 (SELECT player FROM players WHERE nick='Ylini'),
2740 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2741 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2743 (SELECT player FROM players WHERE nick='Ylini'),
2745 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
2748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2749 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2751 (SELECT player FROM players WHERE nick='Ylini'),
2753 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2757 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2759 (SELECT player FROM players WHERE nick='Ylini'),
2761 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2765 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2767 (SELECT player FROM players WHERE nick='Smooth'),
2770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2771 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2773 (SELECT player FROM players WHERE nick='Smooth'),
2775 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
2778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2779 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2781 (SELECT player FROM players WHERE nick='Smooth'),
2783 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2786 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2787 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2789 (SELECT player FROM players WHERE nick='Smooth'),
2791 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
2794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2795 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2797 (SELECT player FROM players WHERE nick='Snofox'),
2800 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2801 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2803 (SELECT player FROM players WHERE nick='Snofox'),
2805 (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
2808 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2809 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2811 (SELECT player FROM players WHERE nick='Snofox'),
2813 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
2816 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2817 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2819 (SELECT player FROM players WHERE nick='Snofox'),
2821 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
2824 INSERT INTO groups (tournament, round, parallel) VALUES (
2825 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2827 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2828 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2830 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori'))
2832 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
2833 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2835 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)'))
2837 UPDATE rounds SET randomsongs=2 WHERE
2838 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2840 UPDATE rounds SET chosensongs=1 WHERE
2841 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
2843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2844 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2846 (SELECT player FROM players WHERE nick='Dabi'),
2849 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2850 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2852 (SELECT player FROM players WHERE nick='Dabi'),
2854 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
2857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2858 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2860 (SELECT player FROM players WHERE nick='Dabi'),
2862 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2866 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2868 (SELECT player FROM players WHERE nick='Dabi'),
2870 (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
2873 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2874 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2876 (SELECT player FROM players WHERE nick='Chimera'),
2879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2880 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2882 (SELECT player FROM players WHERE nick='Chimera'),
2884 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
2887 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2888 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2890 (SELECT player FROM players WHERE nick='Chimera'),
2892 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2895 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2896 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2898 (SELECT player FROM players WHERE nick='Chimera'),
2900 (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
2903 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2904 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2906 (SELECT player FROM players WHERE nick='Draconia'),
2909 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2910 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2912 (SELECT player FROM players WHERE nick='Draconia'),
2914 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
2917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2918 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2920 (SELECT player FROM players WHERE nick='Draconia'),
2922 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2926 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2928 (SELECT player FROM players WHERE nick='Draconia'),
2930 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
2933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2934 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2936 (SELECT player FROM players WHERE nick='Duckling'),
2939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2940 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2942 (SELECT player FROM players WHERE nick='Duckling'),
2944 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
2947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2948 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2950 (SELECT player FROM players WHERE nick='Duckling'),
2952 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2955 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2956 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2958 (SELECT player FROM players WHERE nick='Duckling'),
2960 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
2963 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2964 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2966 (SELECT player FROM players WHERE nick='DufF'),
2969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2970 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2972 (SELECT player FROM players WHERE nick='DufF'),
2974 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
2977 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2978 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2980 (SELECT player FROM players WHERE nick='DufF'),
2982 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
2985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2986 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2988 (SELECT player FROM players WHERE nick='DufF'),
2990 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
2993 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2994 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
2996 (SELECT player FROM players WHERE nick='Mulefisk'),
2999 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3000 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3002 (SELECT player FROM players WHERE nick='Mulefisk'),
3004 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
3007 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3008 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3010 (SELECT player FROM players WHERE nick='Mulefisk'),
3012 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
3015 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3016 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3018 (SELECT player FROM players WHERE nick='Mulefisk'),
3020 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
3023 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
3025 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3028 INSERT INTO groups (tournament, round, parallel) VALUES (
3029 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3031 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3032 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3034 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
3036 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3037 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3039 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\''))
3041 UPDATE rounds SET randomsongs=2 WHERE
3042 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3044 UPDATE rounds SET chosensongs=1 WHERE
3045 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3047 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3048 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3050 (SELECT player FROM players WHERE nick='Redixius'),
3053 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3054 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3056 (SELECT player FROM players WHERE nick='Redixius'),
3058 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
3061 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3062 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3064 (SELECT player FROM players WHERE nick='Redixius'),
3066 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
3069 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3070 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3072 (SELECT player FROM players WHERE nick='Redixius'),
3074 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
3077 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3078 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3080 (SELECT player FROM players WHERE nick='Milk'),
3083 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3084 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3086 (SELECT player FROM players WHERE nick='Milk'),
3088 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
3091 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3092 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3094 (SELECT player FROM players WHERE nick='Milk'),
3096 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
3099 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3100 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3102 (SELECT player FROM players WHERE nick='Milk'),
3104 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3107 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3108 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3110 (SELECT player FROM players WHERE nick='T|na'),
3113 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3114 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3116 (SELECT player FROM players WHERE nick='T|na'),
3118 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
3121 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3122 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3124 (SELECT player FROM players WHERE nick='T|na'),
3126 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
3129 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3130 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3132 (SELECT player FROM players WHERE nick='T|na'),
3134 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3137 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3138 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3140 (SELECT player FROM players WHERE nick='Haggar'),
3143 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3144 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3146 (SELECT player FROM players WHERE nick='Haggar'),
3148 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
3151 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3152 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3154 (SELECT player FROM players WHERE nick='Haggar'),
3156 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
3159 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3160 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3162 (SELECT player FROM players WHERE nick='Haggar'),
3164 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
3167 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3168 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3170 (SELECT player FROM players WHERE nick='Snute'),
3173 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3174 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3176 (SELECT player FROM players WHERE nick='Snute'),
3178 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
3181 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3182 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3184 (SELECT player FROM players WHERE nick='Snute'),
3186 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
3189 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3190 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3192 (SELECT player FROM players WHERE nick='Snute'),
3194 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
3197 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3198 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3200 (SELECT player FROM players WHERE nick='Lion'),
3203 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3204 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3206 (SELECT player FROM players WHERE nick='Lion'),
3208 (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
3211 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3212 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3214 (SELECT player FROM players WHERE nick='Lion'),
3216 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
3219 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3220 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3222 (SELECT player FROM players WHERE nick='Lion'),
3224 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
3227 INSERT INTO groups (tournament, round, parallel) VALUES (
3228 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3230 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3231 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3233 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc'))
3235 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3236 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3238 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
3240 UPDATE rounds SET randomsongs=2 WHERE
3241 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3243 UPDATE rounds SET chosensongs=1 WHERE
3244 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3246 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3247 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3249 (SELECT player FROM players WHERE nick='Cyberg'),
3252 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3253 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3255 (SELECT player FROM players WHERE nick='Cyberg'),
3257 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
3260 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3261 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3263 (SELECT player FROM players WHERE nick='Cyberg'),
3265 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3269 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3271 (SELECT player FROM players WHERE nick='Cyberg'),
3273 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3276 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3277 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3279 (SELECT player FROM players WHERE nick='Sesse'),
3282 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3283 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3285 (SELECT player FROM players WHERE nick='Sesse'),
3287 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
3290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3291 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3293 (SELECT player FROM players WHERE nick='Sesse'),
3295 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3299 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3301 (SELECT player FROM players WHERE nick='Sesse'),
3303 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
3306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3307 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3309 (SELECT player FROM players WHERE nick='Snofox'),
3312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3313 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3315 (SELECT player FROM players WHERE nick='Snofox'),
3317 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
3320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3321 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3323 (SELECT player FROM players WHERE nick='Snofox'),
3325 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3328 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3329 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3331 (SELECT player FROM players WHERE nick='Snofox'),
3333 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3336 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3337 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3339 (SELECT player FROM players WHERE nick='William'),
3342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3343 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3345 (SELECT player FROM players WHERE nick='William'),
3347 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
3350 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3351 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3353 (SELECT player FROM players WHERE nick='William'),
3355 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3358 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3359 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3361 (SELECT player FROM players WHERE nick='William'),
3363 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3366 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3367 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3369 (SELECT player FROM players WHERE nick='Stelisevil'),
3372 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3373 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3375 (SELECT player FROM players WHERE nick='Stelisevil'),
3377 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
3380 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3381 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3383 (SELECT player FROM players WHERE nick='Stelisevil'),
3385 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3388 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3389 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3391 (SELECT player FROM players WHERE nick='Stelisevil'),
3393 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
3396 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3397 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3399 (SELECT player FROM players WHERE nick='Smooth'),
3402 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3403 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3405 (SELECT player FROM players WHERE nick='Smooth'),
3407 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
3410 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3411 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3413 (SELECT player FROM players WHERE nick='Smooth'),
3415 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3418 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3419 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3421 (SELECT player FROM players WHERE nick='Smooth'),
3423 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
3426 INSERT INTO groups (tournament, round, parallel) VALUES (
3427 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3429 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3430 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3432 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
3434 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3435 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3437 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)'))
3439 UPDATE rounds SET randomsongs=2 WHERE
3440 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3442 UPDATE rounds SET chosensongs=1 WHERE
3443 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3445 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3446 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3448 (SELECT player FROM players WHERE nick='Daniil'),
3451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3452 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3454 (SELECT player FROM players WHERE nick='Daniil'),
3456 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
3459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3460 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3462 (SELECT player FROM players WHERE nick='Daniil'),
3464 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
3467 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3468 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3470 (SELECT player FROM players WHERE nick='Daniil'),
3472 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
3475 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3476 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3478 (SELECT player FROM players WHERE nick='Magnar'),
3481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3482 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3484 (SELECT player FROM players WHERE nick='Magnar'),
3486 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
3489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3490 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3492 (SELECT player FROM players WHERE nick='Magnar'),
3494 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
3497 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3498 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3500 (SELECT player FROM players WHERE nick='Magnar'),
3502 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3505 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3506 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3508 (SELECT player FROM players WHERE nick='Kogepan'),
3511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3512 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3514 (SELECT player FROM players WHERE nick='Kogepan'),
3516 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
3519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3520 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3522 (SELECT player FROM players WHERE nick='Kogepan'),
3524 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
3527 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3528 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3530 (SELECT player FROM players WHERE nick='Kogepan'),
3532 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3535 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3536 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3538 (SELECT player FROM players WHERE nick='Ryosuke'),
3541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3542 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3544 (SELECT player FROM players WHERE nick='Ryosuke'),
3546 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
3549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3550 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3552 (SELECT player FROM players WHERE nick='Ryosuke'),
3554 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
3557 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3558 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3560 (SELECT player FROM players WHERE nick='Ryosuke'),
3562 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3565 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3566 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3568 (SELECT player FROM players WHERE nick='Elias'),
3571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3572 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3574 (SELECT player FROM players WHERE nick='Elias'),
3576 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
3579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3580 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3582 (SELECT player FROM players WHERE nick='Elias'),
3584 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
3587 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3588 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3590 (SELECT player FROM players WHERE nick='Elias'),
3592 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3595 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3596 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3598 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
3601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3602 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3604 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
3606 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
3609 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3610 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3612 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
3614 (SELECT song FROM songs WHERE lower(title)=lower('Aaron\'s Party (Come Get It)')),
3617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3618 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3620 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
3622 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
3625 INSERT INTO groups (tournament, round, parallel) VALUES (
3626 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3628 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3629 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3631 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill'))
3633 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3634 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3636 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now'))
3638 UPDATE rounds SET randomsongs=2 WHERE
3639 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3641 UPDATE rounds SET chosensongs=1 WHERE
3642 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3644 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3645 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3647 (SELECT player FROM players WHERE nick='Pfxp'),
3650 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3651 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3653 (SELECT player FROM players WHERE nick='Pfxp'),
3655 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
3658 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3659 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3661 (SELECT player FROM players WHERE nick='Pfxp'),
3663 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
3666 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3667 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3669 (SELECT player FROM players WHERE nick='Pfxp'),
3671 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3675 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3677 (SELECT player FROM players WHERE nick='RiChY'),
3680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3681 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3683 (SELECT player FROM players WHERE nick='RiChY'),
3685 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
3688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3689 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3691 (SELECT player FROM players WHERE nick='RiChY'),
3693 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
3696 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3697 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3699 (SELECT player FROM players WHERE nick='RiChY'),
3701 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
3704 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3705 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3707 (SELECT player FROM players WHERE nick='Healingvizion'),
3710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3711 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3713 (SELECT player FROM players WHERE nick='Healingvizion'),
3715 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
3718 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3719 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3721 (SELECT player FROM players WHERE nick='Healingvizion'),
3723 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
3726 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3727 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3729 (SELECT player FROM players WHERE nick='Healingvizion'),
3731 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
3734 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3735 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3737 (SELECT player FROM players WHERE nick='Oliyzia'),
3740 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3741 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3743 (SELECT player FROM players WHERE nick='Oliyzia'),
3745 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
3748 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3749 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3751 (SELECT player FROM players WHERE nick='Oliyzia'),
3753 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
3756 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3757 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3759 (SELECT player FROM players WHERE nick='Oliyzia'),
3761 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
3764 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3765 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3767 (SELECT player FROM players WHERE nick='Tom'),
3770 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3771 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3773 (SELECT player FROM players WHERE nick='Tom'),
3775 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
3778 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3779 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3781 (SELECT player FROM players WHERE nick='Tom'),
3783 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
3786 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3787 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3789 (SELECT player FROM players WHERE nick='Tom'),
3791 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
3794 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3795 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3797 (SELECT player FROM players WHERE nick='DufF'),
3800 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3801 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3803 (SELECT player FROM players WHERE nick='DufF'),
3805 (SELECT song FROM songs WHERE lower(title)=lower('Silent Hill')),
3808 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3809 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3811 (SELECT player FROM players WHERE nick='DufF'),
3813 (SELECT song FROM songs WHERE lower(title)=lower('That was then, This is now')),
3816 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3817 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3819 (SELECT player FROM players WHERE nick='DufF'),
3821 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
3824 INSERT INTO groups (tournament, round, parallel) VALUES (
3825 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3827 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3828 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3830 (SELECT song FROM songs WHERE lower(title)=lower('Dead End'))
3832 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
3833 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3835 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
3837 UPDATE rounds SET randomsongs=2 WHERE
3838 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3840 UPDATE rounds SET chosensongs=1 WHERE
3841 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
3843 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3844 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3846 (SELECT player FROM players WHERE nick='stuf'),
3849 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3850 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3852 (SELECT player FROM players WHERE nick='stuf'),
3854 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3857 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3858 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3860 (SELECT player FROM players WHERE nick='stuf'),
3862 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
3865 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3866 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3868 (SELECT player FROM players WHERE nick='stuf'),
3870 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
3873 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3874 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3876 (SELECT player FROM players WHERE nick='Draconia'),
3879 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3880 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3882 (SELECT player FROM players WHERE nick='Draconia'),
3884 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3887 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3888 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3890 (SELECT player FROM players WHERE nick='Draconia'),
3892 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
3895 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3896 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3898 (SELECT player FROM players WHERE nick='Draconia'),
3900 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3903 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3904 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3906 (SELECT player FROM players WHERE nick='Mulefisk'),
3909 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3910 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3912 (SELECT player FROM players WHERE nick='Mulefisk'),
3914 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3917 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3918 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3920 (SELECT player FROM players WHERE nick='Mulefisk'),
3922 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
3925 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3926 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3928 (SELECT player FROM players WHERE nick='Mulefisk'),
3930 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
3933 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3934 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3936 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
3939 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3940 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3942 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
3944 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3947 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3948 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3950 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
3952 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
3955 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3956 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3958 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
3960 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
3963 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3964 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3966 (SELECT player FROM players WHERE nick='Dex'),
3969 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3970 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3972 (SELECT player FROM players WHERE nick='Dex'),
3974 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
3977 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3978 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3980 (SELECT player FROM players WHERE nick='Dex'),
3982 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
3985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
3986 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3988 (SELECT player FROM players WHERE nick='Dex'),
3990 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
3993 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
3994 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
3996 (SELECT player FROM players WHERE nick='OJK'),
3999 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4000 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4002 (SELECT player FROM players WHERE nick='OJK'),
4004 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
4007 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4008 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4010 (SELECT player FROM players WHERE nick='OJK'),
4012 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
4015 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4016 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4018 (SELECT player FROM players WHERE nick='OJK'),
4020 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
4023 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
4025 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4028 INSERT INTO groups (tournament, round, parallel) VALUES (
4029 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4031 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
4032 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4034 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth'))
4036 UPDATE rounds SET randomsongs=1 WHERE
4037 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4039 UPDATE rounds SET chosensongs=1 WHERE
4040 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4043 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4045 (SELECT player FROM players WHERE nick='Tom'),
4048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4049 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4051 (SELECT player FROM players WHERE nick='Tom'),
4053 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4057 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4059 (SELECT player FROM players WHERE nick='Tom'),
4061 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
4064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4065 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4067 (SELECT player FROM players WHERE nick='Elias'),
4070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4071 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4073 (SELECT player FROM players WHERE nick='Elias'),
4075 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4079 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4081 (SELECT player FROM players WHERE nick='Elias'),
4083 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
4086 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4087 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4089 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
4092 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4093 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4095 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
4097 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4100 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4101 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4103 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
4105 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
4108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4109 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4111 (SELECT player FROM players WHERE nick='T|na'),
4114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4115 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4117 (SELECT player FROM players WHERE nick='T|na'),
4119 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4123 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4125 (SELECT player FROM players WHERE nick='T|na'),
4127 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
4130 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4131 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4133 (SELECT player FROM players WHERE nick='William'),
4136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4137 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4139 (SELECT player FROM players WHERE nick='William'),
4141 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4145 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4147 (SELECT player FROM players WHERE nick='William'),
4149 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
4152 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4153 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4155 (SELECT player FROM players WHERE nick='Smooth'),
4158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4159 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4161 (SELECT player FROM players WHERE nick='Smooth'),
4163 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4167 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4169 (SELECT player FROM players WHERE nick='Smooth'),
4171 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
4174 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4175 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4177 (SELECT player FROM players WHERE nick='DufF'),
4180 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4181 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4183 (SELECT player FROM players WHERE nick='DufF'),
4185 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4189 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4191 (SELECT player FROM players WHERE nick='DufF'),
4193 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
4196 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4197 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4199 (SELECT player FROM players WHERE nick='Snute'),
4202 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4203 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4205 (SELECT player FROM players WHERE nick='Snute'),
4207 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4210 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4211 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4213 (SELECT player FROM players WHERE nick='Snute'),
4215 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
4218 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4219 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4221 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4224 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4225 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4227 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4229 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4232 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4233 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4235 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4237 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
4240 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4241 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4243 (SELECT player FROM players WHERE nick='OJK'),
4246 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4247 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4249 (SELECT player FROM players WHERE nick='OJK'),
4251 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4254 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4255 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4257 (SELECT player FROM players WHERE nick='OJK'),
4259 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
4262 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4263 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4265 (SELECT player FROM players WHERE nick='Oliyzia'),
4268 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4269 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4271 (SELECT player FROM players WHERE nick='Oliyzia'),
4273 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4276 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4277 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4279 (SELECT player FROM players WHERE nick='Oliyzia'),
4281 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
4284 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4285 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4287 (SELECT player FROM players WHERE nick='Dex'),
4290 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4291 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4293 (SELECT player FROM players WHERE nick='Dex'),
4295 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4298 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4299 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4301 (SELECT player FROM players WHERE nick='Dex'),
4303 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
4306 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4307 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4309 (SELECT player FROM players WHERE nick='Ryosuke'),
4312 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4313 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4315 (SELECT player FROM players WHERE nick='Ryosuke'),
4317 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4320 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4321 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4323 (SELECT player FROM players WHERE nick='Ryosuke'),
4325 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
4328 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4329 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4331 (SELECT player FROM players WHERE nick='Stelisevil'),
4334 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4335 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4337 (SELECT player FROM players WHERE nick='Stelisevil'),
4339 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4342 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4343 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4345 (SELECT player FROM players WHERE nick='Stelisevil'),
4347 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
4350 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4351 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4353 (SELECT player FROM players WHERE nick='Lion'),
4356 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4357 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4359 (SELECT player FROM players WHERE nick='Lion'),
4361 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
4364 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4365 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4367 (SELECT player FROM players WHERE nick='Lion'),
4369 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
4372 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
4374 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4377 INSERT INTO groups (tournament, round, parallel) VALUES (
4378 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4380 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
4381 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4383 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita'))
4385 UPDATE rounds SET randomsongs=1 WHERE
4386 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4388 UPDATE rounds SET chosensongs=1 WHERE
4389 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4391 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4392 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4394 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
4397 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4398 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4400 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
4402 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4405 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4406 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4408 (SELECT player FROM players WHERE nick='Tiger Yoshiki'),
4410 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
4413 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4414 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4416 (SELECT player FROM players WHERE nick='Smooth'),
4419 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4420 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4422 (SELECT player FROM players WHERE nick='Smooth'),
4424 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4427 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4428 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4430 (SELECT player FROM players WHERE nick='Smooth'),
4432 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
4435 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4436 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4438 (SELECT player FROM players WHERE nick='Tom'),
4441 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4442 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4444 (SELECT player FROM players WHERE nick='Tom'),
4446 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4449 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4450 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4452 (SELECT player FROM players WHERE nick='Tom'),
4454 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
4457 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4458 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4460 (SELECT player FROM players WHERE nick='Ryosuke'),
4463 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4464 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4466 (SELECT player FROM players WHERE nick='Ryosuke'),
4468 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4471 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4472 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4474 (SELECT player FROM players WHERE nick='Ryosuke'),
4476 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
4479 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4480 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4482 (SELECT player FROM players WHERE nick='Oliyzia'),
4485 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4486 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4488 (SELECT player FROM players WHERE nick='Oliyzia'),
4490 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4493 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4494 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4496 (SELECT player FROM players WHERE nick='Oliyzia'),
4498 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
4501 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4502 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4504 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4507 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4508 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4510 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4512 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4515 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4516 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4518 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4520 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
4523 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4524 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4526 (SELECT player FROM players WHERE nick='OJK'),
4529 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4530 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4532 (SELECT player FROM players WHERE nick='OJK'),
4534 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4537 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4538 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4540 (SELECT player FROM players WHERE nick='OJK'),
4542 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
4545 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4546 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4548 (SELECT player FROM players WHERE nick='DufF'),
4551 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4552 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4554 (SELECT player FROM players WHERE nick='DufF'),
4556 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4559 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4560 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4562 (SELECT player FROM players WHERE nick='DufF'),
4564 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
4567 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4568 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4570 (SELECT player FROM players WHERE nick='Dex'),
4573 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4574 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4576 (SELECT player FROM players WHERE nick='Dex'),
4578 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4581 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4582 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4584 (SELECT player FROM players WHERE nick='Dex'),
4586 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
4589 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4590 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4592 (SELECT player FROM players WHERE nick='Snute'),
4595 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4596 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4598 (SELECT player FROM players WHERE nick='Snute'),
4600 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4603 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4604 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4606 (SELECT player FROM players WHERE nick='Snute'),
4608 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
4611 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4612 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4614 (SELECT player FROM players WHERE nick='Stelisevil'),
4617 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4618 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4620 (SELECT player FROM players WHERE nick='Stelisevil'),
4622 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4625 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4626 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4628 (SELECT player FROM players WHERE nick='Stelisevil'),
4630 (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
4633 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4634 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4636 (SELECT player FROM players WHERE nick='Lion'),
4639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4640 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4642 (SELECT player FROM players WHERE nick='Lion'),
4644 (SELECT song FROM songs WHERE lower(title)=lower('La Senorita')),
4647 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4648 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4650 (SELECT player FROM players WHERE nick='Lion'),
4652 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
4655 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
4657 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4660 INSERT INTO groups (tournament, round, parallel) VALUES (
4661 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4663 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
4664 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4666 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow'))
4668 UPDATE rounds SET randomsongs=1 WHERE
4669 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4671 UPDATE rounds SET chosensongs=1 WHERE
4672 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4674 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4675 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4677 (SELECT player FROM players WHERE nick='Tom'),
4680 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4681 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4683 (SELECT player FROM players WHERE nick='Tom'),
4685 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4688 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4689 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4691 (SELECT player FROM players WHERE nick='Tom'),
4693 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
4696 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4697 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4699 (SELECT player FROM players WHERE nick='DufF'),
4702 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4703 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4705 (SELECT player FROM players WHERE nick='DufF'),
4707 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4710 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4711 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4713 (SELECT player FROM players WHERE nick='DufF'),
4715 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
4718 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4719 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4721 (SELECT player FROM players WHERE nick='Stelisevil'),
4724 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4725 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4727 (SELECT player FROM players WHERE nick='Stelisevil'),
4729 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4732 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4733 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4735 (SELECT player FROM players WHERE nick='Stelisevil'),
4737 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
4740 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4741 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4743 (SELECT player FROM players WHERE nick='Snute'),
4746 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4747 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4749 (SELECT player FROM players WHERE nick='Snute'),
4751 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4754 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4755 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4757 (SELECT player FROM players WHERE nick='Snute'),
4759 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
4762 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4763 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4765 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4768 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4769 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4771 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4773 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4776 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4777 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4779 (SELECT player FROM players WHERE nick='T_Bone_X_Zeo'),
4781 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
4784 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4785 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4787 (SELECT player FROM players WHERE nick='OJK'),
4790 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4791 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4793 (SELECT player FROM players WHERE nick='OJK'),
4795 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4798 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4799 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4801 (SELECT player FROM players WHERE nick='OJK'),
4803 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
4806 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4807 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4809 (SELECT player FROM players WHERE nick='Ryosuke'),
4812 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4813 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4815 (SELECT player FROM players WHERE nick='Ryosuke'),
4817 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4820 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4821 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4823 (SELECT player FROM players WHERE nick='Ryosuke'),
4825 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
4828 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4829 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4831 (SELECT player FROM players WHERE nick='Dex'),
4834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4835 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4837 (SELECT player FROM players WHERE nick='Dex'),
4839 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4842 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4843 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4845 (SELECT player FROM players WHERE nick='Dex'),
4847 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
4850 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4851 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4853 (SELECT player FROM players WHERE nick='Lion'),
4856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4857 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4859 (SELECT player FROM players WHERE nick='Lion'),
4861 (SELECT song FROM songs WHERE lower(title)=lower('Rain of Sorrow')),
4864 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4865 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4867 (SELECT player FROM players WHERE nick='Lion'),
4869 (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
4872 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
4874 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4877 INSERT INTO groups (tournament, round, parallel) VALUES (
4878 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4880 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
4881 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4883 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me'))
4885 UPDATE rounds SET randomsongs=1 WHERE
4886 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4888 UPDATE rounds SET chosensongs=1 WHERE
4889 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
4891 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4892 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4894 (SELECT player FROM players WHERE nick='Stelisevil'),
4897 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4898 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4900 (SELECT player FROM players WHERE nick='Stelisevil'),
4902 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
4905 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4906 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4908 (SELECT player FROM players WHERE nick='Stelisevil'),
4910 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
4913 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4914 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4916 (SELECT player FROM players WHERE nick='Lion'),
4919 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4920 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4922 (SELECT player FROM players WHERE nick='Lion'),
4924 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
4927 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4928 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4930 (SELECT player FROM players WHERE nick='Lion'),
4932 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
4935 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4936 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4938 (SELECT player FROM players WHERE nick='Ryosuke'),
4941 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4942 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4944 (SELECT player FROM players WHERE nick='Ryosuke'),
4946 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
4949 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4950 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4952 (SELECT player FROM players WHERE nick='Ryosuke'),
4954 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
4957 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4958 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4960 (SELECT player FROM players WHERE nick='Dex'),
4963 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4964 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4966 (SELECT player FROM players WHERE nick='Dex'),
4968 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
4971 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4972 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4974 (SELECT player FROM players WHERE nick='Dex'),
4976 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
4979 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
4980 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4982 (SELECT player FROM players WHERE nick='DufF'),
4985 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4986 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4988 (SELECT player FROM players WHERE nick='DufF'),
4990 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
4993 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
4994 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
4996 (SELECT player FROM players WHERE nick='DufF'),
4998 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
5001 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5002 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5004 (SELECT player FROM players WHERE nick='Snute'),
5007 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5008 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5010 (SELECT player FROM players WHERE nick='Snute'),
5012 (SELECT song FROM songs WHERE lower(title)=lower('I Want You To Want Me')),
5015 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5016 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5018 (SELECT player FROM players WHERE nick='Snute'),
5020 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
5023 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
5025 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5028 INSERT INTO groups (tournament, round, parallel) VALUES (
5029 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5031 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
5032 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5034 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex'))
5036 UPDATE rounds SET randomsongs=1 WHERE
5037 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
5039 UPDATE rounds SET chosensongs=1 WHERE
5040 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
5042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5043 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5045 (SELECT player FROM players WHERE nick='Stelisevil'),
5048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5049 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5051 (SELECT player FROM players WHERE nick='Stelisevil'),
5053 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
5056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5057 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5059 (SELECT player FROM players WHERE nick='Stelisevil'),
5061 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
5064 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5065 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5067 (SELECT player FROM players WHERE nick='DufF'),
5070 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5071 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5073 (SELECT player FROM players WHERE nick='DufF'),
5075 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
5078 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5079 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5081 (SELECT player FROM players WHERE nick='DufF'),
5083 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
5086 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5087 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5089 (SELECT player FROM players WHERE nick='Dex'),
5092 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5093 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5095 (SELECT player FROM players WHERE nick='Dex'),
5097 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
5100 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5101 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5103 (SELECT player FROM players WHERE nick='Dex'),
5105 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
5108 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5109 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5111 (SELECT player FROM players WHERE nick='Snute'),
5114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5115 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5117 (SELECT player FROM players WHERE nick='Snute'),
5119 (SELECT song FROM songs WHERE lower(title)=lower('The Reflex')),
5122 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5123 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5125 (SELECT player FROM players WHERE nick='Snute'),
5127 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
5130 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
5132 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5135 INSERT INTO groups (tournament, round, parallel) VALUES (
5136 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5138 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
5139 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5141 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)'))
5143 UPDATE rounds SET randomsongs=1 WHERE
5144 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
5146 UPDATE rounds SET chosensongs=1 WHERE
5147 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
5149 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5150 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5152 (SELECT player FROM players WHERE nick='DufF'),
5155 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5156 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5158 (SELECT player FROM players WHERE nick='DufF'),
5160 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
5163 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5164 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5166 (SELECT player FROM players WHERE nick='DufF'),
5168 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
5171 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5172 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5174 (SELECT player FROM players WHERE nick='Snute'),
5177 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5178 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5180 (SELECT player FROM players WHERE nick='Snute'),
5182 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
5185 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5186 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5188 (SELECT player FROM players WHERE nick='Snute'),
5190 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
5193 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5194 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5196 (SELECT player FROM players WHERE nick='Dex'),
5199 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5200 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5202 (SELECT player FROM players WHERE nick='Dex'),
5204 (SELECT song FROM songs WHERE lower(title)=lower('The Centre of the Heart (Stonebridge Club Mix)')),
5207 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5208 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5210 (SELECT player FROM players WHERE nick='Dex'),
5212 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
5215 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
5217 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5220 INSERT INTO groups (tournament, round, parallel) VALUES (
5221 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5223 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
5224 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5226 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century'))
5228 UPDATE rounds SET randomsongs=1 WHERE
5229 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
5231 UPDATE rounds SET chosensongs=1 WHERE
5232 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )) AND
5234 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5235 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5237 (SELECT player FROM players WHERE nick='DufF'),
5240 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5241 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5243 (SELECT player FROM players WHERE nick='DufF'),
5245 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
5248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5249 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5251 (SELECT player FROM players WHERE nick='DufF'),
5253 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
5256 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
5257 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5259 (SELECT player FROM players WHERE nick='Dex'),
5262 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5263 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5265 (SELECT player FROM players WHERE nick='Dex'),
5267 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
5270 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
5271 (SELECT tournament FROM tournaments WHERE tournamentname='European Cup 1' AND season=( SELECT season FROM seasons WHERE seasonname='European Cup' )),
5273 (SELECT player FROM players WHERE nick='Dex'),
5275 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),