@@ -, +, @@ C4/Serials.pm publisheddatetext, notes, routingnotes FROM serial WHERE subscriptionid = ? AND status IN ( 2,4,41,42,43,44,5 ) ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC " with ParamValues: 0=8] at /kohadevbox/koha/C4/Serials.pm line 688. --- C4/Serials.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) --- a/C4/Serials.pm +++ a/C4/Serials.pm @@ -660,7 +660,7 @@ sub GetSerials { publisheddatetext, planneddate,notes, routingnotes FROM serial WHERE subscriptionid = ? AND status NOT IN ( $statuses ) - ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC"; + ORDER BY IF(publisheddate IS NULL,planneddate,publisheddate) DESC"; my $sth = $dbh->prepare($query); $sth->execute($subscriptionid); @@ -682,7 +682,7 @@ sub GetSerials { FROM serial WHERE subscriptionid = ? AND status IN ( $statuses ) - ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC + ORDER BY IF(publisheddate IS NULL,planneddate,publisheddate) DESC "; $sth = $dbh->prepare($query); $sth->execute($subscriptionid); --