X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fvarious-11.sql;h=1553bc526b39ee31588a19bd8d47633b78db0ec8;hp=0a3a85fddf1e4810d219c5153c44f7fa550bbe50;hb=9a91e199a828e7e317335bb4121761950f31ccef;hpb=f77426158d4ef1b9b4a344de2d6cf6ef0c398734 diff --git a/sql/various/various-11.sql b/sql/various/various-11.sql index 0a3a85f..1553bc5 100644 --- 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 ❤ 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 ( @@ -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 ❤ SHINE')), + (SELECT song FROM songs WHERE lower(title)=lower('LOVE ❤ 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☆')), + (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')), 't', 6600); INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (