w3wilkes wrote:
> Does anybody have a "SQLite Expert Personal" shell I could plug this
> Select into to generate a playlist?
>
> 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 ('Pop/Rock','Rock','Rock & Roll','Pop')
> and (tracks.bpm > 127 and tracks.bpm < 130)*;*
Hi just added that plugin and other than adding a ; at the end - its
running fine ..
------------------------------------------------------------------------
DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=108436
_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss
