Teknojnky wrote:if changing djminrating to -1 does not help, then I am at a loss why it is not working for you.
Yup, this fixed it.
The block of code that constructs the SQL is clearly the culprit. In SQL, any comparison to NULL always returns FALSE. So no unrated music will ever be considered.
IMHO, this is the wrong approach (especially at this point in the code, where it's only serving as an optimization). Right now I'm working on building up my DB on a new computer with the new MM3. So I thought that using Last.FM to "discover" the most likely tracks in my collection would be a good way to bootstrap my ratings.
But if unrated songs are always excluded, then I can't discover new songs that I've never bothered listening to before. I think that getting suggestions from Last.FM ought to be a discovery tool, and this interferes.
(with all respect, since you did invest all the time in building this!)