Sure. This was just me trying to figure it out. Eventually I would like
to do one for slow songs with a BPM under a certain amount and one for
fast songs with the BPM over a certain a amount.
Code:
--------------------
-- PlaylistName:BPM
-- PlaylistGroups:
-- PlaylistParameter1:custom:Select BPM:select
customscan_track_attributes.value,customscan_track_attributes.value from
customscan_track_attributes where
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='BPM' group by
customscan_track_attributes.value order by customscan_track_attributes.value
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join customscan_track_attributes on
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='BPM' and
customscan_track_attributes.value=''PlaylistParameter1''
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by rand()
limit 25;
--------------------
--
MeSue
Sue
------------------------------------------------------------------------
MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985
View this thread: http://forums.slimdevices.com/showthread.php?t=47234
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
