AND holdingbranch IS NOT NULL
AND itemlost = 0
AND wthdrawn = 0
AND damaged = 0
AND items.onloan IS NULL
AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0)
AND itemnumber NOT IN (
-