2 INSERT INTO tournaments
3 (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
4 (SELECT season FROM seasons WHERE seasonname='International' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
6 (SELECT country FROM countries WHERE countryname='Europe'),
7 'Namco Station - London (United Kingdom)',
9 (SELECT machine FROM machines WHERE machinename='DDR Extreme'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lawrence' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lawrence' NOT IN ( SELECT nick FROM players );
13 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
14 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
16 (SELECT player FROM players WHERE nick='Lawrence'),
18 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 );
19 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
20 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
22 (SELECT player FROM players WHERE nick='Stelisevil'),
24 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Usagi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Usagi' NOT IN ( SELECT nick FROM players );
25 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
26 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
28 (SELECT player FROM players WHERE nick='Usagi'),
30 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Neomancer' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Neomancer' NOT IN ( SELECT nick FROM players );
31 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
32 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
34 (SELECT player FROM players WHERE nick='Neomancer'),
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='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
40 (SELECT player FROM players WHERE nick='Ryosuke'),
42 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afronova' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afronova' NOT IN ( SELECT nick FROM players );
43 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
44 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
46 (SELECT player FROM players WHERE nick='Afronova'),
48 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ChocoboGhost' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ChocoboGhost' NOT IN ( SELECT nick FROM players );
49 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
50 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
52 (SELECT player FROM players WHERE nick='ChocoboGhost'),
54 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sensei' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sensei' NOT IN ( SELECT nick FROM players );
55 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
56 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
58 (SELECT player FROM players WHERE nick='Sensei'),
60 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 );
61 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
62 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
64 (SELECT player FROM players WHERE nick='Healingvizion'),
66 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nanaki Lioness' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nanaki Lioness' NOT IN ( SELECT nick FROM players );
67 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
68 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
70 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
72 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 );
73 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
74 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
76 (SELECT player FROM players WHERE nick='Havok'),
78 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 );
79 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
80 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
82 (SELECT player FROM players WHERE nick='Draconia'),
84 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 );
85 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
86 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
88 (SELECT player FROM players WHERE nick='Snute'),
90 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 );
91 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
92 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
94 (SELECT player FROM players WHERE nick='Oliyzia'),
96 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 );
97 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
98 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
100 (SELECT player FROM players WHERE nick='DufF'),
102 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
103 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
104 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
106 (SELECT player FROM players WHERE nick='Slusk'),
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='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
112 (SELECT player FROM players WHERE nick='RiChY'),
114 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 );
115 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
116 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
118 (SELECT player FROM players WHERE nick='Smiph'),
120 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
121 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
122 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
124 (SELECT player FROM players WHERE nick='Matsi'),
126 INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Electus' NOT IN ( SELECT nick FROM players );
127 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
128 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
130 (SELECT player FROM players WHERE nick='Electus'),
132 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
134 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
137 INSERT INTO groups (tournament, round, parallel) VALUES (
138 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
140 UPDATE rounds SET randomsongs=0 WHERE
141 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
143 UPDATE rounds SET chosensongs=1 WHERE
144 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
146 UPDATE rounds SET chosensongs=1 WHERE
147 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
149 UPDATE rounds SET chosensongs=1 WHERE
150 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
152 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
153 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
155 (SELECT player FROM players WHERE nick='Lawrence'),
158 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
159 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
161 (SELECT player FROM players WHERE nick='Lawrence'),
163 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
166 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
167 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
169 (SELECT player FROM players WHERE nick='Lawrence'),
171 (SELECT song FROM songs WHERE lower(title)=lower('A')),
174 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
175 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
177 (SELECT player FROM players WHERE nick='Lawrence'),
179 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
182 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
183 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
185 (SELECT player FROM players WHERE nick='Stelisevil'),
188 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
189 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
191 (SELECT player FROM players WHERE nick='Stelisevil'),
193 (SELECT song FROM songs WHERE lower(title)=lower('LOVE ❤ SHINE')),
196 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
197 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
199 (SELECT player FROM players WHERE nick='Stelisevil'),
201 (SELECT song FROM songs WHERE lower(title)=lower('LONG TRAIN RUNNIN\'')),
204 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
205 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
207 (SELECT player FROM players WHERE nick='Stelisevil'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
212 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
213 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
215 (SELECT player FROM players WHERE nick='Usagi'),
218 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
219 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
221 (SELECT player FROM players WHERE nick='Usagi'),
223 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
226 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
227 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
229 (SELECT player FROM players WHERE nick='Usagi'),
231 (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
234 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
235 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
237 (SELECT player FROM players WHERE nick='Usagi'),
239 (SELECT song FROM songs WHERE lower(title)=lower('LOVE ❤ SHINE')),
242 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
243 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
245 (SELECT player FROM players WHERE nick='Neomancer'),
248 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
249 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
251 (SELECT player FROM players WHERE nick='Neomancer'),
253 (SELECT song FROM songs WHERE lower(title)=lower('true... ~trance sunrise mix~')),
256 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
257 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
259 (SELECT player FROM players WHERE nick='Neomancer'),
261 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor')),
264 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
265 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
267 (SELECT player FROM players WHERE nick='Neomancer'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
272 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
273 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
275 (SELECT player FROM players WHERE nick='Ryosuke'),
278 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
279 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
281 (SELECT player FROM players WHERE nick='Ryosuke'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
286 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
287 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
289 (SELECT player FROM players WHERE nick='Ryosuke'),
291 (SELECT song FROM songs WHERE lower(title)=lower('Abyss')),
294 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
295 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
297 (SELECT player FROM players WHERE nick='Ryosuke'),
299 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
302 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
303 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
305 (SELECT player FROM players WHERE nick='Afronova'),
308 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
309 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
311 (SELECT player FROM players WHERE nick='Afronova'),
313 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
316 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
317 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
319 (SELECT player FROM players WHERE nick='Afronova'),
321 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
324 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
325 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
327 (SELECT player FROM players WHERE nick='Afronova'),
329 (SELECT song FROM songs WHERE lower(title)=lower('Drop the Bomb')),
332 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
333 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
335 (SELECT player FROM players WHERE nick='ChocoboGhost'),
338 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
339 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
341 (SELECT player FROM players WHERE nick='ChocoboGhost'),
343 (SELECT song FROM songs WHERE lower(title)=lower('Be Lovin')),
346 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
347 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
349 (SELECT player FROM players WHERE nick='ChocoboGhost'),
351 (SELECT song FROM songs WHERE lower(title)=lower('RHYTHM AND POLICE (K.O.G G3 Mix)')),
354 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
355 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
357 (SELECT player FROM players WHERE nick='ChocoboGhost'),
359 (SELECT song FROM songs WHERE lower(title)=lower('Hold on me')),
362 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
363 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
365 (SELECT player FROM players WHERE nick='Sensei'),
368 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
369 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
371 (SELECT player FROM players WHERE nick='Sensei'),
373 (SELECT song FROM songs WHERE lower(title)=lower('BURNIN\' THE FLOOR (MOMO MIX)')),
376 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
377 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
379 (SELECT player FROM players WHERE nick='Sensei'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
384 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
385 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
387 (SELECT player FROM players WHERE nick='Sensei'),
389 (SELECT song FROM songs WHERE lower(title)=lower('La copa de la vida')),
392 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
395 (SELECT player FROM players WHERE nick='Healingvizion'),
398 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
399 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
401 (SELECT player FROM players WHERE nick='Healingvizion'),
403 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
406 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
407 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
409 (SELECT player FROM players WHERE nick='Healingvizion'),
411 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
414 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
415 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
417 (SELECT player FROM players WHERE nick='Healingvizion'),
419 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
422 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
423 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
425 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
428 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
429 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
431 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
433 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
436 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
437 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
439 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
441 (SELECT song FROM songs WHERE lower(title)=lower('SENORITA (Speedy Mix)')),
444 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
445 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
447 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
449 (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
452 INSERT INTO groups (tournament, round, parallel) VALUES (
453 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
455 UPDATE rounds SET randomsongs=0 WHERE
456 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
458 UPDATE rounds SET chosensongs=1 WHERE
459 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
461 UPDATE rounds SET chosensongs=1 WHERE
462 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
464 UPDATE rounds SET chosensongs=1 WHERE
465 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
467 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
468 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
470 (SELECT player FROM players WHERE nick='RiChY'),
473 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
474 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
476 (SELECT player FROM players WHERE nick='RiChY'),
478 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
481 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
482 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
484 (SELECT player FROM players WHERE nick='RiChY'),
486 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
489 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
490 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
492 (SELECT player FROM players WHERE nick='RiChY'),
494 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
497 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
498 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
500 (SELECT player FROM players WHERE nick='DufF'),
503 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
504 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
506 (SELECT player FROM players WHERE nick='DufF'),
508 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
511 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
512 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
514 (SELECT player FROM players WHERE nick='DufF'),
516 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
519 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
520 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
522 (SELECT player FROM players WHERE nick='DufF'),
524 (SELECT song FROM songs WHERE lower(title)=lower('BRILLIANT 2U')),
527 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
528 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
530 (SELECT player FROM players WHERE nick='Havok'),
533 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
534 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
536 (SELECT player FROM players WHERE nick='Havok'),
538 (SELECT song FROM songs WHERE lower(title)=lower('DROP OUT (FROM NONSTOP MEGAMIX)')),
541 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
542 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
544 (SELECT player FROM players WHERE nick='Havok'),
546 (SELECT song FROM songs WHERE lower(title)=lower('Dance Dance Revolution')),
549 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
550 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
552 (SELECT player FROM players WHERE nick='Havok'),
554 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
557 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
558 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
560 (SELECT player FROM players WHERE nick='Matsi'),
563 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
564 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
566 (SELECT player FROM players WHERE nick='Matsi'),
568 (SELECT song FROM songs WHERE lower(title)=lower('Heaven is a \'57 metallic gray (gimmix)')),
571 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
572 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
574 (SELECT player FROM players WHERE nick='Matsi'),
576 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
579 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
580 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
582 (SELECT player FROM players WHERE nick='Matsi'),
584 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
587 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
588 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
590 (SELECT player FROM players WHERE nick='Electus'),
593 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
594 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
596 (SELECT player FROM players WHERE nick='Electus'),
598 (SELECT song FROM songs WHERE lower(title)=lower('Absolute')),
601 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
602 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
604 (SELECT player FROM players WHERE nick='Electus'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Bag')),
609 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
610 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
612 (SELECT player FROM players WHERE nick='Electus'),
614 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
617 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
618 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
620 (SELECT player FROM players WHERE nick='Smiph'),
623 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
624 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
626 (SELECT player FROM players WHERE nick='Smiph'),
628 (SELECT song FROM songs WHERE lower(title)=lower('Last Message')),
631 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
632 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
634 (SELECT player FROM players WHERE nick='Smiph'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
639 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
640 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
642 (SELECT player FROM players WHERE nick='Smiph'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Aoi Shoudou (for EXTREME) [Blue Impulse]')),
647 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
648 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
650 (SELECT player FROM players WHERE nick='Slusk'),
653 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
654 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
656 (SELECT player FROM players WHERE nick='Slusk'),
658 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
661 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
662 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
664 (SELECT player FROM players WHERE nick='Slusk'),
666 (SELECT song FROM songs WHERE lower(title)=lower('SOBAKASU FRECKLES')),
669 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
670 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
672 (SELECT player FROM players WHERE nick='Slusk'),
674 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
677 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
678 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
680 (SELECT player FROM players WHERE nick='Oliyzia'),
683 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
684 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
686 (SELECT player FROM players WHERE nick='Oliyzia'),
688 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
691 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
692 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
694 (SELECT player FROM players WHERE nick='Oliyzia'),
696 (SELECT song FROM songs WHERE lower(title)=lower('SYNCHRONIZED LOVE (Red Monster Hyper Mix)')),
699 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
700 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
702 (SELECT player FROM players WHERE nick='Oliyzia'),
704 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
707 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
708 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
710 (SELECT player FROM players WHERE nick='Draconia'),
713 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
714 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
716 (SELECT player FROM players WHERE nick='Draconia'),
718 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
721 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
722 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
724 (SELECT player FROM players WHERE nick='Draconia'),
726 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
729 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
730 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
732 (SELECT player FROM players WHERE nick='Draconia'),
734 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
737 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
738 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
740 (SELECT player FROM players WHERE nick='Snute'),
743 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
744 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
746 (SELECT player FROM players WHERE nick='Snute'),
748 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision')),
751 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
752 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
754 (SELECT player FROM players WHERE nick='Snute'),
756 (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
759 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
760 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
762 (SELECT player FROM players WHERE nick='Snute'),
764 (SELECT song FROM songs WHERE lower(title)=lower('Baby Baby Gimme Your Love')),
767 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
769 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
772 INSERT INTO groups (tournament, round, parallel) VALUES (
773 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
775 UPDATE rounds SET randomsongs=0 WHERE
776 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
778 UPDATE rounds SET chosensongs=1 WHERE
779 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
781 UPDATE rounds SET chosensongs=1 WHERE
782 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
784 UPDATE rounds SET chosensongs=1 WHERE
785 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
787 UPDATE rounds SET chosensongs=1 WHERE
788 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
790 UPDATE rounds SET chosensongs=1 WHERE
791 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
793 UPDATE rounds SET chosensongs=1 WHERE
794 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
796 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
797 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
799 (SELECT player FROM players WHERE nick='Usagi'),
802 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
803 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
805 (SELECT player FROM players WHERE nick='Usagi'),
807 (SELECT song FROM songs WHERE lower(title)=lower('Maxx Unlimited')),
810 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
811 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
813 (SELECT player FROM players WHERE nick='Usagi'),
815 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
818 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
819 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
821 (SELECT player FROM players WHERE nick='Usagi'),
823 (SELECT song FROM songs WHERE lower(title)=lower('Daikenkai')),
826 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
827 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
829 (SELECT player FROM players WHERE nick='Snute'),
832 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
833 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
835 (SELECT player FROM players WHERE nick='Snute'),
837 (SELECT song FROM songs WHERE lower(title)=lower('Maxx Unlimited')),
840 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
841 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
843 (SELECT player FROM players WHERE nick='Snute'),
845 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
848 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
849 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
851 (SELECT player FROM players WHERE nick='Snute'),
853 (SELECT song FROM songs WHERE lower(title)=lower('Daikenkai')),
856 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
857 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
859 (SELECT player FROM players WHERE nick='Snute'),
861 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
864 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
865 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
867 (SELECT player FROM players WHERE nick='Snute'),
869 (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
872 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
873 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
875 (SELECT player FROM players WHERE nick='Snute'),
877 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
880 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
881 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
883 (SELECT player FROM players WHERE nick='Stelisevil'),
886 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
887 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
889 (SELECT player FROM players WHERE nick='Stelisevil'),
891 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
894 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
895 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
897 (SELECT player FROM players WHERE nick='Stelisevil'),
899 (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
902 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
903 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
905 (SELECT player FROM players WHERE nick='Stelisevil'),
907 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
910 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
911 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
913 (SELECT player FROM players WHERE nick='Stelisevil'),
915 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor Max')),
918 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
919 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
921 (SELECT player FROM players WHERE nick='Stelisevil'),
923 (SELECT song FROM songs WHERE lower(title)=lower('ORION .78 (civilization mix)')),
926 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
927 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
929 (SELECT player FROM players WHERE nick='Stelisevil'),
931 (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
934 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
935 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
937 (SELECT player FROM players WHERE nick='DufF'),
940 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
941 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
943 (SELECT player FROM players WHERE nick='DufF'),
945 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor Max')),
948 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
949 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
951 (SELECT player FROM players WHERE nick='DufF'),
953 (SELECT song FROM songs WHERE lower(title)=lower('ORION .78 (civilization mix)')),
956 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
957 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
959 (SELECT player FROM players WHERE nick='DufF'),
961 (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
964 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
965 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
967 (SELECT player FROM players WHERE nick='DufF'),
969 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
972 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
973 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
975 (SELECT player FROM players WHERE nick='DufF'),
977 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
980 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
981 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
983 (SELECT player FROM players WHERE nick='DufF'),
985 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
988 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
989 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
991 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
994 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
995 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
997 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
999 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
1002 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1003 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1005 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
1007 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
1010 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1011 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1013 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
1015 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
1018 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1019 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1021 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
1023 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1026 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1027 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1029 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
1031 (SELECT song FROM songs WHERE lower(title)=lower('Genom Screams')),
1034 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1035 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1037 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
1039 (SELECT song FROM songs WHERE lower(title)=lower('Matsuri Japan')),
1042 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1043 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1045 (SELECT player FROM players WHERE nick='Oliyzia'),
1048 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1049 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1051 (SELECT player FROM players WHERE nick='Oliyzia'),
1053 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
1056 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1057 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1059 (SELECT player FROM players WHERE nick='Oliyzia'),
1061 (SELECT song FROM songs WHERE lower(title)=lower('Genom Screams')),
1064 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1065 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1067 (SELECT player FROM players WHERE nick='Oliyzia'),
1069 (SELECT song FROM songs WHERE lower(title)=lower('Matsuri Japan')),
1072 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1073 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1075 (SELECT player FROM players WHERE nick='Oliyzia'),
1077 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1080 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1081 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1083 (SELECT player FROM players WHERE nick='Oliyzia'),
1085 (SELECT song FROM songs WHERE lower(title)=lower('I Do I Do I Do')),
1088 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1089 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1091 (SELECT player FROM players WHERE nick='Oliyzia'),
1093 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
1096 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1097 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1099 (SELECT player FROM players WHERE nick='Sensei'),
1102 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1103 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1105 (SELECT player FROM players WHERE nick='Sensei'),
1107 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1110 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1111 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1113 (SELECT player FROM players WHERE nick='Sensei'),
1115 (SELECT song FROM songs WHERE lower(title)=lower('I Do I Do I Do')),
1118 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1119 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1121 (SELECT player FROM players WHERE nick='Sensei'),
1123 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
1126 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1127 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1129 (SELECT player FROM players WHERE nick='Sensei'),
1131 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia')),
1134 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1135 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1137 (SELECT player FROM players WHERE nick='Sensei'),
1139 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1142 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1143 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1145 (SELECT player FROM players WHERE nick='Sensei'),
1147 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),