in reply to my own thread: http://amarok.kde.org/forum/index.php/t ... 051.0.html
(i'm dipping in to dev stuff to fix it )


I'm up to this so far:

~/.kde/share/apps/amarok/smartplaylistbrowser_save.xml

Code: Select all

  <sqlquery>SELECT tags.title, COUNT( tags.title ) AS NumOccurrences FROM tags LEFT JOIN year ON year.id = tags.year LEFT JOIN genre ON genre.id = tags.genre LEFT JOIN artist ON artist.id = tags.artist LEFT JOIN album ON album.id = tags.album LEFT JOIN composer ON composer.id = tags.composer WHERE ( ( tags.title LIKE '%%' ESCAPE '/' ) ) GROUP BY tags.album HAVING ( COUNT(tags.title) > 1 );</sqlquery>

the SQL query works great, and it populates the playlist, HOWEVER; it totally messes up because the query is returning not only the title of the tracks, but a play counter (select count), and amarok seems to simply be taking the data out in order, as opposed to by column name.

(For example; some tracks in the playlist come back with the playcount as the artist, title, etc )