mherger wrote:
> What if you browsed the FAVS library using the existing browse modes?
If by existing browse mode you mean the 2 options (artist or albums
menu) that the ExtendedBrowseModes plugin provides, I've tried that with
the artist menu for FAVS but it shows the same empty entries as the menu
I've created with the plugin. :confused: (and with >10 custom menus on
the top level it gets quite cluttered. That and the missing genre option
made me dive into this whole plugin business in the first place.)
So I've already posted the code for the problem menus above. But just in
case the sql query for my TOP_RATED (changed the name from FAVS) virtual
library is wrong, I'm adding it below:
Code:
--------------------
id => 'TOP_RATED',
name => 'Rated - Top Rated',
sql => qq{
INSERT OR IGNORE INTO library_track (library, track)
SELECT '%s', tracks.id
FROM tracks
LEFT JOIN comments comments ON comments.track =
tracks.id
WHERE
(comments.value LIKE
'%%favs3%%' OR
comments.value LIKE '%%favs4%%'
OR
comments.value LIKE '%%favs5%%')
AND tracks.audio = 1
and not exists(select * FROM comments
where
comments.track=tracks.id AND
comments.value LIKE
'%%Christmas%%'
)
AND not exists(select * from
genre_track,genres
where
genre_track.track=tracks.id and
genre_track.genre=genres.id and
genres.name in
('Classical','Opera'))
GROUP by tracks.id
},
--------------------
I've hit a dead end here. No idea why these false empty entries show up
(except in CustomBrowse).
Thanks.
------------------------------------------------------------------------
afriend's Profile: http://forums.slimdevices.com/member.php?userid=39306
View this thread: http://forums.slimdevices.com/showthread.php?t=109334
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
