PasTim wrote:
> Could you post your SQL?
Hi Pastim,
Here is my SQL for playing works (The playcount test is because I only
want to choose from works that I have already played at least once).
Note that the second image I posted above shows that the SQL Playlist is
not truncated when I run it in "test" mode, only when I use Dynamic
Playlists to actually listen to it.
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
WHERE playcount > 0 GROUP BY tracks.album, customscan_track_attributes.value
ORDER BY random() limit 10 ;
SELECT tracks.url FROM
(SELECT rowid AS albumworks_id, album as albumworks_album, work, playcount
from albumworks)
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;
--------------------
------------------------------------------------------------------------
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
