[tracker] NB#153335: List albums with tracker-search -a with no title or length set

[Philip Van Hoof <pvanhoof src gnome org>]

commit 43ba786187a30108ce0bc5f0826b60233ed02b18
Author: Philip Van Hoof <philip codeminded be>
Date:   Fri Jan 15 14:22:53 2010 +0100

    NB#153335: List albums with tracker-search -a with no title or length set

 src/tracker-utils/tracker-search.c |   20 ++++++++------------
 1 files changed, 8 insertions(+), 12 deletions(-)
---
diff --git a/src/tracker-utils/tracker-search.c b/src/tracker-utils/tracker-search.c
index fa9ffcd..21f1bc3 100644
--- a/src/tracker-utils/tracker-search.c
+++ b/src/tracker-utils/tracker-search.c
@@ -518,14 +518,12 @@ get_music_albums (TrackerClient *client,
 	fts = get_fts_string (search_words, use_or_operator);
 
 	if (fts) {
-		query = g_strdup_printf ("SELECT ?album ?title COUNT(?song) "
+		query = g_strdup_printf ("SELECT ?album nie:title (?title) COUNT(?song) "
 		                         "AS songs "
-		                         "SUM(?length) AS totallength "
+		                         "SUM(nmm:length (?length)) AS totallength "
 		                         "WHERE {"
-		                         "  ?album a nmm:MusicAlbum ;"
-		                         "  nie:title ?title ."
-		                         "  ?song nmm:musicAlbum ?album ;"
-		                         "  nmm:length ?length ."
+		                         "  ?album a nmm:MusicAlbum ."
+		                         "  ?song nmm:musicAlbum ?album ."
 		                         "  ?album fts:match \"%s\" "
 		                         "} "
 		                         "GROUP BY ?album "
@@ -535,14 +533,12 @@ get_music_albums (TrackerClient *client,
 		                         search_offset,
 		                         search_limit);
 	} else {
-		query = g_strdup_printf ("SELECT ?album ?title COUNT(?song) "
+		query = g_strdup_printf ("SELECT ?album nie:title (?title) COUNT(?song) "
 		                         "AS songs "
-		                         "SUM(?length) AS totallength "
+		                         "SUM(nmm:length (?length)) AS totallength "
 		                         "WHERE {"
-		                         "  ?album a nmm:MusicAlbum ;"
-		                         "  nie:title ?title ."
-		                         "  ?song nmm:musicAlbum ?album ;"
-		                         "  nmm:length ?length ."
+		                         "  ?album a nmm:MusicAlbum ."
+		                         "  ?song nmm:musicAlbum ?album ." 
 		                         "} "
 		                         "GROUP BY ?album "
 		                         "OFFSET %d "