[Koha] INVENTORY SQL

[muiru james]

Hello team,

Im trying to create a sql query that will return a count of books that will
have a datelastseen from a date picker and combine/add all books on loan
for the particular itemtype.

I have 2 different itemtypes and would like a count for each itemtype to
include those with a datelastseen and all those onloan for the itemtype.

Any ideas/help will really be appreciated.

Warm regards

James