biblioitems.lccn,
biblioitems.url,
items.notforloan as itemnotforloan,
- itemtypes.description
+ itemtypes.description,
+ branchurl
FROM items
LEFT JOIN branches ON items.homebranch = branches.branchcode
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber