diff options
| author | MilhouseVH <milhouseVH.github@nmacleod.com> | 2016-02-03 10:29:58 +0000 |
|---|---|---|
| committer | MilhouseVH <milhouseVH.github@nmacleod.com> | 2016-02-03 10:29:58 +0000 |
| commit | f991cb3bb760ab0901f8f42b8c4d6fea365d6709 (patch) | |
| tree | e1fca5521dcf39e31a716e290e87c95526b21cd5 | |
| parent | 34d1e4912be7c473ebeaf7781b9a290c12fcb43e (diff) | |
[mysql]: Fix limited songs query after #9005
| -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()); |