From 0da5b2099bcb87fc9e49ff6d2ff85d68c15e4775 Mon Sep 17 00:00:00 2001
From: Henri-Damien LAURENT <henridamien@koha-fr.org>
Date: Tue, 9 Oct 2007 16:46:37 -0500
Subject: [PATCH] Recommitting left join for mysql5

Signed-off-by: Chris Cormack <crc@liblime.com>
Signed-off-by: Joshua Ferraro <jmf@liblime.com>
---
 C4/Circulation/Fines.pm | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/C4/Circulation/Fines.pm b/C4/Circulation/Fines.pm
index 1907c3dcb9..aea6b80036 100644
--- a/C4/Circulation/Fines.pm
+++ b/C4/Circulation/Fines.pm
@@ -562,11 +562,11 @@ sub GetIssuingRules {
    my ($itemnumber,$categorycode)=@_;
    my $dbh   = C4::Context->dbh();    
    my $query=qq|SELECT * 
-        FROM items,biblioitems,itemtypes,issuingrules
+        FROM items
+        LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber
+        LEFT JOIN itemtypes ON  biblioitems.itemtype=itemtypes.itemtype
+        LEFT JOIN issuingrules ON issuingrules.itemtype=itemtypes.itemtype
         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)|;
-- 
2.39.5