[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 145891] dynamic playlists based on smart playlists don't work
From:       Dominik Karall <dominik.karall () gmx ! net>
Date:       2007-06-02 8:34:10
Message-ID: 20070602083410.17675.qmail () ktown ! kde ! org
[Download RAW message or body]

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
         
http://bugs.kde.org/show_bug.cgi?id=145891         




------- Additional Comments From dominik.karall gmx net  2007-06-02 10:34 -------
Ok, I checked the code again and I think, that the following SQL statement will be \
created by the code

SELECT tags.url, tags.deviceid FROM ... ORDER BY playcount DESC LIMIT 5 OFFSET 195

and my Top 200 playlist may look like

SELECT ... FROM ... ORDER BY playcount DESC LIMIT 200 OFFSET 0

but the created one couldn't be correct, otherwise I would get the last 5 tracks from \
my Top 200, but that's not the case. Anyway, why do you select only songCount songs? \
I would select all 200 songs and select the 5 songs by random. So there wouldn't be \
any need for ORDER, LIMIT and OFFSET changes.


[prev in list] [next in list] [prev in thread] [next in thread]