Jim Wrote: > > Code: -------------------- > > > SELECT LEFT(title, 255), > playcount, > FROM_UNIXTIME(lastplayed) > FROM tracks WHERE FROM_UNIXTIME(lastplayed) > '2005-11-01'; > -------------------- > > > > Of course, would be better to join to artists too but I'm lazy today. > And the > '2005-11-01' doesn't have to be a date, can be an exact > time: > > WHERE FROM_UNIXTIME(lastplayed) > '2005-11-26-09:05:33';
Thanks for the tips. I will try this first as it is what I'm after. But I will problable also look at the SlimScrobber plugin to see if a can make a small logger plugin. Tom -- tomsi42 SqueezeBox2, Rotel RC-1070/RB-1070, DynaBel Exact. I can get used to this ;) ------------------------------------------------------------------------ tomsi42's Profile: http://forums.slimdevices.com/member.php?userid=2477 View this thread: http://forums.slimdevices.com/showthread.php?t=18520 _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
