Thanks for the replies. I did a bit of digging around the schema as well in the meantime.
I devised the following query which is useful for listing which songs you have listened to recently. Unfortunately, slimserver only records lastPlayed on a per track basis... which means you can't get an exact listing of what you have been listening to. However, if you are happy to see a listing of the most recently played tracks (subtly different) then this will work: select from_unixtime(lastPlayed),t.title,a.title,c.name from tracks t, contributors c, contributor_track ct, albums a where t.playCount is not NULL and t.id = ct.track and ct.contributor = c.id and t.album = a.id order by t.lastPlayed desc; -- nico ------------------------------------------------------------------------ nico's Profile: http://forums.slimdevices.com/member.php?userid=672 View this thread: http://forums.slimdevices.com/showthread.php?t=21436 _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
