From 2d746bd79784a0546a9fca777c9e283e235d7ad6 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Thu, 11 Oct 2007 02:20:01 -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