PasTim wrote: > I don't get truncation with this SQL. I don't see why you should. > > What this SQL does is select 10 Works and lists them in a table. It > then plays all the tracks in each Work, however many there are. When > near the end of the playlist it selects another 10 Works (not tracks). > That's why there are two separate steps. If done in one SQL statement > you will get truncation. > > It may be that I have misunderstood your problem, but with this SQL (and > variations on it) I have sat for many hours playing tens of random > 'works' (some of which have 50 or more tracks) with no problem. It's > one of the tools I use the most. Thanks for the response, PasTim. Maybe I am missing something obvious. I use the following SQL, which works fine from "Test/Save & Play" in the SQL playlist menu.
Code: -------------------- -- PlaylistName:Random Played Works -- PlaylistGroups: DROP TABLE IF EXISTS albumworks; CREATE TEMPORARY TABLE IF NOT EXISTS albumworks AS SELECT tracks.album AS album, customscan_track_attributes.value as work, Ifnull(track_statistics.playcount, 0) as playcount FROM tracks JOIN multilibrary_track LEFT JOIN track_statistics JOIN customscan_track_attributes ON tracks.id = customscan_track_attributes.track AND tracks.url = track_statistics.url AND customscan_track_attributes.module = 'customtag' AND customscan_track_attributes.attr = 'WORK' AND tracks.id=multilibrary_track.track AND multilibrary_track.library=2 GROUP BY tracks.album, customscan_track_attributes.value ORDER BY random(); SELECT tracks.url FROM (SELECT rowid AS albumworks_id, album as albumworks_album, work, playcount from albumworks WHERE playcount > 0 limit 10) JOIN tracks JOIN customscan_track_attributes ON tracks.id = customscan_track_attributes.track AND customscan_track_attributes.module = 'customtag' AND customscan_track_attributes.attr = 'WORK' AND customscan_track_attributes.value = work AND tracks.album = albumworks_album ORDER BY albumworks_id, tracks.tracknum; -------------------- However, when I run it as a dynamic playlist (easily accessed from iPeng, etc.), it only plays the first 10 tracks and then gets one track at a time, disregarding any work in progress. 16691 Does that make sense? What should I do differently? +-------------------------------------------------------------------+ |Filename: works1.png | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=16691| +-------------------------------------------------------------------+ ------------------------------------------------------------------------ mps's Profile: http://forums.slimdevices.com/member.php?userid=36351 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