A few minutes later…
SELECT path
FROM formatedlog
WHERE play_time > '13:00:00' AND play_time < '17:00:00'
GROUP BY path
ORDER BY count(*) DESC, play_date DESC, play_time DESC
LIMIT 10;
Will give you a top-ten list of played songs in the time frame stated.
Now I only have to take the shell-script a few posts earlier, modify it so that it will insert into the log-table.
Then cron it every xx minutes.
Then… once a day create a few playlists with queries like this, rescan server and Im good to go.
“I only have to…” 🙂