This is doing the trick for me:
Code:
--------------------
-- PlaylistName:Harmonic Mix
-- PlaylistGroups:
-- PlaylistParameter1:custom:Select Key:select
customscan_track_attributes.value,customscan_track_attributes.value from
customscan_track_attributes where
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='INITIALKEY' group by
customscan_track_attributes.value order by customscan_track_attributes.value
-- PlaylistParameter2:custom:Select BPM:select
5*floor(customscan_track_attributes.value/5),5*floor(customscan_track_attributes.value/5)
from customscan_track_attributes where
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='BPM' group by
5*floor(customscan_track_attributes.value/5) order by
cast(customscan_track_attributes.value as decimal)
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join customscan_track_attributes as songkey on
tracks.id=songkey.track and songkey.module='customtag' and
songkey.attr='INITIALKEY' and songkey.value=''PlaylistParameter1''
join customscan_track_attributes as bpmrange on
tracks.id=bpmrange.track and bpmrange.module='customtag' and
bpmrange.attr='BPM' and bpmrange.value>=''PlaylistParameter2''-2.5 and
bpmrange.value<=''PlaylistParameter2''+2.5
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by rand()
limit 25;
--------------------
After selecting a BPM (shown in increments of 5) the BPM range is set
to include all songs with a BPM +/- 2.5 from the selected value.
I am not yet familiar with MusicIP. I recently purchased my Squeezebox
setup and am still familiarizing myself with the immense load of
options. By the sounds of it MusicIP is the next realm to explore...
--
junglejoint
------------------------------------------------------------------------
junglejoint's Profile: http://forums.slimdevices.com/member.php?userid=26349
View this thread: http://forums.slimdevices.com/showthread.php?t=47234
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
