From 2fb5db1215d965877e3376541baf5beda097049a Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Mon, 3 Aug 2020 12:27:15 +0000
Subject: [PATCH] Bug 21946: (follow-up) Restore join to biblioitems

---
 C4/Circulation.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/C4/Circulation.pm b/C4/Circulation.pm
index 07f81baeca..dfbe1eeb27 100644
--- a/C4/Circulation.pm
+++ b/C4/Circulation.pm
@@ -461,7 +461,8 @@ sub TooMany {
             if (C4::Context->preference('item-level_itypes')) {
                 $count_query .= " WHERE items.itype NOT IN ( $issuing_itemtypes_query )";
             } else {
-                $count_query .= " WHERE biblioitems.itemtype NOT IN ( $issuing_itemtypes_query )";
+                $count_query .= " JOIN biblioitems USING (biblionumber)
+                                  WHERE biblioitems.itemtype NOT IN ( $issuing_itemtypes_query )";
             }
             push @bind_params, $maxissueqty_rule->branchcode;
             push @bind_params, $maxissueqty_rule->categorycode;
-- 
2.11.0