X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fshorttitles.sql;h=41d39d61722d37845e625b5ca81a8fc3fd61d47c;hp=9dd1e232337f9ffe223338d75a8ce5a482a9d0d8;hb=4fce9b9798f93820661191b3bbc049c8d849f0fc;hpb=013a49ad36808700c2c3a12445c7c713a1b0b8b8 diff --git a/sql/shorttitles.sql b/sql/shorttitles.sql index 9dd1e23..41d39d6 100644 --- a/sql/shorttitles.sql +++ b/sql/shorttitles.sql @@ -12,4 +12,11 @@ INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title) INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='afronova primeval' ), 'Primeval'); INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='jam jam reggae (am swing mix)' ), 'Jam jam'); INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='my summer love' ), 'MSL'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='never gonna make (factory team mix)' ), 'Never Gonna Make'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='www.blonde girl (momo mix)' ), 'blonde girl'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='aaron\'s party (come get it)' ), 'Aaron\'s Party'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='end of the century' ), 'EotC'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='the centre of the heart (stonebridge club mix)' ), 'Centre of the Heart'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='luv to me (amd mix)' ), 'Luv to Me'); +INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='b4u (b4 za beat mix)' ), 'B4U (mix)'); commit;