If it helps this is my SQL statement to extract the album listing sorted in the stanbard LMS way
select contributors.name, albums.title, albums.year from albums left join contributors where albums.contributor = contributors.id order by contributors.namesort ASC, albums.year ASC This list albums in artist order with "The Allman Brothers" shown as the artist in proper case but under A rather than T the secondary sort is the year ie. The Allman Brothers Live at The Filmore 1971 The Allman Brothers Brothers & Sisters 1973 *Vortexbox LMS 7.8 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B&W P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes ------------------------------------------------------------------------ d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss