I too have all my music tagged with BPM. The only way I've found to use
it is with Erlands old SQLPlaylist plugin and then edit the SQL to add
BPM to selection criteria. One note on BPM in the DB is that it is an
integer value so it must be a whole number with no decimals. I use
TuneXplorer to set BPM and it also does the Key. Here's an example where
I pull all tracks in the set genres that are 126 BPM;
-- PlaylistName:BPM126t
-- PlaylistGroups:
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','Folk','Folk/Rock')
and tracks.bpm = 126
group by tracks.id
order by random();
Main system - Rock Solid with LMS 8.2.0 on WHS 2011 - 2 Duets and
Squeeseslave
Cabin system - Rock solid with LMS 8.2.0 on Win10 Pro - 1 RPi 3 Model
B/Hifiberry DAC+ Pro/PiCorePlayer and Squeezeslave
Squeezebox Boom - "At Large" player around both home and cabin
Headphones and car - Android phone/Bluetooth w/full library on MicroSD
card - PowerAmp music player app (similar to Material Skin)
------------------------------------------------------------------------
w3wilkes's Profile: http://forums.slimdevices.com/member.php?userid=22973
View this thread: http://forums.slimdevices.com/showthread.php?t=116143
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
