Artists 50 variousartist Various Artists sql select contributors.id,contributors.name from contributors where contributors.name='Various Artists' and {property:server:variousArtistAutoIdentification}=1 group by contributors.id album Songs album album sqlbyyear byyear Sort by year albumconcat number select albums.id,'' from albums where albums.compilation = 1 group by albums.id order by albums.titlesort asc,albums.disc asc bytitle Sort by title alpha select albums.id,albums.title from albums where albums.compilation = 1 group by albums.id order by {orderby} track track track all sql select tracks.id,tracks.title from tracks,albums where tracks.audio=1 and tracks.album={album} group by tracks.id order by tracks.disc,tracks.tracknum asc,tracks.titlesort asc trackdetails trackdetails track|0 artist Albums artist sql alpha select contributors.id,contributors.name,substr(contributors.namesort,1,1) from contributors,contributor_album,albums where contributor_album.contributor=contributors.id and contributor_album.album=albums.id and contributor_album.role in (1,5) and ( albums.compilation is null or albums.compilation=0 or {property:server:variousArtistAutoIdentification}=0 ) group by contributors.id order by contributors.namesort asc album Songs album album sqlbyyear byyear Sort by year albumconcat number select albums.id,'' from contributor_album,albums where albums.id=contributor_album.album and contributor_album.contributor={artist} and contributor_album.role in (1,5) group by albums.id order by albums.compilation asc,albums.year asc,albums.titlesort asc,albums.disc asc bytitle Sort by title alpha ^(.*)\s\((.*)\)$ select albums.id,albums.title,substr(albums.titlesort,1,1) from contributor_album,albums where albums.id=contributor_album.album and contributor_album.contributor={artist} and contributor_album.role in (1,5) group by albums.id order by {orderby} track track track all sql select tracks.id,tracks.title from tracks,contributor_track,albums where tracks.audio=1 and contributor_track.track=tracks.id and tracks.album={album} and contributor_track.contributor={artist} and contributor_track.role in (1,5) group by tracks.id order by tracks.disc,tracks.tracknum asc,tracks.titlesort asc trackdetails trackdetails track|0