- $sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems, items
- where biblioitems.itemtype=itemtypes.itemtype
- and items.biblionumber=biblioitems.biblionumber
- and items.holdingbranch=?
- group by biblioitems.itemtype");
+ if (C4::Context->preference('item-level_itypes')) {
+ $sth = $dbh->prepare("
+ SELECT description, items.itype as itemtype, COUNT(*) AS total
+ FROM itemtypes,items
+ WHERE items.itype=itemtypes.itemtype
+ AND items.holdingbranch=?
+ GROUP BY items.itype
+ ORDER BY itemtypes.description");
+
+ }
+ else {
+ $sth = $dbh->prepare("
+ SELECT description, biblioitems.itemtype, COUNT(*) AS total
+ FROM itemtypes, biblioitems, items
+ WHERE biblioitems.itemtype=itemtypes.itemtype
+ AND items.biblioitemnumber=biblioitems.biblioitemnumber
+ AND items.holdingbranch=?
+ GROUP BY biblioitems.itemtype
+ ORDER BY itemtypes.description");
+ }