From c70ad1cbccfd1121901622840715894e095f90d3 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Fri, 4 Oct 2019 12:02:59 +0200 Subject: [PATCH] Bug 23484: (follow-up) add parenthesis in JOIN Signed-off-by: Marcel de Rooy Signed-off-by: Martin Renvoize (cherry picked from commit 77b681b5843dabd8808e6ad3e62999f1e9421280) Signed-off-by: Fridolin Somers --- circ/pendingreserves.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 0b9744fa22..9dc59701c4 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -210,7 +210,7 @@ my $strsth = LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber LEFT JOIN issues ON items.itemnumber=issues.itemnumber LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber - LEFT JOIN circulation_rules ON items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL + LEFT JOIN circulation_rules ON ( items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL ) WHERE reserves.found IS NULL $sqldatewhere -- 2.20.1