+begin;
+INSERT INTO tournaments
+ (season, tournamentname, country, location, "date", machine, scoringsystem) VALUES (
+ (SELECT season FROM seasons WHERE seasonname='International' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 'DDRUK vs. DDRNO',
+ (SELECT country FROM countries WHERE countryname='Europe'),
+ 'Namco Station - London (United Kingdom)',
+ '2003-09-28',
+ (SELECT machine FROM machines WHERE machinename='Dance Dance Revolution 8th mix - Extreme'),
+ (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
+);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Havok'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Snute'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Slusk'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Matsi'),
+ NULL);
+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 );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ (SELECT player FROM players WHERE nick='Electus'),
+ NULL);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1);
+UPDATE rounds SET randomsongs=0 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Lawrence'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Lawrence'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 't',
+ 7520);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Lawrence'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('A')),
+ 't',
+ 7079);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Lawrence'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+ 't',
+ 6559);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Love Shine')),
+ 't',
+ 6653);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Long Train Running')),
+ 't',
+ 5984);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
+ 't',
+ 9129);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
+ 't',
+ 7891);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ 't',
+ 7989);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Love Shine')),
+ 't',
+ 6826);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Neomancer'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Neomancer'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('True -trance sunrise mix-')),
+ 't',
+ 6936);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Neomancer'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor')),
+ 't',
+ 6491);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Neomancer'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Higher')),
+ 't',
+ 4891);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ryosuke'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ryosuke'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+ 't',
+ 4287);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ryosuke'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Abyss')),
+ 't',
+ 6805);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ryosuke'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 7746);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Afronova'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Afronova'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
+ 't',
+ 7187);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Afronova'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 6804);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Afronova'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Drop the Bomb')),
+ 't',
+ 4707);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='ChocoboGhost'),
+ 7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='ChocoboGhost'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Be Lovin')),
+ 't',
+ 7316);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='ChocoboGhost'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Rhythm and Police')),
+ 't',
+ 7562);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='ChocoboGhost'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Hold on me')),
+ 't',
+ 5442);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Burnin the floor -momo mix-')),
+ 't',
+ 7656);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 't',
+ 7972);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('La copa de la vida')),
+ 't',
+ 6705);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Healingvizion'),
+ 9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Healingvizion'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+ 't',
+ 6454);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Healingvizion'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Ecstasy')),
+ 't',
+ 5863);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Healingvizion'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
+ 't',
+ 8180);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 10
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 6877);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Senorita -speedy mix-')),
+ 't',
+ 6975);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ 't',
+ 7928);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2);
+UPDATE rounds SET randomsongs=0 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=1;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
+ 't',
+ 7524);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Destiny')),
+ 't',
+ 5442);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 6968);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
+ 't',
+ 8512);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 't',
+ 7203);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Brilliant 2 U')),
+ 't',
+ 4888);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Havok'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Havok'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Drop out -remix-')),
+ 't',
+ 5087);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Havok'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dance Dance Revolution')),
+ 't',
+ 5923);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Havok'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Keep On Movin\'')),
+ 't',
+ 4413);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Matsi'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Matsi'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('57 metallic gray')),
+ 't',
+ 4516);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Matsi'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 't',
+ 4250);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Matsi'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 't',
+ 5944);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Electus'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Electus'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Absolute')),
+ 't',
+ 5224);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Electus'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Bag')),
+ 't',
+ 0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Electus'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 6334);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Last Message')),
+ 't',
+ 5177);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 6870);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Blue Impulse')),
+ 't',
+ 5668);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Slusk'),
+ 7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Slusk'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
+ 't',
+ 6830);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Slusk'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Sobakasu (Freckles)')),
+ 't',
+ 4845);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Slusk'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('B4U')),
+ 't',
+ 7114);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 8
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+ 't',
+ 6600);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Synchronized Love')),
+ 't',
+ 6565);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
+ 't',
+ 7563);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ 9
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+ 't',
+ 4718);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
+ 't',
+ 5895);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
+ 't',
+ 6713);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 10
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision')),
+ 't',
+ 7929);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
+ 't',
+ 8035);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Baby Baby Gimme Your Love')),
+ 't',
+ 5290);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0);
+UPDATE rounds SET randomsongs=0 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )) AND
+ round=2;
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Maxx Unlimited')),
+ 't',
+ 8581);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+ 't',
+ 7670);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Daikenkai')),
+ 't',
+ 7360);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Maxx Unlimited')),
+ 't',
+ 7038);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love')),
+ 't',
+ 7384);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Daikenkai')),
+ 't',
+ 6844);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 't',
+ 6989);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
+ 't',
+ 7463);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 5,
+ (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+ 't',
+ 5993);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 't',
+ 7103);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('The Legend of Max')),
+ 't',
+ 7134);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+ 't',
+ 6358);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor Max')),
+ 't',
+ 6801);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('Orion.78 -civ mix-')),
+ 't',
+ 7182);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ 5,
+ (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ 't',
+ 7626);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia Survivor Max')),
+ 't',
+ 0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Orion.78 -civ mix-')),
+ 't',
+ 6586);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ 't',
+ 7450);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 8001);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+ 't',
+ 8033);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 5,
+ (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+ 't',
+ 5679);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
+ 't',
+ 0);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
+ 't',
+ 6553);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Secret Rendez-vous')),
+ 't',
+ 4484);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+ 't',
+ 6731);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('Genom Screams')),
+ 't',
+ 6010);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ 5,
+ (SELECT song FROM songs WHERE lower(title)=lower('Matsuri Japan')),
+ 't',
+ 6501);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
+ 't',
+ 7110);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Genom Screams')),
+ 't',
+ 6730);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Matsuri Japan')),
+ 't',
+ 7726);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+ 't',
+ 7098);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('I Do I Do I Do')),
+ 't',
+ 5977);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Oliyzia'),
+ 5,
+ (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
+ 't',
+ 8194);
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 7
+);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('DXY!')),
+ 't',
+ 6481);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('I Do I Do I Do')),
+ 't',
+ 6978);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Sakura')),
+ 't',
+ 8718);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('Paranoia')),
+ 't',
+ 6700);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 4,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
+ 't',
+ 8065);
+INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE tournamentname='DDRUK vs. DDRNO' AND season=( SELECT season FROM seasons WHERE seasonname='International' )),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ 5,
+ (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
+ 't',
+ 8220);
+commit;
projects / ccbs / blobdiff