Sync with --pgweb.

[ccbs] / sql / various / various-11.sql

diff --git a/sql/various/various-11.sql b/sql/various/various-11.sql
index 0a3a85fddf1e4810d219c5153c44f7fa550bbe50..1553bc526b39ee31588a19bd8d47633b78db0ec8 100644 (file)
--- a/sql/various/various-11.sql
+++ b/sql/various/various-11.sql
@@ -190,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 âÂ\9d¤ SHINE')),
+   (SELECT song FROM songs WHERE lower(title)=lower('LOVE â\9d¤ SHINE')),
    't',
    6653);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -236,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 âÂ\9d¤ SHINE')),
+   (SELECT song FROM songs WHERE lower(title)=lower('LOVE â\9d¤ SHINE')),
    't',
    6826);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
@@ -370,7 +370,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    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 (
@@ -685,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âÂ\98Â\86')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candyâ\98\86')),
    't',
    6600);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (