Kodi Community Forum

Full Version: How can I log into the XBMC Music Library Database?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I would like to query and count, for example, how many artists have less than 5 songs.

The idea afterwards would be to group all those artists into compilations
any ideas?
Please don't bump your own thread after only a couple hours. This is an international forum, people are on and replying to posts 24 hours a day.

The SQL statement that will show you which artists have less that 5 songs is:
Code:
select count(idSong) as numSongs, strArtists from songview group by strArtists having count(idSong) < 5 order by strArtists;

How you connect to the DB depends if you are using MySQL or SQLite.

I believe you would have to edit the tags on the files themselves for them to get flagged as compilations.
(2013-04-02, 22:33)Zernable Wrote: [ -> ]Please don't bump your own thread after only a couple hours. This is an international forum, people are on and replying to posts 24 hours a day.

The SQL statement that will show you which artists have less that 5 songs is:
Code:
select count(idSong) as numSongs, strArtists from songview group by strArtists having count(idSong) < 5 order by strArtists;

How you connect to the DB depends if you are using MySQL or SQLite.

I believe you would have to edit the tags on the files themselves for them to get flagged as compilations.

thanks Rofl