In my app New Playlist Manager, I am developing "Smart Playlist" functionality ahainst the Poweramp Media database instead of the Android Media database.
Main reason for doing this is that Android does not offer the ratings tags whereas Poweramp does. However I run into the same frsutrating issue when trying to query for Genre. Both Poweramp and Android appear not to adhere to relational database design principles as I am unable to return "genre" within the same query. The table folder_files holds foreign keys to album, artist, composer referring to data held in other tables. Surprisi