From f991cb3bb760ab0901f8f42b8c4d6fea365d6709 Mon Sep 17 00:00:00 2001 From: MilhouseVH Date: Wed, 3 Feb 2016 10:29:58 +0000 Subject: [mysql]: Fix limited songs query after #9005 --- xbmc/music/MusicDatabase.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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()); -- cgit v1.2.3