From 0da5b2099bcb87fc9e49ff6d2ff85d68c15e4775 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Tue, 9 Oct 2007 16:46:37 -0500 Subject: [PATCH] Recommitting left join for mysql5 Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- 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