SQLite query to get 3 songs from each album order by LastTim

[Thanasis]

I am directing this question to the MM developers as I don't expect anybody else here would bother,

I am looking for that SQLite query that will give me 3 songs from each album order by LastTimePlayed.....

The query goes like this:

Code: Select all

SELECT Songs.* FROM Songs, Albums WHERE Albums.ID=Songs.AlbumID ORDER BY Songs.LastTimePlayed LIMIT 3

But I don't know what to add to make the above query return not 3 songs in total but 3 songs from every single Album that is captured by the Query (any query)...

Thanks in advance.
(Sorry for being impatient and always asking, but I am making some very beautiful plug-ins. )