afriend wrote:
> With *year* you'll have to choose a year. Not optional.
>
> >
Code:
--------------------
> > -- PlaylistName:Songs - multiple genres & year (from selected
playlist)
> -- PlaylistGroups:
> -- PlaylistMenuListType:contextmenu
> -- PlaylistParameter1:playlist:Select playlist:
> -- PlaylistParameter2:multiplegenres:Select genres:
> -- PlaylistParameter3:year:Select year:
> select distinct playlist_track.track from playlist_track
> join tracks on
> tracks.url = playlist_track.track
> join genre_track on
> genre_track.track = tracks.id and genre_track.genre in
('PlaylistParameter2')
> left join dynamicplaylist_history on
> dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
> where
> playlist_track.playlist='PlaylistParameter1'
> and tracks.year='PlaylistParameter3'
> and tracks.audio = 1
> and tracks.secs >= 'PlaylistTrackMinDuration'
> and dynamicplaylist_history.id is null
> group by playlist_track.track
> order by random()
> limit 'PlaylistLimit';
>
--------------------
> >
>
> With *decades* it's optional (select -any-).
>
> >
Code:
--------------------
> > -- PlaylistName:Songs - multiple genres & decade (from selected
playlist)
> -- PlaylistGroups:
> -- PlaylistMenuListType:contextmenu
> -- PlaylistParameter1:playlist:Select playlist:
> -- PlaylistParameter2:multiplegenres:Select genres:
> -- PlaylistParameter3:customdecadechained:Select decade:select
cast(((ifnull(tracks.year,0)/10)*10) as int),case when tracks.year>0 then
cast(((tracks.year/10)*10) as int)||'s' else 'Unknown' end from tracks where
tracks.audio=1 group by cast(((ifnull(tracks.year,0)/10)*10) as int) order by
tracks.year desc
> select distinct playlist_track.track from playlist_track
> join tracks on
> tracks.url = playlist_track.track
> join genre_track on
> genre_track.track = tracks.id and genre_track.genre in
('PlaylistParameter2')
> left join dynamicplaylist_history on
> dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
> where
> playlist_track.playlist='PlaylistParameter1'
> and tracks.year='PlaylistParameter3'
> and tracks.audio = 1
> and tracks.secs >= 'PlaylistTrackMinDuration'
> and dynamicplaylist_history.id is null
> and
> case
> when 'PlaylistParameter3'!=999999999 then
tracks.year>='PlaylistParameter3' and tracks.year<('PlaylistParameter3'+10)
> else 1
> end
> group by playlist_track.track
> order by random()
> limit 'PlaylistLimit';
>
--------------------
> >
>
> And without year/decade:
>
> >
Code:
--------------------
> > -- PlaylistName:Songs - multiple genres (from selected playlist)
> -- PlaylistGroups:
> -- PlaylistMenuListType:contextmenu
> -- PlaylistParameter1:playlist:Select playlist:
> -- PlaylistParameter2:multiplegenres:Select genres:
> select distinct playlist_track.track from playlist_track
> join tracks on
> tracks.url = playlist_track.track
> join genre_track on
> genre_track.track = tracks.id and genre_track.genre in
('PlaylistParameter2')
> left join dynamicplaylist_history on
> dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
> where
> playlist_track.playlist='PlaylistParameter1'
> and tracks.audio = 1
> and tracks.secs >= 'PlaylistTrackMinDuration'
> and dynamicplaylist_history.id is null
> group by playlist_track.track
> order by random()
> limit 'PlaylistLimit';
>
--------------------
> >
You make all this seem easy!
------------------------------------------------------------------------
nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092
View this thread: http://forums.slimdevices.com/showthread.php?t=115501
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
