Followed your advice, DJanGo ;-)
Not sure if I´m on the right path but I installed the "Dynamic
Playlists"- as well as the "SQL Playlist" plugin and created a new
playlist.
I chose several genres, didn´t activate only lossless (because I´d like
to have the MP3 files included in this playlist. Am I right here?!?) and
chose customize SQL.
Hence my SQL script looks like:
-- PlaylistName:Advanced
-- 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
('80s','Alternative','Dance','Disco','Electronic','Funk','Hard
Rock','Hip-Hop','Indie','Lounge','NDW','Nu
Disco','OST','Pop','Punk','R&B','Rap','Reggae','Rock','Soul','Trip-Hop')
group by tracks.id
order by random()
limit 10;
Now I´m stuck a little bit since I don´t have any SQL experience at all.
>From this post 'here'
(http://forums.slimdevices.com/showthread.php?81483-Dynamic-Playlists-Based-on-File-Resolution&p=572298&viewfull=1#post572298)
I assume something needs to be added to clearly indicates that only
files <=96000 will be used within my playlist.
Not sure..should I add the following:
-- PlaylistGroups: *Sample Rates*
select tracks.url from tracks
......
where
audio=1 *and samplerate<=96000
*Any hint would be appreciated?
Thanks in advance.
------------------------------------------------------------------------
marflao's Profile: http://forums.slimdevices.com/member.php?userid=57334
View this thread: http://forums.slimdevices.com/showthread.php?t=108839
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
