I built this SQL Select that selects songs in the Tracks table of the
library database. I'd like to use this to build .m3u relative directory
playlists. I tried using Erland's Playlist generator plugin, but it
causes the current 7.9.1 LMS on Win10 to hang. I had to use Task manager
to kill LMS after I tried to use that plugin. Does anybody have a shell
I could plug this Select into to generate a playlist?
select tracks.url from tracks
join genre_track on
tracks.id=genre_track.track
join genres on
genre_track.genre=genres.id
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and dynamicplaylist_history.id is null
and genres.name in ('Pop/Rock','Rock','Rock & Roll','Pop')
and (tracks.bpm > 127 and tracks.bpm < 130)
Main system - Rock Solid with LMS 7.9 on WHS 2011 - 2 Duets and
Squeeseslave
Portable system - Rock solid with LMS 7.9 on Win10 Pro - 1 Duet and
Squeezeslave
------------------------------------------------------------------------
w3wilkes's Profile: http://forums.slimdevices.com/member.php?userid=22973
View this thread: http://forums.slimdevices.com/showthread.php?t=108436
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
