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

Reply via email to