View | Details | Raw Unified | Return to bug 20274
Collapse All | Expand All

(-)a/reports/itemtypes.plugin (-3 / +2 lines)
Lines 53-59 sub calculate { Link Here
53
		}
53
		}
54
		else {
54
		else {
55
		$sth = $dbh->prepare("
55
		$sth = $dbh->prepare("
56
        SELECT itemtype, description, biblioitems.itemtype, COUNT(*) AS total
56
        SELECT biblioitems.itemtype, description, biblioitems.itemtype, COUNT(*) AS total
57
			FROM itemtypes, biblioitems, items 
57
			FROM itemtypes, biblioitems, items 
58
		WHERE biblioitems.itemtype=itemtypes.itemtype 
58
		WHERE biblioitems.itemtype=itemtypes.itemtype 
59
		AND items.biblioitemnumber=biblioitems.biblioitemnumber
59
		AND items.biblioitemnumber=biblioitems.biblioitemnumber
Lines 65-71 sub calculate { Link Here
65
	} else {
65
	} else {
66
		if (C4::Context->preference('item-level_itypes')) {
66
		if (C4::Context->preference('item-level_itypes')) {
67
		$sth = $dbh->prepare("
67
		$sth = $dbh->prepare("
68
        SELECT itemtype, description,items.itype AS itemtype, COUNT(*) AS total
68
        SELECT biblioitems.itemtype, description,items.itype AS itemtype, COUNT(*) AS total
69
			FROM itemtypes,items
69
			FROM itemtypes,items
70
		WHERE items.itype=itemtypes.itemtype
70
		WHERE items.itype=itemtypes.itemtype
71
			GROUP BY items.itype
71
			GROUP BY items.itype
72
- 

Return to bug 20274