PatLogan;525917 Wrote:
> but... I'd like to sort the items by genre. I tried to link the genre
> tables but did not succeed, if u can help...
> Cheers :)
> Pat
Try something like this:
Code:
--------------------
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join albums on
tracks.album=albums.id and
albums.title like 'BWV 988%' and albums.title not like '%Zenph%'
and (tracks.tracknum = 27)
join genre_track on
tracks.id=genre_track.track
join genres on
genres.id=genre_track.genre
where
tracks.audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by genres.namesort;
--------------------
You might also want to add a the following row after the
"PlaylistGroups" row if you like all tracks to be added immediately:
Code:
--------------------
-- PlaylistOptionUnlimited:1
--------------------
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=76244
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
