Hi,
I want my sql playlist to play music from my album by order of name NOT
random. Can anybody customize this for me.
here's the code:
-- PlaylistName:The Drunkard\'s Walk
-- 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='The Drunkard\'s Walk'
left join track_statistics on
tracks.url=track_statistics.url
where
tracks.audio=1
and dynamicplaylist_history.id is null
and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-7257600)
group by tracks.id
order by rand()
limit 10;
Thanks a bunch!!
--
geepeeone
------------------------------------------------------------------------
geepeeone's Profile: http://forums.slimdevices.com/member.php?userid=46504
View this thread: http://forums.slimdevices.com/showthread.php?t=87612
_______________________________________________
Radio mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/radio
