Hi Calypso,
That is true, I don't take the associated artists into consideration. For that I would need to put all that information into the database, which is an enormous task. There are only 24 hours in a day here as well, so there is no time for that. I do make sure though that the artist names are as consequent as possible though, so no 'Simon and Garfunkel' and 'Simon & Garfunkel' and 'Paul Simon and Art Garfunkel' and whatever variation on this in my database: only one combination. That is doable. It works for me this way. Of course, it is still possible to have the Beatles. Wings and Paul McCartney back to back, but I really don't mind that. With around 30000 tracks that risk is rather small. My biggest concern was to select the tracks that were least played. Over time I tried several solutions in this query, this one (the last 'and' in the query) does the job the best. I'm always open for better options though...
Adrian