[Koha] Available Items per branch

Mayank Srivastava mayanksri1989 at gmail.com
Fri Jan 10 22:24:14 NZDT 2014

Hi Everyone,

I need to fetch the *total items* and *total available items*(not
withdrawn/lost/on loan etc) per *biblionumber*.
Is there a way to do this using a single query?

The query which I am using at this point is giving me name of the
homebranch and total items.

select homebranch,count(*) from items where biblionumber=1234 group by

I need available items as well.

Thanks in advance.!

*Mayank Srivastava*
New Delhi

More information about the Koha mailing list