[Uatschitchun]

First, thx @the_other_guy , but I have to tell that your posts often are hard to understand

<path>musicdb://genres/?sourceid=5</path>  change sourceid to genreid
open genres add to favourites open C:\Users\*****\AppData\Roaming\Kodi\userdata\favourites.xml
<favourite name="Comedy">ActivateWindow(10502,&quot;musicdb://genres/4/&quot;,return)</favourite>

musicdb://genres/4
<?xml version='1.0' encoding='UTF-8'?>
<node type="folder">
    <label>test</label>
    <path>musicdb://genres/?genreid=4</path>
</node>

Yes, that would help show a specific genre, but I would like to have all genres for a specific path or source. A node like this:

Code:

<?xml version='1.0' encoding='UTF-8'?>
<node type="filter">
<label>Genre-test</label>
<content>artists</content>
<group>genres</group>
<rule field="path" operator="contains">
<value>/media/audioplay/</value></rule>
</node>

Takes 7 minutes and it results in a mostly empty genres not appearing on /media/audioplay/ ;(
Even running the query on the DB-host itself (MariaDB, core i5-8400, SSD) gives:

Code:

MariaDB [headlesstest-audio72]> SELECT genre.* FROM genre JOIN song_genre ON song_genre.idGenre = genre.idGenre JOIN songview ON songview.idSong = song_genre.idSong JOIN song_artist ON song_artist.idSong = songview.idSong JOIN artistview ON artistv
iew.idArtist = song_artist.idArtist WHERE ((( (EXISTS (SELECT DISTINCT song_artist.idArtist FROM song_artist JOIN song ON song.idSong = song_artist.idSong JOIN path ON song.idpath = path.idpath WHERE song_artist.idArtist = artistview.idArtist AND p
ath.strPath LIKE '%/media/audioplay/%'))))) AND (genre.strGenre != '') GROUP BY genre.idGenre;
....
308 rows in set (7 min 33.934 sec)