diff options
| -rw-r--r-- | xbmc/music/MusicDatabase.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/xbmc/music/MusicDatabase.cpp b/xbmc/music/MusicDatabase.cpp index 2dce24847b..fe9e3d309e 100644 --- a/xbmc/music/MusicDatabase.cpp +++ b/xbmc/music/MusicDatabase.cpp @@ -3836,7 +3836,7 @@ bool CMusicDatabase::GetSongsFullByWhere(const std::string &baseDir, const Filte strSQL += strSQLExtra; else //Apply where clause and limits to songview, then join as mutiple records in result set per song - strSQL += " WHERE songview.idsong in (SELECT idsong FROM songview " + strSQLExtra + ")"; + strSQL += " WHERE songview.idsong IN (SELECT idsong FROM (SELECT idsong FROM songview " + strSQLExtra + ") as temp)"; } CLog::Log(LOGDEBUG, "%s query = %s", __FUNCTION__, strSQL.c_str()); |