Thanks for your help, I appreciate it. Tested your query and it gave this error.
Error: no such column: albums.id Had a look at 'this' (http://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure#Get_albums_in_the_database) page and changed select tracks.url from tracks to select albums.* from albums, tracks. It did not show any error but no data either. Code: -------------------- -- PlaylistName:Test -- PlaylistGroups: select albums.* from albums, tracks left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='PlaylistPlayer' where tracks.audio=1 and tracks.album = albums.id and albums.title like '%Hits%' and dynamicplaylist_history.id is null group by tracks.id order by random() limit 10; -------------------- SB Touch to Yamaha A-S501, Boston Acoustics A26. SB 3 to Audio Pro T3. SB BOOM SB Radio ReadyNAS 202 iPeng ------------------------------------------------------------------------ bernt's Profile: http://forums.slimdevices.com/member.php?userid=1342 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins