aboutsummaryrefslogtreecommitdiffstats
path: root/binding/media-manager.h
diff options
context:
space:
mode:
authorTasuku Suzuki <tasuku.suzuki@qt.io>2017-12-22 11:43:45 +0900
committerTasuku Suzuki <tasuku.suzuki@qt.io>2017-12-22 11:43:45 +0900
commit68314a658d919a06b270340f06c162f56147c7b1 (patch)
tree8062be1c3bc68f7f569da5ae509bba2a2a5d0cda /binding/media-manager.h
parent91126397febe969a6ee94f9baff6337568ee7c65 (diff)
binding: mediascanner: fix media_result for video
media_result didn't work with video because of the SQL for video is not perfect. Change-Id: If0f8b9d104f4b3f293c6457c285035f55132f748 Bug-AGL: SPEC-1169 Signed-off-by: Tasuku Suzuki <tasuku.suzuki@qt.io>
Diffstat (limited to 'binding/media-manager.h')
-rw-r--r--binding/media-manager.h3
1 files changed, 2 insertions, 1 deletions
diff --git a/binding/media-manager.h b/binding/media-manager.h
index 37621b0..2190a16 100644
--- a/binding/media-manager.h
+++ b/binding/media-manager.h
@@ -91,7 +91,8 @@ void DebugTraceSendMsg(int level, gchar* message);
#define VIDEO_SQL_QUERY \
"SELECT files.path, videos.title, videos.artist, \"\", \"\", " \
- "videos.length FROM files LEFT JOIN videos " \
+ "videos.length FROM files " \
+ "INNER JOIN videos ON videos.id = files.id " \
"WHERE files.path LIKE '%s/%%' " \
"ORDER BY " \
"videos.title"