[Koha] Available Items per branch

[Mayank Srivastava]

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
homebranch;


I need available items as well.

Thanks in advance.!


Regards
-- 
*Mayank Srivastava*
New Delhi