SELECT artistview.* FROM artistview  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 path.strPath LIKE 'smb://MEDIASERVER/Music/Adults/%')))) OR (( (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 path.strPath LIKE 'smb://MEDIASERVER/Music/Shared/%'))))) AND (EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist))) AND (artistview.strArtist != '')