From 7a7a2c1e0d4f115e1469296295b9f9e13a06a1f5 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Tue, 9 Oct 2007 16:46:36 -0500 Subject: [PATCH] Revert "Changing innerjoin to left join for mysql5" This reverts commit c0dbeb8a3f4f9ab99109d42ea194b53a46235c00. 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 aea6b80036..1907c3dcb9 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 - LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber - LEFT JOIN itemtypes ON biblioitems.itemtype=itemtypes.itemtype - LEFT JOIN issuingrules ON issuingrules.itemtype=itemtypes.itemtype + 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)|; -- 2.39.5