summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJan-Simon Moeller <jsmoeller@linuxfoundation.org>2018-01-23 13:49:47 +0000
committerGerrit Code Review <gerrit@automotivelinux.org>2018-01-23 13:49:47 +0000
commit7eb941f8b3734ea3d56b83af2a4b4e97f40dde23 (patch)
treed968758e79f592b786b83f257adbd011afb70bc7
parenta9a6f1c0d3a39a12709ab19bb4d2c77400fea10d (diff)
parentc726ed8c7e60946812ebe831ddbf6c549b8fa397 (diff)
Merge "binding: mediascanner: fix media_result for video" into eeleel_5.0.3eel_5.0.2eel_5.0.1eel/5.0.3eel/5.0.2eel/5.0.15.0.35.0.25.0.1
-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 7f204fe..200b43d 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"