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='Dance Dance Revolution 8th mix - Extreme'),
10 (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
12 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 );
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='Havok'),
18 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 );
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='Draconia'),
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='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
28 (SELECT player FROM players WHERE nick='Snute'),
30 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 );
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='Oliyzia'),
36 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 );
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='DufF'),
42 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 );
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='Slusk'),
48 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 );
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='RiChY'),
54 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 );
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='Smiph'),
60 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 );
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='Matsi'),
66 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 );
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='Electus'),
72 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
74 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
77 INSERT INTO groups (tournament, round, parallel) VALUES (
78 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
80 UPDATE rounds SET randomsongs=0 WHERE
81 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
83 UPDATE rounds SET chosensongs=1 WHERE
84 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
86 UPDATE rounds SET chosensongs=1 WHERE
87 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
89 UPDATE rounds SET chosensongs=1 WHERE
90 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
92 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
93 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
95 (SELECT player FROM players WHERE nick='Lawrence'),
98 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
99 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
101 (SELECT player FROM players WHERE nick='Lawrence'),
103 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
106 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
107 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
109 (SELECT player FROM players WHERE nick='Lawrence'),
111 (SELECT song FROM songs WHERE lower(title)=lower('A')),
114 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
115 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
117 (SELECT player FROM players WHERE nick='Lawrence'),
119 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
122 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
123 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
125 (SELECT player FROM players WHERE nick='Stelisevil'),
128 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
129 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
131 (SELECT player FROM players WHERE nick='Stelisevil'),
133 (SELECT song FROM songs WHERE lower(title)=lower('Love Shine')),
136 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
137 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
139 (SELECT player FROM players WHERE nick='Stelisevil'),
141 (SELECT song FROM songs WHERE lower(title)=lower('Long Train Running')),
144 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
145 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
147 (SELECT player FROM players WHERE nick='Stelisevil'),
149 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
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='Usagi'),
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='Usagi'),
163 (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
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='Usagi'),
171 (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
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='Usagi'),
179 (SELECT song FROM songs WHERE lower(title)=lower('Love Shine')),
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='Neomancer'),
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='Neomancer'),
193 (SELECT song FROM songs WHERE lower(title)=lower('True -trance sunrise mix-')),
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='Neomancer'),
201 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor')),
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='Neomancer'),
209 (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
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='Ryosuke'),
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='Ryosuke'),
223 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
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='Ryosuke'),
231 (SELECT song FROM songs WHERE lower(title)=lower('Abyss')),
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='Ryosuke'),
239 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
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='Afronova'),
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='Afronova'),
253 (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
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='Afronova'),
261 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
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='Afronova'),
269 (SELECT song FROM songs WHERE lower(title)=lower('Drop the Bomb')),
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='ChocoboGhost'),
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='ChocoboGhost'),
283 (SELECT song FROM songs WHERE lower(title)=lower('Be Lovin')),
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='ChocoboGhost'),
291 (SELECT song FROM songs WHERE lower(title)=lower('Rhythm and Police')),
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='ChocoboGhost'),
299 (SELECT song FROM songs WHERE lower(title)=lower('Hold on me')),
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='Sensei'),
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='Sensei'),
313 (SELECT song FROM songs WHERE lower(title)=lower('Burnin the floor -momo mix-')),
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='Sensei'),
321 (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
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='Sensei'),
329 (SELECT song FROM songs WHERE lower(title)=lower('La copa de la vida')),
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='Healingvizion'),
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='Healingvizion'),
343 (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
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='Healingvizion'),
351 (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
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='Healingvizion'),
359 (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
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='Nanaki Lioness'),
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='Nanaki Lioness'),
373 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
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='Nanaki Lioness'),
381 (SELECT song FROM songs WHERE lower(title)=lower('Senorita -speedy 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='Nanaki Lioness'),
389 (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
392 INSERT INTO groups (tournament, round, parallel) VALUES (
393 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
395 UPDATE rounds SET randomsongs=0 WHERE
396 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
398 UPDATE rounds SET chosensongs=1 WHERE
399 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
401 UPDATE rounds SET chosensongs=1 WHERE
402 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
404 UPDATE rounds SET chosensongs=1 WHERE
405 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
407 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
408 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
410 (SELECT player FROM players WHERE nick='RiChY'),
413 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
414 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
416 (SELECT player FROM players WHERE nick='RiChY'),
418 (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
421 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
422 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
424 (SELECT player FROM players WHERE nick='RiChY'),
426 (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
429 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
430 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
432 (SELECT player FROM players WHERE nick='RiChY'),
434 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
437 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
438 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
440 (SELECT player FROM players WHERE nick='DufF'),
443 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
444 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
446 (SELECT player FROM players WHERE nick='DufF'),
448 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
451 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
452 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
454 (SELECT player FROM players WHERE nick='DufF'),
456 (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
459 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
460 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
462 (SELECT player FROM players WHERE nick='DufF'),
464 (SELECT song FROM songs WHERE lower(title)=lower('Brilliant 2 U')),
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='Havok'),
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='Havok'),
478 (SELECT song FROM songs WHERE lower(title)=lower('Drop out -remix-')),
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='Havok'),
486 (SELECT song FROM songs WHERE lower(title)=lower('Dance Dance Revolution')),
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='Havok'),
494 (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
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='Matsi'),
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='Matsi'),
508 (SELECT song FROM songs WHERE lower(title)=lower('57 metallic gray')),
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='Matsi'),
516 (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
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='Matsi'),
524 (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
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='Electus'),
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='Electus'),
538 (SELECT song FROM songs WHERE lower(title)=lower('Absolute')),
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='Electus'),
546 (SELECT song FROM songs WHERE lower(title)=lower('Bag')),
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='Electus'),
554 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
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='Smiph'),
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='Smiph'),
568 (SELECT song FROM songs WHERE lower(title)=lower('Last Message')),
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='Smiph'),
576 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
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='Smiph'),
584 (SELECT song FROM songs WHERE lower(title)=lower('Blue Impulse')),
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='Slusk'),
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='Slusk'),
598 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
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='Slusk'),
606 (SELECT song FROM songs WHERE lower(title)=lower('Sobakasu (Freckles)')),
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='Slusk'),
614 (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
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='Oliyzia'),
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='Oliyzia'),
628 (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
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='Oliyzia'),
636 (SELECT song FROM songs WHERE lower(title)=lower('Synchronized Love')),
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='Oliyzia'),
644 (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
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='Draconia'),
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='Draconia'),
658 (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
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='Draconia'),
666 (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
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='Draconia'),
674 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
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='Snute'),
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='Snute'),
688 (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision')),
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='Snute'),
696 (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
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='Snute'),
704 (SELECT song FROM songs WHERE lower(title)=lower('Baby Baby Gimme Your Love')),
707 INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
709 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
712 INSERT INTO groups (tournament, round, parallel) VALUES (
713 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
715 UPDATE rounds SET randomsongs=0 WHERE
716 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
718 UPDATE rounds SET chosensongs=1 WHERE
719 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
721 UPDATE rounds SET chosensongs=1 WHERE
722 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
724 UPDATE rounds SET chosensongs=1 WHERE
725 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
727 UPDATE rounds SET chosensongs=1 WHERE
728 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
730 UPDATE rounds SET chosensongs=1 WHERE
731 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
733 UPDATE rounds SET chosensongs=1 WHERE
734 tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
736 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
737 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
739 (SELECT player FROM players WHERE nick='Usagi'),
742 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
743 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
745 (SELECT player FROM players WHERE nick='Usagi'),
747 (SELECT song FROM songs WHERE lower(title)=lower('Maxx Unlimited')),
750 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
751 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
753 (SELECT player FROM players WHERE nick='Usagi'),
755 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
758 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
759 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
761 (SELECT player FROM players WHERE nick='Usagi'),
763 (SELECT song FROM songs WHERE lower(title)=lower('Daikenkai')),
766 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
767 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
769 (SELECT player FROM players WHERE nick='Snute'),
772 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
773 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
775 (SELECT player FROM players WHERE nick='Snute'),
777 (SELECT song FROM songs WHERE lower(title)=lower('Maxx Unlimited')),
780 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
781 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
783 (SELECT player FROM players WHERE nick='Snute'),
785 (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
788 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
789 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
791 (SELECT player FROM players WHERE nick='Snute'),
793 (SELECT song FROM songs WHERE lower(title)=lower('Daikenkai')),
796 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) 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='Snute'),
801 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
804 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
805 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
807 (SELECT player FROM players WHERE nick='Snute'),
809 (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
812 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
813 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
815 (SELECT player FROM players WHERE nick='Snute'),
817 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
820 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
821 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
823 (SELECT player FROM players WHERE nick='Stelisevil'),
826 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) 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='Stelisevil'),
831 (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
834 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
835 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
837 (SELECT player FROM players WHERE nick='Stelisevil'),
839 (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
842 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
843 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
845 (SELECT player FROM players WHERE nick='Stelisevil'),
847 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
850 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
851 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
853 (SELECT player FROM players WHERE nick='Stelisevil'),
855 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor Max')),
858 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
859 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
861 (SELECT player FROM players WHERE nick='Stelisevil'),
863 (SELECT song FROM songs WHERE lower(title)=lower('Orion.78 -civ mix-')),
866 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
867 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
869 (SELECT player FROM players WHERE nick='Stelisevil'),
871 (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
874 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
875 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
877 (SELECT player FROM players WHERE nick='DufF'),
880 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) 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='DufF'),
885 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor Max')),
888 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
889 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
891 (SELECT player FROM players WHERE nick='DufF'),
893 (SELECT song FROM songs WHERE lower(title)=lower('Orion.78 -civ mix-')),
896 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
897 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
899 (SELECT player FROM players WHERE nick='DufF'),
901 (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
904 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
905 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
907 (SELECT player FROM players WHERE nick='DufF'),
909 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
912 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
913 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
915 (SELECT player FROM players WHERE nick='DufF'),
917 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
920 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
921 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
923 (SELECT player FROM players WHERE nick='DufF'),
925 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
928 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
929 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
931 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
934 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) 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='Nanaki Lioness'),
939 (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
942 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
943 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
945 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
947 (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
950 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
951 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
953 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
955 (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
958 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
959 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
961 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
963 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
966 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
967 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
969 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
971 (SELECT song FROM songs WHERE lower(title)=lower('Genom Screams')),
974 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
975 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
977 (SELECT player FROM players WHERE nick='Nanaki Lioness'),
979 (SELECT song FROM songs WHERE lower(title)=lower('Matsuri Japan')),
982 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
983 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
985 (SELECT player FROM players WHERE nick='Oliyzia'),
988 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) 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='Oliyzia'),
993 (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
996 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
997 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
999 (SELECT player FROM players WHERE nick='Oliyzia'),
1001 (SELECT song FROM songs WHERE lower(title)=lower('Genom Screams')),
1004 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1005 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1007 (SELECT player FROM players WHERE nick='Oliyzia'),
1009 (SELECT song FROM songs WHERE lower(title)=lower('Matsuri Japan')),
1012 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1013 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1015 (SELECT player FROM players WHERE nick='Oliyzia'),
1017 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1020 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1021 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1023 (SELECT player FROM players WHERE nick='Oliyzia'),
1025 (SELECT song FROM songs WHERE lower(title)=lower('I Do I Do I Do')),
1028 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1029 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1031 (SELECT player FROM players WHERE nick='Oliyzia'),
1033 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
1036 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1037 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1039 (SELECT player FROM players WHERE nick='Sensei'),
1042 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) 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='Sensei'),
1047 (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
1050 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1051 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1053 (SELECT player FROM players WHERE nick='Sensei'),
1055 (SELECT song FROM songs WHERE lower(title)=lower('I Do I Do I Do')),
1058 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1059 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1061 (SELECT player FROM players WHERE nick='Sensei'),
1063 (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
1066 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1067 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1069 (SELECT player FROM players WHERE nick='Sensei'),
1071 (SELECT song FROM songs WHERE lower(title)=lower('Paranoia')),
1074 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1075 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1077 (SELECT player FROM players WHERE nick='Sensei'),
1079 (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
1082 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1083 (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
1085 (SELECT player FROM players WHERE nick='Sensei'),
1087 (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),