This should be my last entry on this... Using the SQL Playlist plugin I
created a "Advanced" Playlist with Genre="Rock" and Year <=1990 and Year
>=1970 to get a template. Then I edited the SQL to change the year
criteria to bpm values...
-- PlaylistName:TestBPM
-- PlaylistGroups:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join genre_track on
tracks.id=genre_track.track
join genres on
genres.id=genre_track.genre and
genres.name='Rock'
where
tracks.audio=1
and dynamicplaylist_history.id is null
and tracks.bpm >= 119
and tracks.bpm <= 121
group by tracks.id
order by random()
limit 10;
I knew that with the BPM test data I'd added to the database that there
were 3 38 Special songs that would match up. This works GREAT! You could
easily add criteria to get further limits like adding year stuff to the
end of the "where" section to limit this to the 60's Rock (for those of
us that are old and have a bunch of the old 60's rock & roll).
and tracks.year >= 1960
and tracks.year <= 1969
Hopefully some of you may find all this info useful, Enjoy.
2 Duets - 1 for upstairs and 1 for downstairs
Rock Solid with LMS 7.7.3 and WHS 2011
------------------------------------------------------------------------
w3wilkes's Profile: http://forums.slimdevices.com/member.php?userid=22973
View this thread: http://forums.slimdevices.com/showthread.php?t=99852
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
