Hi, How does Custom Browse, and in particular the Genre/ Sub Genre menu, deal with tracks with more than two genre tags? I tag my classical tracks using multiple values in the GENRE tag:
Classical, plus one of: Baroque Romantic 20th Century ... plus one of: symphony string quartet concerto ... An individual track might be tagged "GENRE=classical; Romantic; Symphony", while another might be "GENRE=classical; 20th Century; Symphony". When I use the Genre/ Sub Genre menu and select the classical genre, I get a list of sub-genres that inclues Baroque, Romantic, 20th Centry, etc. and symphony, string quartet, etc. Selecting Romantic presents me with a list of sub-genres consisting of symphony, string quartet, concerto, etc., as well as a complete list of artists. Naively, I thought that drilling down into symphony would list all tracks with the romantic and the symphony tags. Instead I get an error: Error: Running: select genres.id,concat(genres.name,'/'),substr(genres.namesort,1,1) from genres,genre_track,tracks where tracks.id = genre_track.track and genres.id = genre_track.genre and genres.id != 11 and genres.id != 47 and genres.id != 14 and exists(select * from genre_track where genre_track.track=tracks.id and genre_track.genre=11) and exists(select * from genre_track where genre_track.track=tracks.id and genre_track.genre=47) exists(select * from genre_track where genre_track.track=tracks.id and genre_track.genre=14) group by genres.id order by genres.namesort asc got error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'exists(select * from genre_track where genre_track.track=trac' at line 17 Interestingly, it works they way I expect using the remote with my squeezebox. -Steve -- wnshall ------------------------------------------------------------------------ wnshall's Profile: http://forums.slimdevices.com/member.php?userid=5886 View this thread: http://forums.slimdevices.com/showthread.php?t=37209 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
