From ead92228f02ce084aca4cd31bea13f4dfc157600 Mon Sep 17 00:00:00 2001
From: rangi <rangi>
Date: Wed, 12 Jul 2006 09:15:26 +0000
Subject: [PATCH] Fixing bad sql

---
 C4/Circulation/Fines.pm | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

diff --git a/C4/Circulation/Fines.pm b/C4/Circulation/Fines.pm
index b065cba7bc..c2b0f7b242 100644
--- a/C4/Circulation/Fines.pm
+++ b/C4/Circulation/Fines.pm
@@ -155,11 +155,12 @@ sub CalcFine {
     # categoryitem table.
 
     my $sth = $dbh->prepare(
-"Select * from items,biblioitems,itemtypes,issuingrules where items.itemnumber=?
-  and items.biblioitemnumber=biblioitems.biblioitemnumber and
-  biblioitems.itemtype=itemtypes.itemtype and
-  categoryitem.itemtype=itemtypes.itemtype and
-  categoryitem.categorycode=? and (items.itemlost <> 1 or items.itemlost is NULL)"
+"SELECT * FROM items,biblioitems,itemtypes,issuingrules
+  WHERE items.itemnumber=?
+  AND items.biblioitemnumber=biblioitems.biblioitemnumber 
+  AND biblioitems.itemtype=itemtypes.itemtype 
+  AND issuingrules.itemtype=itemtypes.itemtype 
+  AND issuingrules.categorycode=? AND  (items.itemlost <> 1 OR items.itemlost is NULL)"
     );
 
     #  print $query;
-- 
2.39.5