bernt wrote: > Another one. I want tracks from a specific album mixed with tracks from > a specific genre. > > I'm trying to learn SQL but I'm a slow learner, sorry! > > > Code: -------------------- > > -- PlaylistName:Random from mixer > -- PlaylistGroups: > select tracks.url from tracks > left join dynamicplaylist_history on > tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='PlaylistPlayer' > join albums on > tracks.album=albums.id and > albums.title='Absolute Music 88' > > join genre_track on > tracks.id=genre_track.track > join genres on > genres.id=genre_track.genre and > genres.name='Hits' > > > where > tracks.audio=1 > and dynamicplaylist_history.id is null > group by tracks.id > order by random() > limit 10; > -------------------- > >
I've started a '*separate thread dedicated to helping users with their custom dynamic playlists*' (https://forums.slimdevices.com/showthread.php?115501-Dynamic-Playlists-3-get-help-with-your-custom-playlists). *Plugin repositories:* 'Ratings Light' (https://github.com/AF-1/lms-ratingslight) 'Visual Statistics' (https://github.com/AF-1/lms-visualstatistics) 'Use Comment Tag Info' (https://github.com/AF-1/lms-usecommenttaginfo) 'Dynamic Playlists 3 FAQ' (https://github.com/AF-1/lms-dynamicplaylists#faq) 'Custom Skip 3 FAQ' (https://github.com/AF-1/lms-customskip#faq) ------------------------------------------------------------------------ afriend's Profile: http://forums.slimdevices.com/member.php?userid=39306 View this thread: http://forums.slimdevices.com/showthread.php?t=115073
_______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
