(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 machine FROM machines WHERE machinename='DDR Extreme'),
(SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Lawrence' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Lawrence' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Lawrence'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stelisevil' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Stelisevil' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Stelisevil'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Usagi' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Usagi' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Usagi'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Neomancer' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Neomancer' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Neomancer'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ryosuke' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Ryosuke' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Ryosuke'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Afronova' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Afronova' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Afronova'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ChocoboGhost' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'ChocoboGhost' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='ChocoboGhost'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Sensei' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Sensei' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Sensei'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Healingvizion' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Healingvizion' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Healingvizion'),
+ NULL);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nanaki Lioness' AS nick, ( SELECT country FROM countries WHERE countryname='Norway' ) AS country WHERE 'Nanaki Lioness' NOT IN ( SELECT nick FROM players );
+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' )),
+ 1,
+ (SELECT player FROM players WHERE nick='Nanaki Lioness'),
+ NULL);
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' )),
1, 1,
(SELECT player FROM players WHERE nick='Stelisevil'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('Love Shine')),
+ (SELECT song FROM songs WHERE lower(title)=lower('LOVE ❤ SHINE')),
't',
6653);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Stelisevil'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Long Train Running')),
+ (SELECT song FROM songs WHERE lower(title)=lower('LONG TRAIN RUNNIN\'')),
't',
5984);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Usagi'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
't',
7989);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Usagi'),
2,
- (SELECT song FROM songs WHERE lower(title)=lower('Love Shine')),
+ (SELECT song FROM songs WHERE lower(title)=lower('LOVE ❤ SHINE')),
't',
6826);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Neomancer'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('True -trance sunrise mix-')),
+ (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 (
1, 1,
(SELECT player FROM players WHERE nick='ChocoboGhost'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Rhythm and Police')),
+ (SELECT song FROM songs WHERE lower(title)=lower('RHYTHM AND POLICE (K.O.G G3 Mix)')),
't',
7562);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 1,
(SELECT player FROM players WHERE nick='Sensei'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('Burnin the floor -momo mix-')),
+ (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 (
1, 1,
(SELECT player FROM players WHERE nick='Nanaki Lioness'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Senorita -speedy mix-')),
+ (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 (
1, 1,
(SELECT player FROM players WHERE nick='Nanaki Lioness'),
2,
- (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
't',
7928);
INSERT INTO groups (tournament, round, parallel) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='DufF'),
2,
- (SELECT song FROM songs WHERE lower(title)=lower('Brilliant 2 U')),
+ (SELECT song FROM songs WHERE lower(title)=lower('BRILLIANT 2U')),
't',
4888);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Havok'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('Drop out -remix-')),
+ (SELECT song FROM songs WHERE lower(title)=lower('DROP OUT (FROM NONSTOP MEGAMIX)')),
't',
5087);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Matsi'),
0,
- (SELECT song FROM songs WHERE lower(title)=lower('57 metallic gray')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Heaven is a \'57 metallic gray (gimmix)')),
't',
4516);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Smiph'),
2,
- (SELECT song FROM songs WHERE lower(title)=lower('Blue Impulse')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Aoi Shoudou (for EXTREME) [Blue Impulse]')),
't',
5668);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Slusk'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Sobakasu (Freckles)')),
+ (SELECT song FROM songs WHERE lower(title)=lower('SOBAKASU FRECKLES')),
't',
4845);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
1, 2,
(SELECT player FROM players WHERE nick='Oliyzia'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Synchronized Love')),
+ (SELECT song FROM songs WHERE lower(title)=lower('SYNCHRONIZED LOVE (Red Monster Hyper Mix)')),
't',
6565);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 0,
(SELECT player FROM players WHERE nick='Stelisevil'),
4,
- (SELECT song FROM songs WHERE lower(title)=lower('Orion.78 -civ mix-')),
+ (SELECT song FROM songs WHERE lower(title)=lower('ORION .78 (civilization mix)')),
't',
7182);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 0,
(SELECT player FROM players WHERE nick='Stelisevil'),
5,
- (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
't',
7626);
INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
2, 0,
(SELECT player FROM players WHERE nick='DufF'),
1,
- (SELECT song FROM songs WHERE lower(title)=lower('Orion.78 -civ mix-')),
+ (SELECT song FROM songs WHERE lower(title)=lower('ORION .78 (civilization mix)')),
't',
6586);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
2, 0,
(SELECT player FROM players WHERE nick='DufF'),
2,
- (SELECT song FROM songs WHERE lower(title)=lower('Door of Magic')),
+ (SELECT song FROM songs WHERE lower(title)=lower('Mahou no Tobira (Theme Of Space Maco) [Door of Magic]')),
't',
7450);
INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (