Maybe the select suggested in the wiki SELECT items.price,items.replacementprice,biblio.title,biblio.author,items.itemcallnumber FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.itemcallnumber ASC could be enhanced using the cn_sort field, that cointains the sort form of itemcallnumber, changing the ORDER BY clause into ORDER BY items.cn_sort ASC Stefano

There is a report for a complete shelf list on the wiki - http://wiki.koha-community.org/wiki/SQL_Reports_Library#Complete_Shelf_list

You should be able to use that as a starting place to get what you're looking for.

Liz Rea