From c5999dbbbd1bcfb45f258140c9b1f0041bb848f6 Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Fri, 25 May 2007 15:14:43 +0000
Subject: [PATCH] BUG FIXING : Serials.pm was not Mysql5 compliant. (FROM
 table1, table2 changed to FROM table1 LEFT JOIN table2 ON.... )

---
 C4/Serials.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 2a54851aef..f21f3be13c 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -98,7 +98,8 @@ sub GetSuppliersWithLateIssues {
     my $dbh   = C4::Context->dbh;
     my $query = qq|
         SELECT DISTINCT id, name
-        FROM            subscription, serial
+        FROM            subscription 
+	LEFT JOIN       serial ON serial.subscriptionid=subscription.subscriptionid
         LEFT JOIN       aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
         WHERE           subscription.subscriptionid = serial.subscriptionid
         AND             (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4)
-- 
2.11.0