X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-11.sql;h=0a3a85fddf1e4810d219c5153c44f7fa550bbe50;hp=83ffa12101d5c0c6d5c2c23aeb7ee039ab48908d;hb=f77426158d4ef1b9b4a344de2d6cf6ef0c398734;hpb=e5f210a4894f541c6b2d2b9cdddea887ebea1fb3

diff --git a/sql/various/various-11.sql b/sql/various/various-11.sql
index 83ffa12..0a3a85f 100644
--- a/sql/various/various-11.sql
+++ b/sql/various/various-11.sql
@@ -6,9 +6,69 @@ INSERT INTO tournaments
     (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' )),
@@ -130,7 +190,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -138,7 +198,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -168,7 +228,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -176,7 +236,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -190,7 +250,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -288,7 +348,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -378,7 +438,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -386,7 +446,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -461,7 +521,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -475,7 +535,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -505,7 +565,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -581,7 +641,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -603,7 +663,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -625,7 +685,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    1, 2,
    (SELECT player FROM players WHERE nick='Oliyzia'),
    0,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    't',
    6600);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -633,7 +693,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -860,7 +920,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -868,7 +928,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -890,7 +950,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -898,7 +958,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (